1 Day Course

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

• Make select queries more versatile and useful by using parameters; use action queries to update data values and add or delete records.
• Generate different query types by creating various types of joins between tables; use crosstab queries to summarize data.
• Use advanced form features including properties, functions, and design tools to facilitate data entry and improve accuracy in forms; display table information that has a one-to-many relationship by creating forms that contain subforms.
• Automate tasks by creating macros to open forms and control form properties.
• Make forms more functional by using macros to provide user interaction and automate data entry.
• Make reports more concise and easier to understand by using properties and functions in report controls; create mailing labels.
• Use Internet-related Access tools by inserting hyperlinks and using the Web toolbar.

Prerequisites

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 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

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

• Replicating databases

Appendix B: Using Access with other applications

• Linking and importing data
• Using the OfficeLinks tool