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