Access 97: Advanced

Code:

 ZD52-442

Series:

 Office Productivity

Duration:

 1 day
Designing parameter and action queries
Creating parameter queries
Creating action queries

Outer join and crosstab query techniques
Joining tables and working with join properties
Crosstab queries
Editing limitations in query datasheets

Form design enhancements
Building a form based on joined tables; using functions in forms
Using option groups and additional form design enhancements

Using command buttons and macros with forms
Creating macros and command buttons
Using macros to control form properties		 Using macros to provide user interaction and automate tasks
Using macros to provide user interaction
Using macros to automate tasks

Advanced report techniques
Hiding duplicate data, grouping data, and using functions in reports

Introduction to the Internet
Using hyperlinks

Appendices
Replicating databases
Using Access with other applications
 
Access 97: Advanced

Course specifications
Course number: 052 442
Software version number: 97
Course length: 1 day

Certification
The combined content of the Access 97: Level 1, Access 97: Level 2, and Access 97: Advanced courses satisfies the requirements for the Certified Microsoft Office User for Access 97 at the Expert level.

Course description

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

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

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.


Access 97: Advanced

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.