Access 2002 Part 3

Access 2002
Part 3
Course Code: AD514

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
Produce Pivot Charts and Tables
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 Lookup field

Creating a Custom Input Mask

Advanced Form Techniques

Creating a Master-Detail Form

Adding a Picture and Date to a Form

Modifying Form properties

Representing Data in a Chart

Creating a Chart

Modifying a Chart

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

Modifying Report Properties

Working with Macros and Modules

Creating and running a Macro

Creating a Command Button Macro

Writing an Event Procedure

Creating Pivot Tables and Pivot Charts

Adding a Pivot Table and Pivot Chart to a Data Access Page

Advanced Advanced Access Features

Creating a Many-to-Many relationship

Creating a One-To-One relationship

Creating a Switchboard

Exporting Access Data to an XML document

Saving an Access Database into a MDE file

Creating an Access Workgroup

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]