Microsoft Access 2003 Advanced
| Duration: | 1 day |
| Prerequisite: | Microsoft Access 2003 Level 2 or equivalent experience. |
| Course Materials: | Course manual (074462S3) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| 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. |
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