Tailored Courses for IT and Business Professionals

MS Access 2003 Power User


	The copyright on these mind maps has been protected. However we are very happy to provide unprotected versions to anyone who sends an email, stating their reason for interest.

Objectives

This course provides a "no holds barred" presentation of the features of Microsoft Access 2003 and leaves delegates able to take advantage of those features to obtain more power and facility with information management. The course is also a good springboard for delegates wishing to attend the Professional Access Programming course, but who are not familiar with the MS Access development environment.

Duration

One Day

Delegates will learn ...

Data-sctructure design via advanced table design, relationships and queries
Advanced Table Design
Advanced Query Design
Taking advantage of Structured Query Language to write a variety of queries
Optimising the efficiency of queries
How to design optimal table relationships
Front-end design via Forms, Reports, Macros and VBA modules
How to build forms with linking buttons
How to validate data entry to save you from problems later
How to write and use MS Access Macros
Introduction to writing VBA module code in MS Access
Dealing with multi-user interaction
How to use the Database replication features
Database concepts that help to consolidate the experience gained.

Who Should Attend

This course is suitable for users who have either attend the MS Access Guided Tour or users who have had no formal training and have been developing databases using MS Access for at least four months. Some basic familiarity with the Microsoft Access 2003 environment is expected, although delegates who are familiar with other windows desktop databases and are looking for a fast track into MS Access development may also find this course appropriate.

Prerequisites

It is recommended that delegates attending this course have a good practical understanding of basic database construction equivalent to the MS Access Guided Tour course outline prior to attending.

Topics covered

Advanced Table Design

Indexes - Unique indexes, primary keys, multi-field indexes
Validation Rules
Table-level lookups
Using the relationships window
Referential integrity
Default query joins

Advanced Query Design

Using the "SQL" view of your queries
Storing SQL scripts - SQL is your friend!
Using parameters in queries
"Action" queries
Joins in queries
Auto fix-up
Updateable queries - what is updateable and when?
Agregation queries - Sum, Average and Count
Calculated expressions
Top values
Crosstabs
Unique values and unique records
Query optimisation

Advanced Form Design

Building a form based on joined tables
Using a function in a form
Adding an option group
Data validation techniques
Using Command Buttons and Macros with Forms
Creating command buttons
Creating macros and VBA scripts to control form properties

Advanced Report Design

Enhancing report design using design view
Understanding and using the grouping sections dialog
Demonstration of the report generator

Interaction and automation

Using macros and VBA scripts to provide user interaction in forms
Using macros and VBA scripts to automate tasks in forms