You will learn

How to create queries, databases, forms and reports.

Implement, extract and report on data.

How to use formulae and relationships.

====================

Audience

Holders of ECDL or MOS Comprehensive level Certification.

Anyone wishing to enhance their employment opportunities.

====================

7 weeks X 3 hours

====================

This course is designed to develop ability in using many of the advance tools available within Microsoft Access.

· Field validation, input masks and lookup.

· Many-to-many table relationships and referential integrity

· Inner, outer and self joins

· Queries that append, update and delete table records

· Queries that use functions, crosstabs and wildcards

· Queries that use arithmetic and logical expressions

· Showing duplicates, unmatched values, highest and lowest values.

· Parameter queries that accept data input from a prompt

· Forms with bound and unbound controls, formulas and expressions

· Macros and reports

· Data import and export from / to a range of file formats.

Candidates may choose to take the Advanced ECDL test using MS Access or the Access Core Level, MOS.

To ensure all participants gain the skills necessary to use their personal Computers at an optimum level.