Access 97 Advanced

Course Description
Course Outline

Prerequisites

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

Benefits

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

Target student

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

What's next

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

We offer a range of Access training courses

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

Publisher:	Microsoft
Version:	97
Length:	1 day
Course-ID:	052442

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Delightful atmosphere, very pleasant. 1:1 training is a real luxury and I found the whole day extremely beneficial. Trainer answered all my questions very well. I'm sure I will be able to use my new skills regularly

- Boxclever