Access 2002 Part 3

Access 2003
Part 3
Course Code: AD538

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:

Create and validate fields
Create a Master-Detail form
Create queries and adjust as required
Create a master detail report
Utilise special queries including Action and Parameter
Export Access data to an XML document
Create a database password
Create and run a command button macro
Learn how to use tools and additional advanced access features

What you will learn
Topics covered by this course include:

Advanced Table Design Techniques

Validating field entries

Creating a Custom Input Mask

Advanced Form Techniques

Creating a Master-Detail Form

Adding a Picture and Date to a Form

Modifying Form properties

Advanced Filter and Query Techniques

Including multiple conditions in a query

Creating Parameter and Action queries

Create an advanced Filter

Advanced Report Techniques

Creating a Master Detail report

Completing the report

Add a Cover sheet to a report

Modifying Report Properties

Working with Macros and Modules

Creating and running a Macro

Creating a Command Button Macro

Writing an Event Procedure

Using Tools menu options

Setting up Start up options

Setting a Database password

Using Splitter and Linked manager

Creating a Replica

Encode and Decode a database

Additional Advanced Access Features

Creating a Many-to-Many relationship

Creating a Switchboard

Exporting Access Data to an XML document

Saving an Access Database into a MDE file

Creating an Access Workgroup

Macro Security

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]