Access 97 Advanced

Prerequisites

Access 97 Introduction and Access 97 Intermediate, or equivalent knowledge.

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

Students attending this course should be able to work with Access at an intermediate level, and understand Access terminology.

Access 97 VBA Programming, the next course in this series, teaches students how to develop custom applications by using Access.

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

	Printer Friendly Version
	Download Outline As PDF

Very good - the time flew by

- DLR