Advanced Microsoft Access 2003 Training (1 day)

Advanced Microsoft Access 2003 Training Course Overview

This Microsoft Access training course teaches students who already have experience with Microsoft Access to use the tool more efficiently and effectively.

Advanced Microsoft Access 2003 Training Course Goals

• Learn to develop a data access page, a PivotTable, and a PivotChart.
• Learn to import XML data and export Access data.
• Learn to use VBA to automate a business process.
• Learn to create and modify a database switchboard, and set and modify your startup options.
• Learn to distribute a database and add security features to it.

Advanced Microsoft Access 2003 Training Course Prerequisites

Experience in the following areas is required:

• Basic Microsoft Access

Advanced Microsoft Access 2003 Training Course Outline

1. Making Your Data Available on the Web
   1. Create a Data Access Page by Using the Wizard
   2. Improve the Presentation of the Data Access Page
   3. Viewing Data Access Pages with the Browser
   4. Edit Data Using the Data Access Page
   5. Group Records in the Data Access Page
2. Developing a Data Access Page in Design View
   1. Create a Data Access Page in Design View
   2. Incorporate a ComboBox in the Data Access Page
   3. Test the New Record Function of the Data Access Page
   4. Develop a PivotTable with the Office PivotTable Tool
   5. Develop a PivotChart
3. Integrating Access into Your Business
   1. Import XML Data into an Access Database
   2. Export Access Data to XML Format
   3. Share Data with Other Office Applications
4. Automating a Business Process with VBA
   1. Create a Standard Module
   2. Develop Code
   3. Call a Procedure from a Form
   4. Run the Procedure
5. Creating a Switchboard and Setting the Startup Options
   1. Create a Database Switchboard
   2. Modify a Database Switchboard
   3. Set the Startup Options
   4. Modify the Startup Options
6. Distributing and Securing the Database
   1. Split a Database
   2. Implement Security
   3. Set Passwords
   4. Encode and Decode a Database
   5. Convert an Access Database to an MDE File

Advanced Microsoft Access 2003 Training Course Materials

In addition to a comprehensive set of materials, including course notes and all the programming examples, each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

Advanced Microsoft Access 2003 Training Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions