ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORTS

In this assignment, you first create database tables in Access and populate them with data. Next, you create one form, eight queries, and a report.

In this part of the assignment, you create tables in Access. Use the following guidelines:

• Enter data for at least eight customers and six workers, as outlined in the Background section of this case. Use your name as one of the workers. Enter home addresses, telephone numbers, and email addresses.
• Create four different jobs that can be performed: grocery shopping, miscellaneous shopping, online shopping, and bill paying.
• Make at least 20 transactions of a worker performing a job for a customer.
• Appropriately limit the size of the text fields; for example, a phone number does not need the default length of 255 characters.
• Print all tables if your instructor requires it.