Advanced Microsoft Access 2003 Training

Delivery Options

• Live eLearning (3 days): $675.00 (Register)

» Register Now

» Free Demo

» Watch Presentation

» Contact Education Consultant

• Customized Onsite Training (2 days): Request a Proposal

Class Date and Time	Price Volume Discounts Students Discounts 2 5% 3-4 10% 5 or more 15% GSA Price: $641.25	Register
Mar 31 - Apr 2, 2010 10:00 AM - 5:00 PM ET	$675.00 or 3 vouchers	Register
Apr 26 - 28, 2010 10:00 AM - 5:00 PM ET	$675.00 or 3 vouchers	Register
May 24 - 26, 2010 10:00 AM - 5:00 PM ET	$675.00 or 3 vouchers	Register

Class Description

Class Overview

Class Goals

• Learn to restructure an existing set of data to improve the design of a database.
• Learn to use a variety of techniques to summarize and present data with queries.
• Learn to create and revise basic Access macros.
• Learn to create macros that improve data entry efficiency and integrity.
• Learn to improve the effectiveness of data entry in forms.
• Learn to improve the effectiveness of data displayed in reports.
• Learn to maintain an Access database by using various utility tools.
• 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.

Class Outline

1. Structuring Existing Data in Microsoft Access
   1. Import Data
   2. Analyze Tables
   3. Create a Junction Table
   4. Improve Table Structure
2. Writing Advanced Queries in Microsoft Access
   1. Create Unmatched and Duplicates Queries
   2. Group and Summarize Records Using the Criteria Field
   3. Summarize Data with a Crosstab Query
   4. Create a PivotTable and a PivotChart
   5. Display a Graphical Summary on a Form
3. Simplifying Tasks with Macros in Microsoft Access
   1. Create a Macro
   2. Attach a Macro to a Command Button
   3. Restrict Records Using a Where Condition
4. Adding Interaction and Automation with Macros in Microsoft Access
   1. Require Data Entry with a Macro
   2. Display a Message Box with a Macro
   3. Automate Data Entry
5. Making Forms More Effective in Microsoft Access
   1. Change the Display of Data Conditionally
   2. Display a Calendar on a Form
   3. Organize Information with Tab Pages
6. Making Reports More Effective in Microsoft Access
   1. Cancel Printing of a Blank Report
   2. Include a Chart in a Report
   3. Arrange Data in Columns
   4. Create a Report Snapshot
   5. Maintaining an Access Database
   6. Link Tables to External Data Sources
   7. Back Up a Database
   8. Compact and Repair a Database
   9. Protect a Database with a Password
   10. Determine Object Dependency
   11. Document a Database
   12. Analyze the Performance of a Database
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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

Class Materials

All students receive a course manual or book and all the class examples.

Students in private onsite classes will also receive:

• Technical Reference Library

Class Prerequisites

Experience in the following areas is required:

• Basic Microsoft Access

Courses that can help you meet these prerequisites:

• Introduction to Microsoft Access 2003

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

• Course technical requirements and setup instructions.