MS Access - Intermediate
Course Description
This course explains how to use Microsoft Access for intermediate level Databases.
This course is intended for those who have completed an introduction course to Access.
Course Content
- Working with the Sample Database
- Designing Tables
- Normalising Data
- Establishing Relationships
- Working with Indexes
- Working with Data Types
- Designing Queries
- Creating Action Queries
- Creating Paramater Queries
- Creating Calculated Columns
- Joining Tables
- Designing Forms
- Creating Data Entry Forms
- Working with Subforms
- Creating Pop-Up forms
- Working with Switchboards
- Designing Reports
- Working with Standard Reports
- Working with SubReports
- Creating Pop-Up Reports
- Working with report Snapshots
- Developing Data Access pages
- Working with Pivot Tables and Charts
- Importing & Exporting
- Building Expressions
Course Duration
One full day 9.30 am - 4.30 pm
Course Fee
Course fee is €180 per person
We can also provide the course on a one to one basis for €200
Suggested additional courses
Back to Main Access menu
