TARGE

TARGET AUDIENCE

This course is intended for a delegate who would have to design new tables in MS Access or users who need to link/import existing Excel data into Access. Delegates who would like to be assessed for a computer qualification or delegates who wish to obtain Microsoft Office Specialist certification would benefit from attending this course.

COURSE OVERVIEW

This course concentrates on the design of queries. Forms and Reports are handled on an introductory level only.

PREREQUISITES

It would be an advantage to have attended the MS Access Basic course, but if the user is not going to be designing tables and ONLY going to be using existing data i.e. SQL tables or tables that have already been set up, they can start with this course.
The delegates must have basic Windows skills; handling the mouse, opening and finding documents and basic typing skills. Excel knowledge would be an advantage, but is not essential.

TARGET AUDIENCE

This course is intended for a delegate who would have to design new tables in MS Access or users who need to link/import existing Excel data into Access. Delegates who would like to be assessed for a computer qualification or delegates who wish to obtain Microsoft Office Specialist certification would benefit from attending this course.

COURSE OVERVIEW

The course concentrates on designing tables in a database, setting up relationships between the tables and setting up lookups between the tables. Table properties are explained in detail. Linking/Importing from other applications is also covered. Sample database templates are used for illustration. The user is introduced to queries, forms and reports.
Delegates will be created a simple database during the course to illustrate all the features of a database.

PREREQUISITES

The delegates must have basic Windows skills; handling the mouse, opening and finding documents and basic typing skills.

Want more information about any of these programmes? Click HERE