Access Advanced
|
Download the course outline in PDF format  |
Course objectives
At the end of the course participants will be able to:
- Understand Table Design in a practical context
- Understand and apply Field Properties
- Understand the major components of Form and Report Design
- Design customised Forms and Reports
- Create Calculated Fields within Queries
- Create and use Action Queries
- Create and use Multi-Table Queries
- Create Switchboards and Startup Forms
- Understand and use Auto lookup
- Exchange data with other applications
- Build Advanced Queries and increase Query performance
- Create complex Reports, incorporating sub reports and calculated controls
- Export data from Access in Excel
Course topics
Project Overview
- Objects
- Tables
- Forms
- Reports
- Queries
Customising Tables
- Importing Tables
- Using Link Table
- Field Properties
- Standard and Custom Formats
- Format Properties for Number Formats
- The Input Mask Property and Wizard
- Indexes Window
- Copying Tables
- Relationships
- Relationship Types
- Foreign Keys
- Relationships Window
- Adding Tables
- Creating a One to Many Relationship
Creating Complex Forms
- Using Wizards to Create Forms
- Main/Subforms
- Creating a Linked Form
- Form Design
- Controls
- The Toolbox
- Lines and Rectangles
- Labels
- Text Boxes
- Layering Controls
- AutoFormat
|
Applied Form Design
- Control Wizards
- Creating a Combo box, Button and Option Groups
- Additional Design Tools
- The Field List
- Tab Order
- Property Sheets
- Builders
- Building Expressions using the Expression Builder
- Naming Controls
Using Wizards to Create Reports
- Grouping and Subtotalling in a Report
- Creating Mailing Labels
- Mail Merge using Microsoft Word
Report Design
- Design View
- Performing Calculations in Reports
- Dates and Times
- Combining Text Values
- Page Numbers
- Summary Calculations
- Sorting and Grouping in a Report
- Formatting a Report
- Embedding Images
- White Space
Applied Queries
- Creating and Formatting Calculated Fields
- Using Calculated fields in Combo Boxes
- Creating Action, Make-Table, Append, Update, Delete and Multi-Table Queries
Database Consolidation
- Using the Switchboard Manager
- Creating a Switchboard Form
- Creating a Startup Form
- Main/Subforms
|
Pre-requisites
No prerequisites but experience with the Windows operating environment and using a keyboard and mouse is desirable.
Course duration
2 days
