Uses spreadsheets to produce evidence for the CLAIT Advanced Unit 3 assessments. This manual covers various aspects of Access. It enables the student to: create relational databases using advanced design features, create multiple views for data entry and queries, and create complex queries.

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. Data files are avialable to download allowing you to practise the software features. Endorsed by OCR.

Section 1 - Fundamentals, Section 2 - Creating and Linking Tables, Section 3 - Data Fields, Section 4 - Data Entry, Section 5 - Queries, Section 6 - Macros, Section 7 - Reports