AS91368 Access Database Practice Exercise

There may be some teachers who might be still using this standard which will expire this year. I have prepared a step by step tutorial for this standard. This is called Online T- Shirt Sale, it is really not online but can be operated at the retail end. I have used Access to make this database. This can be adapted to make a web database using php, MySql. 

I have used a dynamic link using excel spreadsheet, through which we can operate Update Query to change prices in the database. 

(This fulfills the clause in the assessment where it says: using tools of the software to integrate data from a database and at least one other software application using dynamic linking)

Another Dynamic link I used is integrating the Customer Data to mail merge the NewsLetters. 

However, you must again link the external file Price List to see this in full operation. Both price list and Database should be in the same folder.