Search form


Access 2013 for Beginners


Microsoft Access offers a powerful, feature-packed solution for building a robust ?data landing pad.? This 10-hour video training course gives your team the knowledge and skills you need to make this cost effective and easy-to-use database application work for your organisation.

Access is now much more than a way to create desktop databases. It?s an easy-to-use tool for quickly creating browser-based database applications that help you run your business. Your data is automatically stored in a SQL database, so it?s more secure than ever, and you can easily share your applications with colleagues.

In this course we will cover the basics of Access working up to more intermediate uses of Access. Areas to be covered include: setting up a database, exploring the ribbon, understanding macros and much more.


  • PC or Mac with a full version of Microsoft Access 2013/2016
  • Not a requirement but a benefit to have some work-related projects to which you can readily apply what you learn.

Relevant audiences

  • People who have never used either a database or Access before but have reasonable knowledge of other Microsoft applications
  • Access 2000/2003 users who are unfamiliar with the newer versions of Access

Learning Outcomes

  • Set-up a database on your desktop, or on the web
  • Explore the Ribbon interface and how to work with touch devices
  • Use table templates to create forms and add custom elements
  • Understand Macros and how they work
  • Import data from external sources


Section 1: Foundation

  • Unit 1.1 - Access Introduction
  • Unit 1.2 - Getting Started
  • Unit 1.3 - The Access Interface
  • Unit 1.4 - Database Basics

Section 2: Tables, Forms and Data

  • Unit 2.1 - Tables
  • Unit 2.2 - Datasheet View
  • Unit 2.3 - Table Design
  • Unit 2.4 - Forms

Section 3: Queries and Reports

  • Unit 3.1 - Queries
  • Unit 3.2 - Report

Section 4: Printing, Moving Data, Templates and Forms

  • Unit 4.1 - Printing
  • Unit 4.2 - Importing and Exporting Data
  • Unit 4.3 - Templates and Application Parts
  • Unit 4.4 - More on Forms

Section 5: Macros, VBA and Security

  • Unit 5.1 - Macros, VBA and Additional Topics

Section 6: Closure

  • Unit 6.1 - Conclusion