AS 91633

DUE WEEK 11 TERM 1, 2019

Miss Greenwood's Videos

Tutorial 2 - Creating a Transaction Table

Tutorial 3 - Fixing errors in a student's database (Lookup Options)

Tutorial 4 - Creating Relationships between Customer, Movie and Transactions tbl

Tutorial 5 - Creating a Query from those Relationships

Tutorial 6 - How to create an automatic email reminder with Access

Tutorial 7 - How to create a email macro button that links to gmail

Tutorial 8 - Access - Invite Letter 1 - Inserting Access Query fields into a Word Document.

Tutorial 9 - HOW TO DESIGN YOUR FORM OR REPORT: Logo and Letterhead Colours

Tutorial 10 - DESIGNING YOUR FORM/REPORT: Image in background.... FANCY styling

5. Written Instructions on how to setup your Movies Database

RESOURCES TO HELP

1. Year 13, Creating Forms in Access

2. Create Forms, Relationships, and Content Auto Fill

3. ACCESS Auto Fill Customer Details on Forms

4. AS 91633 Exemplar Links

5. Templates to use for Submission

6. Example of Data and Integrity Testing Sheet NOTE: This sheet was designed for another assessment standard. DO NOT SUBMIT THIS TABLE WITHOUT AMENDING IT TO SUIT YOUR ASSESSMENT. YOU ARE NOT DOING A BMX DATABASE.