Access 2002 - Level 3 Training Class

Lesson 1: Creating a Switchboard and Setting the Startup Options

Create a Database Switchboard
Modify a Database Switchboard
Set the Startup Options
Modify the Startup Options

Lesson 2: 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

Lesson 3: 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

Lesson 4: 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

Lesson 5: 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 Procedur