Microsoft Access 2003, 2007, XP Advanced

Course Contents

Access Review
Objects and terminology
Tables and External Data
Table design and relationships
Normalisation of data
Primary and secondary keys
Joint primary keys
Multiple indexes
Maintaining data integrity
Importing and linking tables
Application design
Using Action Queries
What are action queries?
Make table queries
Delete queries
Append queries
Update queries
The Query Wizard
Advanced Queries
Parameter queries
Criteria in forms
Table joins
Action queries
Query Wizards (find duplicates, find unmatched and crosstab)
SQL specific queries
Union and pass-through

Advanced Forms and Reports
Form layout properties
Pop-up and modal forms
Report layout and grouping properties
Calculated fields in forms and reports
Sub-forms and sub-reports
Embedding charts on forms and reports
Advanced controls: Combo Box, List Box, Option groups and command buttons
Control Wizards
Combining queries and macros with forms and reports

Macros and Event Procedures
Introduction to macros
Events on forms and reports
Macros groups
Conditional actions
Referring to controls on forms and reports
Attaching macros to events
Debugging macros
Using expressions
 
Developing the Application
The Quick Access toolbar
Adding extra database options
Adding macros to the Quick Access toolbar
Modifying the buttons
Startup Dialog
Switchboard Manager
Security Settings
User and group accounts
Activating Access security
Setting permissions
Problems and pitfalls with Access security
The Office Button - Access Options Object Designers - setting up defaults for forms, queries and reports
Trust Centre Settings - Trusted Locations
Database Optimisation
Compacting and repairing databases
Database performance
The Analyze Performance and Table and Database Documentor
Visual Basic for Applications
Where does VBA fit in?
When to choose macros or VBA