Access Part 3

Access 2000
Part 3
Course Code: AD362

Maximise the potential of Microsoft Access. Learn how to customise menus and multiple-table forms using macros and object linking and embedding.

Objectives
After completing the course, participants will be able to:

Export Access information to an Excel spreadsheet

Create a Master-Detail form

Use tools including Database Splitter and Performance Analyser

Create and run a Macro

Create different Relationships

Create a Switchboard

What you will learn
Topics covered by this course include:

Advanced Table Design Techniques

Validating field entries

Creating a Lookup field

Advanced Form Techniques

Creating a Master-Detail Form

Adding a Picture and Date to a Form

Modifying Form properties

Using Tools Menu Options

Setting Passwords

Using various Access tools

Advanced Query Techniques

Including multiple conditions in a query

Creating Parameter and Action queries

Change the join type in a query

Modify query properties

Create a query to generate summary information

Advanced Report Techniques

Creating a Master Detail report

Modifying report properties

Adding a Picture to a report

Working with Data Access Pages

Creating and Data Access Page

Adding Grouping levels to a Data Access Page

Working with Macros

Creating and running a Macro

Advanced Access Features

Creating a Switchboard

Prerequisites
Course participants should have completed Microsoft Access Part 2 (or equivalent).

Dates and times
Courses are available either in the morning or the evening. Contact the relevant training centre for further details and enrolment information.

Š Copyright The Fourth R^Ž

[Back to MS Office Training Courses]