Access 2002 Advanced training course - learn Access

Structuring Existing Data

Use the Table Analyzer Wizard for Help
Decide on Your Own Design
Create a Junction Table
Modify the Original Tables and Completing the Design
Compact and Repair a Database

Summarizing Data

Group and Summarize Records in Different Ways
Summarize with a Crosstab Query
Pivot Query Results
Display a Graphical Summary on a Form

Simplifying Tasks with Macros

Create a Macro
Attach a Macro to a Command Button
Restrict Records

Adding Interaction and Automation with Macros

Require Data Entry with a Macro
Display a Message Box with a Macro
Automate Data Entry

Making Forms More Usable

Change the Display of Data Under Certain Conditions
Display a Calendar on a Form
Organize Information with Tab Pages

Making Reports More Powerful

Cancel Printing of a Blank Report
Include a Chart
Arrange Data in Columns
Distribute Reports as a Snapshot

Expanding the Reach of Your Data

Merge Access Data with a Word Document
Publish Access Data as a Word Document
Analyze Access Data in Excel

Accessing Object Names

Overview

You will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications.

Prerequisites

Access 2002 Introduction and Access 2002 Intermediate, or equivalent knowledge.

Benefits

Students will learn advanced Access 2002 skills, including how to structure existing data, summarize data, simplify tasks with macros, add interaction and automation with macros, make forms more usable, make reports more powerful, and expand the reach of data beyond Access.

Target student

Anyone who uses Access 2002 as a tool for getting their work done. Job responsibilities might include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced capabilities, and using Access tools, as well as supporting less-advanced Access users.

What's next

Access 2002 VBA Programming, the next course in this series, teaches students how to develop custom applications using Access.

Private Training Courses

We offer private training courses which may be delivered at our training centre or at your premises on dates to suit you and your delegates. Course content can follow the standard course material as listed in the course outline, or can be tailored to your specific requirements at no extra cost.

For a single company private course we normally recommend that any class does not exceed 8 delegates in order to ensure that the learning objectives are met.

Total price per day (ex-Vat)
Number of delegates	1	2	3	4	5	6	Extra Person
At our Reading Training Centre	£495	£545	£595	£645	£695	£745	£50
On your premises	£445	£495	£545	£595	£645	£695	£50

For on-site courses only:

Notebook computer hire is £40 per computer per day. Savings can be made for block bookings of 2 or more days, please ask for details.
Trainer travel and accomodation is charged at cost and we can give you a fixed price quote for this prior to booking.

Course fees are payable in advance and are listed exclusive of VAT.