Access Database

This is just some of what we offer in Access training. Please ask for a detailed Access Database Course Content Sheet to select what you would like to learn. As a general rule one day is normally enough to get to an intermediate level, or more if you have some knowledge already. Click here to see the training rates.

Choose a level or mix and match to select exactly what you wish to learn.

If you need to store customer or product information you need look no further than Microsoft Access Database. Learn in one day how to design and create a database and find selected contacts or products using a range of specified query criteria.

Access training can help you design a database to use or troubleshoot an existing one, find information on a particular product or customer, create forms and reports, mail merge or print using only the records of your choice.

Beginners

Introduction to Microsoft Access 2000, 2003 or 2007
Crossover to Access 2007
Starting an Access database
Creating a table in design view and setting data types
Table Properties
Importing Excel data
Setting and using a primary key
Entering data
Creating and using a form using the wizard
Creating and using Select Queries in Design view
Creating and using a report using the wizard

Intermediate

More on Table Properties
Input Masks and Validation rules
Lookup Wizards - creating drop down lists in your table
Setting one to one and one to many relationships
Setting filters
More on Select Query criteria
Duplicate and Delete Queries
Using Parameters in your queries
Customising your form - adding extra fields, backgrounds, colours
Editing your report and adding new data
Switchboard manager and startup

Advanced

Cross-tab and other queries
Calculation queries
Function queries
Creating, editing and running Macros
Custom forms
More on forms and subforms- properties, options, buttons
More on reports - properties, options, buttons
Advanced Relationships - joins
Lookups and hyperlinks
Setting Protection and security
Password control forms and reports
Introduction to the Visual Basic Editor
Enhance your database with some basic VBA
Finding and using Visual Basic in your database

If you are unsure of your requirements please contact me

Top of Page