Home > Courses Certifications > Microsoft Office > Access 2002 Level 3 synopsis

Microsoft Access 2002 Level 3

Access 2002 Level 1

Access 2002 Level 2

Prerequisites: Students must have completed Access 2002 Level 2 and Windows XP Level 2 or have equivalent knowledge.

Duration: 2 days

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 Procedure