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...
-
Identify the four assumptions that underlie accounting.
-
Bernoullis equation for subsonic flow states that a. if the velocity of an airstream within a tube is increased, the static pressure of the air increases. b. if the area of a tube decreases, the...
-
For a test of H0: 1 = 2 versus H1: 1 2, the sample sizes were n1 = 15 and n2 = 25. How many degrees of freedom are there for the test statistic? Use the simple method.
-
The following information was extracted from Citigroup, Inc.s 2009 annual report. From letter to shareholders: Financial Strength While Citi started the year as a TARP institution receiving...
-
Discuss how these measures might impact Jill and Marcus's goals and objectives. (8 marks) The RBA statement also states that: "In the central scenario, GDP growth is expected to be around 6 per cent...
-
Bear Park, a camping ground in the Lake District, has compiled the following financial information as of December 31, 2020. Instructions a. Determine Bear Parks net income for 2020. b. Prepare a...
-
FINANCIAL ACCOUNTING: MADE EASY Learning Activity No. 2: Computation of Input and Output Tax Directions: Compute and indicate the following requirements. Show your solution and put your answer on the...
-
Alex Morgan, a 25-year-old female presents herself to the release of information (ROI) clerk at Hendrick Hospital in Dallas with a request to access her birth records. She was adopted as a baby and...
-
Describe your experience with presenting data and what methods did you use. Compare and contrast the methods you have used and provide one tip for effective data presentation ?
-
Discuss your experience with the elderly who you think are aging successfully. What do you think characterizes the daily lives of elderly who are aging successfully?
-
Blue Ridge Hiking Company has an estimated sales price of theheadlamp is RM19.99 per unit. The variable cost per unit isRM10.29. Blue Ridge Hiking Company has annual fixed costs totallingRM109,500....
-
Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number of speakers) for the coming five...
-
Did you know that 90% of brand interactions are through digital channels? And that most of these digital channels can be found on mobile? make a blog entry (five hundred words minimum) that tells the...
-
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...
-
What are the major elements of risk assessment?
-
How does an organization go about identifying, measuring, and prioritizing risks? Who is responsible for the assessment of risk in an organization?
-
What is risk? How does management generally perceive the dimensions of risk?
Study smarter with the SolutionInn App