1. Create a new database to store the two tables related to the electronics store. Call the database, HaveMore Electronics, 2. Create the sales representatives table using the structure shown in Table AIA- 1. Make the Sales Rep ID the primary key. Use the name, Sales Rep, for the table. 3. Add the data shown in Table A1A- 2 to the Sales Rep table 4. Save the Sales Rep table. Microsoft Access Chapter 1- Lab Test A Due by the end of Lab Class Feb 2nd Creating an Electronic Accessories Database Purpose: To demonstrate the ability to create a database, create queries, a form, and create a report. Problem: An electronics store wants to keep track of its sales representatives for its vanious outlets. The database it will use consists of two tables. The Outlets table contains data on the particular outlet store. The Sales Rep table contains pertinent data about the electronics store's sales representatives. Instructions: The structure for the Outlets table is shown in Table A1A-1 and the data is shown in Table A1A-2. The structure for the Sales Rep table is shown in Table A1A-3 and the data is shown in Table AlA-4. 1. Create a new database to store the two tables related to the electronics store. Call the database, HaveMore Electronics. 2. Create the sales representatives table using the structure shown in Table AIA- 1. Make the Sales Rep ID the primary key. Use the name, Sales Rep, for the table. 3. Add the data shown in Table AIA- 2 to the Sales Rep table. 4. Save the Sales Rep table. 5. Create the outlets table using the structure shown in Table AlA-3. Make the Outlet ID the primary key. Use the name, Outlets, for the table. 6. Add the data shown in Table A1A-4. 7. Save the Outlets table and print it 8. Create a query for the Sales Rep table. Include the Sales Rep ID, Name, Outlet ID, Quota, and YTD Sales in the query. Save the query as Sales Rep Query. 9. Open the Sales Rep Query and add a criterion to limit retrieval to those sales representatives located in outlet HME 11. Save the query as Sales Rep - HME 11Query. Make sure to use the file button (top left)/ Save as function/ Save as object to save this as an additional Query. Otherwise it will save as the Sales Rep Query. See below. 10. Create a simple form for the Sales Rep table. Use the name, Sales Rep Form, for the form. 11. Create a report using the Sales Rep Id, Full Name, Outlet ID, Quota and YTD columns for the Sales Rep table. Add totals for the Quota and YTD Sales. v Structure of the Sales Rep table Primary Key? 3 Yes Data Type Description Sales Representative ID (Primary Key) Fiell Name Field Size Sales Rep ID Short Text Full Name Short Text 25 Gender Short Text Age Number Hire Date Date/Time Outlet ID Short Text Outlet ID Currency Currency Quota YTD Sales Year to date sales amount Table A1A - 1 v Data for the Sales Rep table Salen Rep ID Name Gonder Age re Date Stoe D Queta YTD Sabu 3,656,640 3,336,300 3,371,092 1,960,932 1,768,442 1,525237 3,000,264 2,078,386 1,652,836 1,432,701 2,280,900 1,54s,311 2,651,270 2,451,454 1,837,213 1,563,140 3,899,402 1,916,753 3,426,535 3,292,270 3,218,514 2,514,181 321 Moeller, Pierre M. 24 3/12/2001 HME 11 101 Battistini, Jorge M 26 72/2001 HME 15 205 Lambert, Paul 35 3/16/2002 HME 11 613 Brunell, Candace F 36 6/1/2002 HME 17 475 Dunn, Alan M. 39 6/6/2002 HME 26 125 Lyon, Jody F 27 S/3/2002 HME 15 Bulger, Gloria Lopez, Maria 324 25 12/23/2002 HME 15 140 25 6/3/2004 HME 17 285 Dillig, Henry M 42 11/21/2006 HME 11 512 Kahn, Ramesh M 44 4/6/2007 HME 26 678 Chu, Leslie 36 7/15/2007 HME 26 287 Wochos, Lisa 30 10/21/2007 HME 15 2,648,883 2,188,106 465 Cataldo, Lydia F 25 11/15/2007 HME 11 3,668,028 2,846,910 Table A1A - 2 v Structure of the Outlets table Data Type Primary Key? 6 Yes Deacription Outlet ID (Primary Key) Flel Name Flel She Outlet ID Short Text Address Short Text 25 Outlet Address City Short Text 20 State Short Text 2 Zip Short Text Table A1A - 3 Data for the Outlets table Outlet ID Address City State Zip HME 11 1298 Western Court Bedlam CA 34896 15 25 Parkington Palace Southtown CA 39746 HME 17 1212 Mocking Bird Ambervaon CA 38957 HME 26 774 Oakland Parkville CA 38974 Table A1A - 4