Access 2003: Level 4

 Course Description

Overview: Students will be introduced to the advanced features of the Access application and also the VBA programming language.

Prerequisites: Windows 2000 or Windows XP; Access 2003: Level 1; Access 2003: Level 2; Access 2003: Level 3; or equivalent knowledge.

 

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

·            develop a data access page.

·            develop a PivotTable, and a PivotChart.

·            import XML data and export Access data.

·            use VBA to automate a business process.

·            create and modify a database switchboard, and set and modify your startup options.

·            distribute a database and add security features to it.

 

Course Content

Lesson 1: Making Your Data Available on the Web

 Create a Data Access Page by Using the Wizard

 Improve the Presentation of the Data Access Page

 Viewing Data Access Pages with the Browser

 Edit Data Using the Data Access Page

 Group Records in the Data Access Page

Lesson 2: Developing a Data Access Page in Design View

 Create a Data Access Page in Design View

 Incorporate a ComboBox in the Data Access Page

 Test the New Record Function of the Data Access Page

 Develop a PivotTable with the Office PivotTable Tool

 Develop a PivotChart

Lesson 3: Integrating Access into Your Business

 Import XML Data into an Access Database

 Export Access Data to XML Format

 Share Data with Other Office Applications

Lesson 4: Automating a Business Process with VBA

 Create a Standard Module

 Develop Code

 Call a Procedure from a Form

 Run the Procedure

Lesson 5: 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 6: Distributing and Securing the Database

 Split a Database

 Implement Security

 Set Passwords

 Encode and Decode a Database

 Convert an Access Database to an MDE File