AccessAccess Intermediate/Advanced

Create relationships between tables, more complex queries, Forms and reports across multiple tables.

Course Outline
Access Intermediate/Advanced 2 Days

Who is it for?

The course is suitable for those with an existing knowledge of Microsoft Access equivalent to the topics covered on our Introduction course wishing to enhance their existing skills. This course is based on building on the relationships and creating front end user friendly forms.


Delegates should have a basic knowledge of the Access Introduction course.

Table Relationships
Types of relationships:
  • Join Types
  • Referential Integrity
Advanced Queries
Query a database:
  • Calculated Queries
  • Action Queries
  • Multi-Table Queries
  • Cross Tab Queries
Report/Form Enhancement
Advanced Forms and Reports:
  • Creating Sub Reports/Forms
  • Calculated Fields
  • Headers and Footers
  • Calculated Fields/Functions
  • Adding Additional Controls
Database Automation
Controlling Databases:
  • Compact and Repair
  • Backup and Restore Databases
  • Protecting Databases
  • Setting Security

Tags: Microsoft Access, Software

About the Trainers

Qualifications - European Computing Driving License (ECDL) Microsoft Office Specialists (MOS) Microsoft Office User Specialist (MOUS), Microsoft Certified Applications Specialist (MCAS), 2 of our trainers have taken the Institute of Learning Management Train the Trainer Master Class Award. Every trainer has a minimum of 5 years training experience.


NC Member logo

Latest News

Windows 8 and 10

Windows 8 courses now available.

New courses for Microsoft Windows 10 will be available soon – be one of the first to see it with us.

MS Office Training

Microsoft Office weekend training and Microsoft Office 2013 upgrade training now available.


"This morning I set up a Macro (as per Thursday’s advanced course) and recorded the whole operation so I could apply to future reports downloads and ‘wow’ this has really saved so much time -thank you."

Iris Vicary, Telent

"After taking part in the intermediate and advanced excel courses I soon booked onto the word training. Nicola was both helpful and technical. The courses were just the right length and I would strongly recommend."

James Harris, Critchleys Chartered Accountants