Microsoft Access Database Training

Our database training courses cover versions of Microsoft Access from 97 to 2007 for all levels of database users and programmers. We do not run scheduled public courses and there is no fixed syllabus. Each presentation is designed to suit the needs of the delegates, their level of knowledge at the start of the course and the level of expertise that they need to achieve.

We use Access databases ourselves every day - both as users of our internal business enquiries and course-booking databases and as developers of new systems. We know the problems you are likely to meet and our experience allows us to tailor the courses and respond to your questions.

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 up to a maximum of six.

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

Introductory courses

Introductory training course for staff who need to be able to use existing Microsoft 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 courses

Intermediate training 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 and programming courses

Advanced training course for staff who are experienced users of Microsoft 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

Call us now

Contact us if you are thinking of using an Access database or if you would like to make better use of your existing Access database.

Phone us on 0121 445 1300 or 07850 274902, email sales@alvechurchdata.co.uk, or get full details from our address page.