Access XP/2003 Advanced

Prerequisites: Access Level 1 and Access Level 2 or equivalent knowledge.

Benefits: Students will learn how to analyze data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros, and become familiar with Internet-related Access tools.

Course content

Lesson 1: Parameter and action queries

Creating parameter queries
Creating action queries

Lesson 2: Query joins and crosstab queries

Joining tables and working with join properties
Creating crosstab queries
Editing limitations in query datasheets

Lesson 3: Using advanced form technqiues

Organizing field placement
Using functions to control data entry
Adding an option group to a form
Using a form as the user interface
Creating a form that contains a subform

Lesson 4: Creating basic macros to automate forms

Macro basics
Attaching a macro to a command button
Revising a macro
Attaching a macro to an event in a form

Lesson 5: Using macros to provide user interaction and automate tasks

Using a macro to provide user interaction
Using macros to automate data entry
AutoKeys and AutoExec macros

Lesson 6: Using advanced report techniques

Customizing the appearance and functionality of a report
Mailing and other types of labels

Lesson 7: Access 2000 and the Internet

Using hyperlinks
Access tools for working on the Internet

Appendix A: Replicating databases

Appendix B: Using Access with other applications