Access 97: Advanced

Course description

Overview: Students will learn how to create action queries, more efficient forms and reports, and macros.

Prerequisites: Access 97: Levels 1 and 2 or equivalent knowledge.

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 by using parameters; and use action queries to update data values and add or delete records.
• Refine the information derived from queries by creating outer joins and using crosstab queries.
• Enhance form design by manipulating control object properties.
• Automate simple tasks by creating macros to open forms and control form properties.
• Make forms more functional and automate tasks by creating macros.
• Enhance the design of reports by hiding repetitive data, grouping data on prefix values, and using functions in controls.
• Use Access to create links to Internet sites, and to save data as HTML documents.

Course Content

Lesson 1: Designing parameter and action queries

Creating parameter queries

Creating action queries

Lesson 2: Outer join and crosstab query techniques

Joining tables and working with join properties

Crosstab queries

Editing limitations in query datasheets

Lesson 3: Form design enhancements

Building a form based on joined tables; using functions in forms

Using option groups and additional form design enhancements

Lesson 4: Using command buttons and macros with forms

Creating macros and command buttons

Using macros to control form properties

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

Using macros to provide user interaction

Using macros to automate tasks

Lesson 6: Advanced report techniques

Hiding duplicate data, grouping data, and using functions in reports

Lesson 7: Introduction to the Internet

Using hyperlinks