Microsoft Access Advanced

Microsoft Access Advanced



Next Date



Two Days

Microsoft Access Advanced

Course Description

This course improves upon Access database usage and design.

Course Objectives

By the end of the course, delegates will be confident in using some of Access's more advanced features including queries, reports and forms.

Course Content

Relationships (If not covered at Intermediate level)
Pre-defined | Referential integrity | Normalisation

Conditional functions | NZ functions |Parameters | Parameters to unbound forms | Outer join query | Union queries | Distinct queries | Crosstab queries | Queries on queries

Graphics and graphs in reports | Sub reports | Running reports from open forms

Custom data entry forms | Using functions in forms | Subforms and graphs in forms | Using unbound forms and controls (Menus) | Using aggregate functions() in forms and reports

Imports, exports and attachments (Linked data)
Working with other database systems (Optional)
Setting Access default properties
Security in Access
Database v User level security | Enabling Access security | Using the security wizard | Creating administrator accounts

New users and groups
Changes to database ownership
Introduction to basic macros
Using and building macros | Adding buttons to forms

Building command bars and menus
Setting database defaults

Related courses

Microsoft Access Introduction

Microsoft Access Intermediate

Microsoft Excel Advanced


Simply complete the form below and we'll come back to you as soon as possible