Microsoft Access Intermediate

Microsoft Access Intermediate

One Day Course

Course Aims:
This course is designed to provide delegates with the knowledge and skills needed to handle the intermediate features of Access.
In particular, delegates will learn how to work with relational tables and how to manipulate the advanced features of forms, reports and queries.

Assumed Knowledge:
Delegates must have a good working knowledge of Access. They must be regular users who have built Access databases. They must be able to create and maintain basic tables, forms, queries and reports. It is an advantage to have attended the Jarrold Training Access Introduction course.

Course Outline:

Course Introduction
· Revision exercise
Advanced Table Design
· Advanced field properties including Input Masks
· Multiple field primary keys
· Multiple field indexes
· Documenting indexes
· Using the Access Documenter
Relational Concepts
· Relational concepts & rules
· Data structure principles
· Types of relationship
· Referential integrity
· Relating tables
Multiple Tables and Forms
· Using a combo box in forms
· Combo box properties
· LookUp fields in tables
· LookUp properties
· Creating forms with subforms
· Editing subforms
· Embedding subforms using drag & drop
Advanced Select Queries
· Working with multiple tables
· Calculations in queries
· Using wildcards & parameters
· Understanding query join types
Advanced Reports
· Working with multiple tables
· Concatenating fields
· Date & time functions
· String functions(


)Follow on course:
Access Advanced