Advanced Access 2010 Training Course:

This is a two-day course for database designers who want to make use of advanced features and programming in Microsoft Access 2010. 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.

Microsoft Access 2010 Advanced Training Course Content - Duration 2 days

Module 1 –Introduction
Main tasks of an Access databases
Review of database design
Objectives
Relational models
Indexes
Managing data integrity

Module 2 - Forms in Access 2010
Overview
Multi-table forms
Query by form
Advanced form design
The property sheet
The toolbox
Calculated controls
The expression builder
Form events
Attaching macros to buttons
Using conditions in macros

Module 3 - Queries in Access 2010
Review
Criteria
Join properties
Find unmatched & find duplicates
Calculations

Module 4 – Reports
Review criteria
Grouping in reports
Calculations
Report design issues

Module 5 –Switchboards (User Interface)
Switchboard design
Using macros to control flow
Create a start-up splash screen

Module 6 – Performance Issues
Optimising multiuser performance
Record locking strategies
Linked table performance
Form and subform performance

Module 7– Customisation and Administration
Database administration
Backing up the database
Compressing the database
Security and permissions
Encrypting the database

Module 8 – Further Macros
Simple macros
Autoexec macros
Conditional macros
Group macros
Macros to control flow through the application

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