CS Week 6 – Access (Tables, Forms, Queries)

This one comes courtesy of Anushervon Rakhmatov !

Following the attached tutorial document, create your own Microsoft Access database file with tables for Customers, Products, and Orders (with the same fields and formulas as the tutorial, for example date should be auto generated using “=Now()”). Create at least 5 records in each table, showing a completed “Orders Query” in your file that displays customerId, first name, last name, product name, and price.

Quick note on section 3 – if you get an error when trying to create the data relationships, make sure your other tables are closed and saved.

Include your access database file in a reply to this post.

Due June 26 at noon for full points.

 

My submission:

Leave a Reply

Your email address will not be published. Required fields are marked *