1. Create a new database to store the two tables related to the electronics store. Call...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Chàu, 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 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 Chàu, 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
Expert Answer:
Answer rating: 100% (QA)
HaveMore Electronics Database CUsersUSERDocumentsHaveMore Electronicsaccdb Access 2007 2016 fi... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
Table contains data on market advances and declines. Calculate cumulative breadth and decide whether this technical signal is bullish orbearish. n-29 46 6 02306 0056 0987 ay 67891 46985 li-08869...
-
The following table contains data on market advances and declines. a. Calculate cumulative breadth. Cumulative Breadth ay (in millions) 1 2 3 4 5 6 7 8 9 10 b. Whether this technical signal is...
-
An array of structures is needed to keep track of 50 grocery items containing the item name, item type, cost, quantity, and tax percentage for each grocery item. The following declarations have...
-
1. Rick and Barbara are married with two children. Four yearsago, Barbara bought a $75,000 life insurance policy on her motherslife and named her children as policy beneficiaries. Barbara didnot name...
-
Should Alpha meet the second demand and expand its free drug program?
-
The projection lens in a certain slide projector is a single thin lens. A slide 24.0 mm high is to be projected so that its image fills a screen 1.80 m high. The slide-to-screen distance is 3.00 m....
-
Discuss the effects of internationalisation on pricing.
-
The following payoff table shows profit for a decision analysis problem with two decision alternatives and three states of nature: a. Construct a decision tree for this problem. b. If the decision...
-
Using the chart below define each word listed in the Teaching Strategy Column in the Definition Column and an example that that teaching strategy in the Example of Teaching Strategy column. Teaching...
-
Suppose that there are p = 4 quality characteristics, and in correlation form all four variables have variance unity and that all pairwise correlation coefficients are 0.9. The in-control value of...
-
Two methods for testing for presence of a disease were compared. The traditional method was used on 8 subjects and the new method was used on 2 subjects. When the times to obtain results were...
-
Any business can elect to be an S corporation. True or False
-
Jackson Paulson works as a waterskiing instructor at Migis Lodge on Sebago Lake. He claims unemployment from October through April. Jackson experiences which type of unemployment? a. Frictional b....
-
Liabilities include losses associated with breaches of contract or from damages. True or False
-
At which point in the business cycle is the economy when GDP declines for two or more successive quarters? a. Peak b. Recession c. Trough d. Expansion or recovery
-
Employees can be sure their behavior out of the office a. has no impact on stockholders. b. cannot impact their career if they blog under a fake name. c. matters to employers only during the hours...
-
If a product costs $1500 for the first unit and there is a 10% discount starting on the second unit, a 15% discount (from the original price) starting on the 5th unit, what would be the cost for 6...
-
General Electric Capital, a division of General Electric, uses long-term debt extensively. In a recent year, GE Capital issued $11 billion in long-term debt to investors, then within days filed legal...
-
Make up a view and replace the one in Spreadsheet. Recalculate the optimal asset allocation and portfolio expectedperformance. er 5 and Market-Value Weights and Calculation of Baseline Forecasts...
-
Christie Johnson, CFA, has been assigned to analyze Sundanci using the constant dividend growth price/earnings (P/E) ratio model. Johnson assumes that Sundancis earnings and dividends will grow at a...
-
Suppose that the alpha forecasts in row 44 of Spreadsheet 8.1 are doubled. All the other data remain the same. Recalculate the optimal risky portfolio. Before you do any calculations, however, use...
-
The comparative statements of financial position of Borra Services as at 30 June 2024 and 2025 and the statement of financial performance for the year ended 30 June 2025 are shown overleaf....
-
The financial statements for the business of Trinhs Nail Supplies for the past two years are presented below. Additional information 1. All purchases and sales of inventories are on credit. All...
-
The following comparative statements of financial position and statement of financial performance are for the business of Low Dollar Shop Pty Ltd. Additional information 1. All sales and purchases of...
Study smarter with the SolutionInn App