Access: Advanced
Overview: 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.
Table of Contents
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