0845 450 6120

Microsoft Access Advanced

At the end of this course you will have a complete understanding of the higher functions of Access.


Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details



Learning Objectives

  • You will learn to automate functions by creating simple and then very advanced macros.
  • You will advance your querying ability and then to use SQL statements in your queries.
  • You will discover how to work with objects, and the fundamentals of database management.
  • Finally you will be taught how to protect your valuable data sources.


A good working knowledge of Access is required

Course Content

Advanced Data Management
• Referential Integrity  • Table Relationships  • An Introduction to SQL  • Modal Dialog Boxes 
Advanced Form Tasks
• Using Subforms  • Creating a Navigation Form  • Advanced Form Controls  • Exporting a Form  • Other Form Tasks 
Pivoting Data
• Creating a PivotTable  • Using PivotTables  • Advanced PivotTable Tasks  • Creating a PivotChart  • More on PivotCharts 
SQL and Microsoft Access
• Understanding SQL  • Using the SELECT Statement  • Using Subqueries  • Using SQL Joins 
Macros and Visual Basic for Applications (VBA)
• Macro Basics  • More about Macros  • Access and VBA  • Building Advanced Procedures  • Using VBA in a Database 
One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include