GOPAS is a provider of highly interactive self-study courses for Office Computer Skills training. Courses on Microsoft Office, ECDL and Windows are available in English, Arabic, French, German, Czech and Slovak localisations. Read more...

MS Access 2013: Introduction

MS Access 2013: Introduction
£15.00 per seat

Buy Now


In the course MS Access 2013: Introduction, you will familiarise yourself with the terminology concerning relational databases and with the basics of working in the Access program. You will try various ways of creating tables and setting the properties of their fields. You will learn to further analyse the data in tables through select queries, including the creation of calculated fields in them. You will set relations between tables and ensure their referential integrity. You will also familiarise yourself with an easy way of creating simple forms and reports.


  • Introduction to databases
  • Program interface and the database objects
  • Creating a table in the Datasheet view
  • Creating a table in the Design view
  • Special field types and working with fields
  • Designing databases
  • Analysis of the relations between tables
  • Relations and referential integrity
  • Working with tables
  • Searching and editing records
  • Filtering and sorting records
  • Select queries
  • Sorting records in select queries
  • Working with criteria in select queries
  • Calculated fields
  • Joining tables in queries
  • Creating a lookup column
  • Editing the query of a lookup column
  • Creating forms
  • Creating reports