Training Overview: Intermediate Microsoft Access
This course is intended for users who have a basic understanding of Microsoft Access (able to design their own database and produce simple queries and reports), or who have attended the Microsoft Access Introduction training course. It will enhance their existing knowledge and give them an understanding of the major features and functions within Access.
Course Content
Forms
- Advantages of forms in access
- Creating an autoform
- Using the form wizard
- Design a form
- Bound and unbound controls
- Text boxes and labels
- Toggle buttons and boxes
- Field list and subforms
Reports
- Important steps to designing reports
- Creating reports and report properties
- Sorting and grouping
- Calculations on reports
- Using the chart wizard
- Using the label wizard
Relational Databases
- Concepts of a relational database
- Normalisation - splitting tables
- Primary and secondary keys
- Types of relationship
- Creating the relationship
- Referential integrity - data accuracy
Setting Field Properties
- Validation rules and input masks
- Lookup fields
- Creating a combo box
Format
This course is instructor led in a classroom environment. We recommend a maximum of 8 delegates per course to ensure that all delegates gain the maximum benefit from the course.
Duration
This is a one day course. Standard hours are 9:30 to 16:30, with a one hour lunch break, and short breaks mid morning and mid afternoon. It may be possible to change this arrangement by request.
| 
