CS W6 – Access – Tables, Forms, and Queries

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.

 

Leave a Reply

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