Home » MS Access

MS Access

Our Microsoft Access training courses will show you how to get the most from this powerful database application. Access is a popular database programme enabling the user to manipulate data in a number of ways. Data can be analysed and sorted, specific information can be searched for, and the results can be used to produce reports, lists and more. Microsoft Access is extremely flexible and can be linked to data stored in other applications or to databases held in other programs (for example, Excel). Access is part of the Microsoft Office suite and so widely available. This also means that visual basic for applications (VBA) can be used to customise MS Access. 

Led by highly experienced MS Access trainers with many years of experience our hands-on training courses mean that you will leave with practical experience as well as useful tips and tricks. You will learn skills needed to work with MS Access, including creating and working with tables, relationships, queries, forms, reports and macros.

We run scheduled Access training courses at two levels and use Access on Windows for the training. One-to-one or group bookings can also be arranged on dates to suit you and customised to your specific requirements. We are very happy to organise these courses anywhere in the UK.

Introduction to Access

  • Software and Screen Overview
  • Creating Tables, Relationships
  • Formatting Tables
  • Entering Data Into Tables
  • Select Queries
  • Advanced Queries
  • Action Queries
  • Functions ( Sum, Max etc )
  • Creating Basic Forms
  • Creating Reports

Advanced Access

  • Advanced Functions
  • Subdatasheets
  • Adding Controls To A Form
  • Creating Advanced Reports
  • Exporting / Importing Data
  • Advanced Forms
  • Interacting with Other Applications
  • Command Buttons and Combo Boxes
  • Active X Controls
  • Macros  

To contact us for further information Click Here

 

September 2020
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
282930