Microsoft Access 2002 Level 4
| Duration: | 1 day |
| Prerequisite: | Microsoft Access 2002 Level 3 or equivalent experience |
| Course Materials: | Course manual (084403S3) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | You will extend your Access skills to create and implement switchboard forms, to develop data access pages that include advanced controls, to protect that information using security protocols, and to make your data more accessible and portable. Then you will take the next step up to the world of VBA programming. |
Creating a Switchboard and Setting the Startup Options
Create a Database Switchboard
Modify a Database Switchboard
Set the Startup Options
Modify the Startup Options
Developing a Data Access Page and Including a PivotTable and PivotChart
Create a Data Access Page in Design View
Incorporate a ComboBox Control in the Data Access Page
View Data Access Pages with the Browser
Add Records to a Database Using the Data Access Page
Plan a PivotTable
Develop a PivotTable with the Office PivotTable Tool
Develop a PivotChart from a PivotTable
Distributing and Securing the Database
Split a Database
Implement Security
Set Passwords
Encrypt and Decrypt a Database
Convert an Access Database to an MDE File
Integrating Access into Your Business
Link Tables to External Data Sources
Import XML Data into an Access Database
Export Access Data to XML Format
Replicate an Access Database
Automating a Business Process with VBA
Create a Standard Module
Create and Insert a Procedure
Develop Procedure Code
Call a Procedure from a Form
Run the Procedure