Microsoft Access 2007: Advanced

Course Overview

A comprehensive course exploring the more advanced features of Access. The course will expand on the basic principles covered in WDR's Access Primary course.

Microsoft are one of the world's popular software companies, this Access course will help keep your skills up to date.

Related Courses

• Microsoft Access 2007: Introduction for Beginners (2 day)
• Microsoft Access 2007: Building Applications with microsoft Access
• Microsoft Access 2007: Introduction for Beginners (1 day)
• Microsoft Access 2007: Advanced (1 day)
• Microsoft Access 2007: Level 4 (1 day)
• Microsoft Access 2007: Intermediate (1 day)
• Microsoft Access 2007: Introduction for Beginners
• Microsoft Access 2007: Intermediate
• Microsoft Access 2007: Introduction and Intermediate
• Microsoft Access 2007: Visual Basic for Applications (VBA)

Audience

This course is aimed at users of Access who require a greater knowledge of the application.

Skills Gained

The course is designed to give delegates a better understanding of Access. It concentrates on the features of Access that provide a smoother interface between user and database, in particular, using forms and macros to automate database operations.

By the end of this course you will have learned

• How to use calculations in queries;
• how to change a query type and use functions in queries;
• how to set defaults for forms;
• how to design advanced combo and list boxes;
• how to use option groups;
• how to create a subform;
• how to enter expressions in reports;
• how to create subtotals;
• how to design macros;
• how to add macro buttons to forms;
• how to group macros; conditional macros;
• how to assign macros to events;
• how to customise toolbars and menus.

Prerequisites

Knowledge of basic Access operation, as outlined in WDR's Access Primary synopsis.

Course Outline

Queries Aggregate queries;

• using calculations;
• changing a query type;
• using functions in queriesForms Setting properties for forms;
• setting defaults for forms;
• advanced combo and list boxes;
• use of option groups;
• calculated controls;
• creating a main form / subform; linking forms.

Macros Designing macros;

• macro actions;
• adding macro buttons to forms;
• grouping macros;
• conditional macros;
• assigning macros to events.

Toolbars and Menus Customising toolbars;

• creating custom toolbars;
• customising menus;
• creating custom menu bars;
• attaching menus and toolbars to forms;
• customising startup.

Reports Entering expressions in reports;

• creating subtotals;
• using queries to produce reports;
• adding objects to reports