Microsoft Access 2003 Level 3
Parameter and action queries
Creating parameter queries
Creating action queries
Query joins and crosstab queries
Joining tables and working with join properties
Creating crosstab queries
Editing limitations in query datasheets
Using advanced form techniques
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
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
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
Using advanced report techniques
Customizing the appearance and functionality of a report
Mailing and other types of labels
Access 2003 and the Internet
Using hyperlinks
Access tools for working on the Internet
Class Information
Duration: 1 day
Prerequisite: Microsoft Access 2003 Level 2 or equivalent experience.
Course Materials: Course manual (074462S3)
Description: Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.