Course Introduction

Microsoft Access is an information management tool that allows the users to analyse and manage a large amount of data more efficiently than any other spreadsheet application. It is the database application in the Microsoft Office that help professionals to store information for referencing, reporting and analysis. The Microsoft Access Masterclass training course provides essential knowledge and skills required to enter, store, and retrieve data for referencing and creating reports. The course enables the delegates to create complex queries, make forms and build a database with a good relational structure. During the one day course, the delegates will learn how to create basic to advanced reports, design Access databases, manage interfaces with Access Forms and automate tasks with Macros and VBA.

  • topics-icons

    Design advanced queries, forms and reports

  • topics-icons

    Learn how to save your all data in one place

  • topics-icons

    Use conditional formatting and advanced report techniques

  • topics-icons

    Learn how Access can work with Other Microsoft Office programs

  • topics-icons

    Course delivered by Certified and experienced Microsoft Trainers

What’s included

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

exam

Tutor Support

exam

Certificate

exam

Refreshment

Prerequisites

No formal prerequisites are required for attending the Microsoft Access Masterclass training course. However, the candidates should have basic knowledge of working with Window operating system and Microsoft Office 2010.

Show More

Delegates will learn how to

  • Get to know about the database and its related terminology
  • Learn how to create databases with objects
  • Work effectively with reports, data, queries and forms
  • Learn how to automate the processes using macros
  • Understand advanced Query techniques and forms
  • Learn to organise the database to maintain efficiency and performance
  • Customise reports for organising the information displayed to have specific print layouts
  • Discover the method to join tables for retrieving data from unrelated tables
  • Learn how advanced queries can be used to manipulate the data
  • Learn to plan and validate the data entered into the database
Show More

Target Audience

The Microsoft Access Masterclass training course is designed for anyone who wants to improve their knowledge and skill set with Access. These include:

  • Data Administrators
  • Data Analysts
  • Data Architects
  • Programmers
Show More

Course Information

Microsoft Access Masterclass Schedules

Course Name Duration Dates Price
Microsoft Access Masterclass 1 Day Southampton
23-03-2018 £2199.00
Microsoft Access Masterclass 1 Day Southampton
25-05-2018 £2199.00
Microsoft Access Masterclass 1 Day Southampton
27-07-2018 £2199.00
Microsoft Access Masterclass 1 Day Southampton
28-09-2018 £2199.00
Microsoft Access Masterclass 1 Day Southampton
23-11-2018 £2199.00
Microsoft Access Masterclass 1 Day London
23-03-2018 £995.00
Microsoft Access Masterclass 1 Day London
25-05-2018 £995.00
Microsoft Access Masterclass 1 Day London
27-07-2018 £995.00
Microsoft Access Masterclass 1 Day London
28-09-2018 £995.00
Microsoft Access Masterclass 1 Day London
23-11-2018 £995.00
Southampton

Southampton

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
001008