Microsoft Access Training courses • Introduction Intermediate and Advanced tutor led courses

Please enquire if you are interested in achieving MOS Certification

Check Scheduled course dates

Microsoft Access training courses

Storing large amounts of data? We'll show you how to create, administer and extract data from Microsoft Access databases. Along the way you will learn how to optimise the databases you might already be using, protect them, get clearly presented output, and link the databases with other applications such as Excel and Word.


Access Introduction

Duration 1 day

 

This course is suitable for anyone wanting to understand the basics of Microsoft Access.

By the end of the course, using practical hands-on tuition, you will have an understanding of the following features and techniques:

  1. Database terminology: Fields, records, tables, forms, queries and reports
  2. The Access screen: Menus and toolbars, database window and objects bar
  3. Creating tables: Table design, field naming and properties.
  4. Inputting data: Data entry into tables, creating records. Finding, inserting and deleting records.
  5. Data management: Sorting and filtering records - finding specific data in the database.
  6. Querying the database: Setting up queries for repetitive retrieval of information.
  7. Reporting: Creating reports for attractive information presentation.
  8. Data import and export: Importing from Excel spreadsheets or text files, exporting data to other applications

Microsoft Access Intermediate

Please enquire for details

 

Microsoft Access Advanced

Please enquire for details

 

 



The above outlines are intended as a guide only, topics may not be covered in this order. Actual course content can be tailored to suit client's needs.

Please contact us for charges and further details on either bespoke or scheduled courses.