Microsoft Access Advanced 2007/2010 | Training Course

If you are a power Access user and want to learn the Microsoft Access advanced functions, then this course is definitely for you.

This Microsoft Access Advanced, 1-day course builds upon the skills covered on our Microsoft Access Introduction Course, and is designed to equip users with the ability to develop and support robust Access systems, analyse data by creating complex queries and automate repetitive tasks by creating macros.

Microsoft Access is a powerful database creation and management tool, which enables users to manipulate data in a wide variety of ways. It allows users to input, search, store and extract large amounts of data quickly and easily. Access also provides templates, reports, database designs and Macros that help users to manage database systems more efficiently. Learning how to use Microsoft Access is an investment in both your personal and professional life. .

In this Microsoft Access Advanced training, you will learn how to design a relational database, encrypt and decrypt databases, compress and repair a database and create and run Macros. You will discover how you can save time by intuitively navigating screens panels with Access’ switchboard feature and learn how to set up strong passwords to protect your databases.

If you are a power Access user and want to learn Microsoft Access advanced functions, then this course is definitely for you.

Completing this course qualifies you for our Microsoft Access VBA (2007/2010) course.


  • You should be confident using Microsoft Access at an intermediate level or have gained similar knowledge in the workplace. Attendance of our Microsoft Access Intermediate Course is ideal.
  • A working installation of Microsoft Access. Buy it or obtain a trial version from the Microsoft website.

Why take this course?

Have better control over your databases - Access databases provide a central location to store and retrieve data, giving greater control over access to the information.

Boost productivity -  You will learn useful tips and tricks to help you to accomplish more.

Secure your valuable data - Learning how to use Microsoft Access' enables you to encrypt and password protect database files.  

Make better business decisions -  Gain better insight and make better decisions by using Access' tools to sort and analyse data in your databases.  

Who should take this course?

  • Users who need to know how to develop relational databases and automate operations in Microsoft Access.
  • Intermediate level users looking to expand on their Access capabilities in a short space of time.
  • Self-taught users with a good understanding of Microsoft Access who need to upgrade their skills.


1 days

Request Training

t: 0203 941 4100 | e:

1-Day Course Content

  • Designing a relational database
  • Normalisation of data
  • De-normalisation
  • Documenting and analysing the database structure
  • Compacting and repairing a database
  • Encrypting and decrypting a database
  • Importing objects
  • Exporting objects
  • Linking Access objects
  • What is a macro
  • What are macro actions
  • Creating a macro
  • Creating a macro group
  • Creating an embedded macro
  • Conditional macros
  • Running a macro
  • Creating macros for data transfer
  • What is a switchboard
  • Creating a switchboard
  • Adding, editing and deleting a switchboard
  • Displaying a switchboard automatically upon opening a database
  • Security overview
  • Protecting databases
  • Setting passwords