Advanced Microsoft Access

Course content

Creating Powerful Tables

• Modify field and table properties
• Using validation rules
• Creating input masks
• Using lookups

Relational Database Summary

• The relational model
• Types of relationships
• Referential integrity

Advanced Queries

• Calculations using queries
• Performing custom calculations
• Parameter queries
• Table joins
• Finding unmatched and duplicate records
• Creating crosstab queries
• Common Access Functions

Advanced Form Design

• Creating and using sub forms
• Calculated fields and expressions
• The expression builder
• Combo and list boxes
• Page tabs
• Option groups and option fields
• Use of unbound fields
• Using sub reports

Reports Review

• Multiple table reports
• Parameter query reports
• Grouping and sorting data
• Adding calculated fields

Macros

• Creating and running a macro
• Command buttons
• Using macros in form
• Grouping macros
• Using conditions in macros
• Synchronising forms
• Custom menus using menu builder

Events on Forms

Form window events
Keyboard events
Data events
Error and timing events
Focus events
Mouse events
Attaching macros to events

Database Security

• Groups and users
• General approach
• Compacting, repairing and encrypting databases

Prices will vary depending on your requirements and the number of delegates participating in the training. We can offer scheduled courses and on or off site training specifically for your company at a fixed daily rate.