Advanced Access Training Course:

This is a two-day course for database designers who want to make use of advanced features and programming in Microsoft Access. You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and also by performing database maintenance.

Delegates require a good understanding of the features detailed in our Introduction course. Delegates must have developed a relational database and be familiar with form/report design and customisation.

ACCESS ADVANCED
Review of Basics
Main tasks of Access databases
Review of database design
Objectives
Relational models
Indexes
Managing data integrity

ADVANCED ACCESS FORMS
Identify appropriate use for subforms
Multi-table forms
Query by form
Advanced form design
The property sheet
The toolbox
Calculated controls
The expression builder
Form events
Attaching macros to push buttons
Using conditions in macros
Setting up a main menu form

QUERIES
Review as required
Criteria
Join properties
Create crosstab queries
Declaring parameters in crosstab queries
Action queries
Find unmatched & find duplicates
Calculations

SHARING DATA
Use query results in mailmerge
Export data to Excel
Export data to other databases
Snapshots.

PERFORMANCE ISSUES
Optimising Multiuser performance
Record locking strategies
Linked table performance
Form and subform performance

CUSTOMISATION & ADMINISTRATION
Database administration
Backing up the database
Compressing the database
Security, users, groups and permissions
Encrypting the database
The data dictionary

ACCESS VBA
Introduction to an Object Oriented Language
The Visual Basic Editor
Creating and modifying event procedures
Converting macros to Visual Basic
Adding general procedures in a form module.

UTILISE WEB CAPABILITY
Create hyperlinks in Access
Build order forms for Internet use

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk