Access 2003: Level 4

 

Performance-Based Objectives

·         Develop A Data Access Page.

·         Develop A Data Access Page, A Pivot table, And A Pivot chart.

·         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

·         Ceate 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

 

Appendix A: Microsoft Office Specialist Program