Create the customer and sales transaction database

Customer table has the following fields:

Field	Type	Size
Customer ID	Text	3
First Name	Text	20
Last Name	Text	20
Rating	Text	1

Sales Transaction table has the following fields:

Field	Type	Size
Invoice No	AutoNumber	Long Integer
Customer ID	Text	3
Reference No	Text	15
inv_amount	Number	Double (format currency)
paid_amount	Number	Double (format currency)
Period	Number	Long Integer
Year	Number	Long Integer
Date	Date
Description	Memo

Create a form to input all Customers

Create another form to input all Sales Transactions, with a lookup on the customer table

Enter 2 customers with 2 sales each

Create a query that shows the customer's first and last name and rating as well as every field in the sales transaction table, linking by the customer ID.

Create a report using the report wizard to sales made and total money collected and subtotal by customer.

For extra credit: Create a table that holds all the parts that were ordered on the invoice and how much each cost. Also create a report to print every order with all its parts.