INTRODUCTORY
WHO
SHOULD ATTEND
Microsoft Access users or potential users with little or no previous experience of the product.
COURSE OBJECTIVES
This course gives participants a solid grounding in the essential features
of Microsoft Access and general Database techniques.
COURSE
CONTENT
On
successful completion of this course participants will be able to:
~ Understand the underlying concepts, terminology & components of a
Microsoft Access Database.
~ Create & modify the design of tables.
~ Define, Set and Remove Primary Keys.
~ Input, Edit, Find and Delete Records.
~ Understand the underlying concept and implementation of relationships.
~ Create & modify the design of forms.
~ Create single / multiple table select queries to sort / search / analyse
data.
~ Create and modify the design of reports to print / analyse data.
~ Create macros to automate repetitive tasks.
~ Design and implement a simple, button driven user interface.
THE COURSE CONTENT CAN BE TAILORED TO SUIT AN INDIVIDUAL
OR GROUP NEEDS
DURATION 2 Days
COURSE TIMES 9.30 a.m. - 5.00 p.m.
REGISTRATION 9.15 a.m.
RESERVING
A PLACE Telephone and submit a booking form or fax confirmation.
ADVANCED COURSE
WHO
SHOULD ATTEND
This course is aimed at those who have completed a Microsoft Access Introductory course or who are very familiar with Microsoft Access.
COURSE OBJECTIVES
The objective of this course is to give existing and practised Microsoft Access users a higher level of understanding and proficiency.
COURSE
CONTENT
The course content is as follows:
~
Relationships
~ Join Types
~ Up date Queries
~ Parameter Queries
~ Expressions
~ Autolookup queries / Forms
~ Form Properties
~ Combo Boxes
~ Command Buttons
~ Main / Subform / Sub Subforms
~ Linking Forms
~ Pop Up Forms
~ Menu Builder
~ Macros
~ User Interface Design
THE COURSE CONTENT CAN BE TAILORED TO SUIT AN INDIVIDUAL OR GROUP NEEDS
DURATION 1 Day
COURSE TIMES 9.30 a.m. - 5.00 p.m.
REGISTRATION 9.15 a.m.
RESERVING A PLACE Telephone and submit booking form or fax confirmation.