Purpose: To demonstrate the ability to utilize special Access features in the creation of reports.

Problem: You have been asked to add tables to theHaveMore Electronics database as well as create some advanced reports using the new data.

Instructions: Open the Access_Chapter_6_-_Lab_Test_A_-_HaveMore_Electronics database file provided in a location specified by your instructor and execute the following tasks:

1.Create a table to contain inventory information for the outlets. Use the structure illustrated in Figure A6A 1. Add the data shown in Figure A6A 2 to the Inventory table. (You may want to create an excel spreadsheet and import your data instead.)

2.Create a table to contain inventory items information for the outlets. Use the structure illustrated in Figure A6A 3. Add the data shown in Figure A6A 4 to the Items table.

3.Add the Inventory table to the Relationships window and establish a one-to-many relationship between the Outlets and the Inventory tables.

4.Add the Items table to the Relationships window and establish a one-to-many relationship between the Inventory and the Items tables.

5.Create a query called Outlets and Sales Rep that joins the Outlets and Sales Rep tables. The query should display all fields in the Outlets table and the Sales Rep table except for the Outlet ID from the Sales Rep table.

6.Create a query called Inventory and Items that joins the Inventory and Items tables. The query should display all fields in the Inventory table and the Items table except for the Item ID from the Items table.

7.Create the report shown in Figure A6A 5. The report uses the Outlets and Sales Rep query as the basis for the main report and the Inventory and Items queryas the basis for the subreport. Use the name OutletMaster Report for the report. The report title has a Text Align property value of Distribute. The Border Width property is transparent and the subreport label is Inventory. Make sure your report fits on 1 page in print preview mode.

8.Have the Outline ID Header repeat on each page. Include in the footer, the page number on the left and the current date on the right.

9.Close the database. Submit the results according to the specifications provided by your instructor.