Background

This course offers a thorough understanding of the advanced capabilities of Access and aims to give participants the confidence to integrate the software effectively and efficiently in their work place. On completion of the course, delegates will be able to design flexible databases to suit their own working environment.

Who should attend

Delegates need to be experienced users of the program.

What they will learn

• Making select queries more versatile by using parameters
• Refining information derived from queries by creating outer joins and using Crosstab queries
• Enhancing form design by manipulating control properties
• Automating simple tasks using macros
• Enhancing the design of reports by hiding repetitive data, grouping data and using functions in controls

Course Outline

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

Advanced 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

Advanced Reports
Review criteria
Parameters
Advanced properties
Grouping in reports
Filters
Calculations
Reports design issues

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 and 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
Build order forms for Internet use
Pages