Course Introduction

In Microsoft Access 2013 Advanced course participants will gain an in- depth knowledge about its advanced features. During this course, learn how to use macros, create and maintain tables, forms, queries, macros and tools to create a professional, working database and ways to link it with other data sources. Along with this learn about practical techniques which allow connecting, report and packaging data quickly and finding the means to split a database by segregating its front end and back end.

With the help of this course participants will learn the required skills which are required to make an impact with sleek & high performing databases which helps individuals to do their job with a superior approach.

  • topics-icons

    Microsoft Access is a very popular and widely used database program enabling the user to manipulate data in a different ways

  • topics-icons

    Learn to split a database into frontend and backend

  • topics-icons

    Explore Visual Basic for Applications (VBA) and advanced options for using forms

  • topics-icons

    Gain the ability to construct advanced queries, design forms using pivot table and chart for more data retrieval and handling records

  • topics-icons

    Enhance your existing Access Databases knowledge and gain the certification

  • topics-icons

    Make use of available opportunities in Microsoft Access and enhance your earning potential

What’s included

BPT offers more benefits. Here is what's included with this course:


Key Learning Points


Tutor Support




To enrol into this course delegate must have knowledge about:

  • Steps required to design and develop a database.
  • Creating tables and their relationships.
  • Controlling entry of data with field properties.
  • Creating queries and understand query joins
  • Creating reports as well as sub reports
  • Adding as well as format controls on forms and reports
  • Importing and exporting data
Show More

Delegates will learn how to

After the end of this course delegates will be able to:

  • Create as well as customise advanced forms.
  • Work with validation of data.
  • Create and revise Access 2013 macros.
  • Use available tools to manage database efficiency.
  • Distribute and enhance the security of databases.
  • Work with switchboards and start up options
Show More

Target Audience

Anyone having basic knowledge of Microsoft Access can enrol into this course.

Show More

Course Information



Our state of the art venue based in Southampton has the latest learning tools to help you enhance your skills as a professional proje... Learn More

Popular Locations

Reaching You Across The World

enquireEnquiry call02380