This manual uses complex spreadsheets to produce evidence for the CLAIT Advanced 2006 Unit 3 assessments. All aspects of Access are covered as evidence is collected. The student will be able to: create relational databases using advanced design features, create multiple views for data entry and queries, create complex queries, use complex search criteria and logical operators, create macros to automate tasks, create complex reports based on multiple tables. Endorsed by OCR.

This manual uses complex databases to produce evidence for the CLAIT Advanced Unit 3 assessments. All aspects of Access are covered as evidence is collected. The student will be able to: create relational databases using advanced design features, create multiple views for data entry and queries, create complex queries, use complex search criteria and logical operators, create macros to automate tasks, create complex reports based on multiple tables.

This manual uses complex databases to produce evidence for the CLAIT Advanced 2006 Unit 3 assessment. All aspects of Access are covered as evidence is collected.

This self teach guide has been designed to gradually steer you in a step by step manner around the software features needed to pass New CLAIT 2006 Unit 3 assessment. As you work through this book you are introduced to, and taught how to use, Microsoft Access. Data files are supplied on CD and have been designed to be used in conjunction with the exercises as you work through the book. Titles of a similar nature are also available for the other New CLAIT 2006 units. Endorsed by OCR.

The third guide in the CLAIT Plus 2006 series will teach you how to design, create and save a database, and to add, amend and delete fields and records. You will learn how to import data and how to interrogate a database using complex criteria. Additionally, you will be able to create and format reports and to present data professionally.