Access 2003 Advanced

Course Length

Full day

Prerequisites

Access 2003 Intermediate or equivalent experience

Course Description

This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

Course Topics

Structure existing data

• Import data

• Analyze tables

• Create a junction table

• Improve table structure

Write advanced queries

• Create unmatched and duplicates queries

• Group and summarize records using the criteria field

• Summarize data with a crosstab query

• Create a Pivot Table and a Pivot Chart

• Display a graphical summary on a form

Simplify tasks with macros

• Create a macro

• Attach a macro to a command button

• Restrict records using a where condition

Add interaction and automation with macros

• Require data entry with a macro

• Display a message box with a macro

• Automate data entry

Make forms more effective

• Change the display of data conditionally

• Display a calendar on a form

• Organize information with tab pages

Make more effective

• Cancel printing of a blank report

• Include a chart in a report

• Arrange data in columns

• Create a report snapshot

Maintain an Access database

• Link tables to external data sources

• Back up a database

• Compact and repair a database

• Protect a database with a password

• Determine object dependency

• Document a database

• Analyze the performance of a database

What Participants Receive

Each participant receives a guide containing step-by-step instructions and practice exercises.

[Home   |   Services   |   Courses   |   Instructors  |  References  |  Contact Us]