• Set field properties
• Assign primary key
• Create relationship and enforce Referential Integrity
• Set intern pay between $3.00 and $17.00

• Create a customer maintenance form to display one record at a time
• Add a new customer using your first and last name and last 3 digits of your Rutgers ID

• Create a report displaying customer data grouped by Intern and sorted by Customer Name

• Create a query displaying Customer Name, Amount Billed, Amount Paid and Calculating the Outstanding Balance

• Create a table that will include all Customer data from Customer table and Intern First and Last name DO NOT type the data into the table- let the system do it.

• Create the following QUERIES and include fields you think are appropriate Name each Query with your first name and the objective

• Create a query displaying Customer Name, Amount Billed, All customers with balance over $100

• Using wild card(s) list all customers with addresses on Bard or Bird

• All customer ID starting with A

• Total Billed and Average amount Paid by an Intern

• Increase the pay of interns from Missouri (MO)by 25%

• All customers whose last name contains the letter e