Access 97: Advanced

Course length: 1 day

Course description

Overview: Students will learn how to create action queries, more efficient forms and reports, and macros. This course meets the Microsoft Proficiency Guidelines for Access at the Expert level.

Prerequisites: To ensure your continued success, students are strongly encouraged to first complete the Software Training courses, Access 97: Level 1 and Access 97: Level 2 or have equivalent knowledge, and have a basic understanding of your computer's operating system, and the Internet. For example, you should know how to launch an application, create and save files, and copy files from CDs and other media. The classes, Windows 98: Introduction, and Internet Explorer 5.x are designed to teach these skills, though they are not required.

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits: Students will learn how to analyze data by creating complex queries, speed repetitive tasks by creating macros, and work with Access on the Internet.

Target student: Students enrolling in this course should be able to work with Access at an intermediate level, and understand Access terminology.

What's next: Access 97: Introduction to Application Development, the next course in this series, teaches students how to develop custom applications by using Access.

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