Visit our new web pages

We have launched a new extended set of web pages at www.alvechurchdata.co.uk. These old pages will stay on the server because people still have links to them but they will not be updated.

The new version of this page is at www.alvechurchdata.co.uk/services/adtacc.html.

Microsoft Access Database Training

Our database training courses cover Access 97, Access 200 and Access XP for all levels of database users and developers. There is no fixed syllabus, each course is designed to suit the needs of your delegates, their level of knowledge at the start of the course and the level they need to achieve.

The outlines below are typical choices for three different types of delegate. We can run these courses as one-to-one tutorials, as workshops for small groups, or as formal classroom lessons for larger groups.

We provide free telephone and email support to delegates for three months after the end of the course.

• Introduction course for staff who need to be able to use existing Access databases for data entry and for simple search and reporting tasks.
• Database concepts.
• Using Access menus and toolbars
• Formatting tables.
• Searching for data; Creating and applying filters
• Adding and changing data
• Deleting records
• Designing and printing reports


• Intermediate course for staff who are experienced users of Access and who have responsibility for the reliable and accurate storage and retrieval of information.
• Designing a database; Relational concepts
• Moving data between Access databases
• Make Table, Delete and Update Queries
• Reporting from several databases; Groups and subtotals
• Writing and using macros
• Importing and exporting data
• Using the Form Wizard
• Switchboard forms


• Advanced course for staff who are experienced users of Access or programmers in another language and who are beginning to develop complete database systems in Access.
• Comparing Macros and Visual Basic for Applications
• The VBA Editor
• Modifying wizard-generated forms
• Class, Form, and Code modules
• Type and scope of variables
• Using the debugger