Quiz1

1. Open MS Access
2. Database Filename is : Quiz1
3. Create two Tables: Product, Customer

Product Table:

Prod_ID, Prod_Name, Prod_Description, Prod_Supplier

Customer Table:

Cust_ID, Custo_Name, Cust_Address, Cust_Phone, Cust_Date_Purchased

Primary key : Product Table: Prod_ID
: Customer Table: Cust_ID

Note: Input at least 10 records for product and customer

4. After creating the two tables, Design a FORM with 3 buttons (Add Record, Delete Record, Delete Record).