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

Hints & tips

The textbox class in Visual FoxPro 9 has a new Autocomplete property which shows the user the previous values that have been entered in that textbox.
Autocomplete in VFP 9

Your Access database will look more impressive if you add custom toolbars...
Custom toolbars

FoxPro has always had functions to read and write files at a low level...
Foxpro low level file functions

More...
More pages of hints and tips for users of Microsoft FoxPro and Access databases.

Site Map