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 €190 per person

We can also provide the course on a one to one basis for €210

What about running the course on-site at your business premises?

Suggested additional courses

• Access Advanced

Back to Main Access menu