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...
-
Is the criticism of Nike for creating a shoe that is symbolic of success to some groups valid? Why or why not?
-
A 50-MHz plane wave with electric field amplitude of 50 V/m is normally incident in air onto a semi-infinite, perfect dielectric medium with r = 36. Determine (a) , (b) The average...
-
What is the internal rate of return of the following cash flow diagram? a. 20 percent b. 18.2 percent c. 17.5 percent d. 15 percent $30 $31 0 1 2 3 $30 $15
-
A company has sales of $1,000,000, variable costs of $250,000, and fixed costs of $600,000. Compute the following: 1. Contribution margin ratio. 2. Break-even sales volume. 3. Margin of safety ratio....
-
Xavier is working on an effort to gain support for legislation that would increase payroll taxes on the wealthier residents of his state. These taxes would fund an expansion of subsidized day care...
-
D Question 1 What is the total balance in the Trial Balance on the Debit side from your Worksheet? $339000 $409,000 $388,500 $393,000 Question 2 8 pts $97,000 O $104,000 O $11,000 O $106,000 8 pts...
-
Steven is beginning a new job but has not yet been paid. He needs $700 to pay his rent this month. Steven is going to borrow the money through a Payday Loan establishment. They are charging him an...
-
Design a Java class that represents a cache with a fixed size. It should support operations like add, retrieve, and remove, and it should evict the least recently used item when it reaches capacity.
-
A CD has a diameter of 17.0cm. If the CD is rotating at a constant angular speed of 9.5 radians per second, then the period of the rotational motion is?
-
A prismatic pile 12 m long is to be lifted by a crane from a horizontal position to a vertical position using a single sling attached to a point on the pile a distance "x" from the nearer end of the...
-
K Find the length of the golden rectangle whose width is 5.1 in. Use the approximation 1.62 for your work. If 5.1 is the width, then the length of the golden rectangle is approximately in. (Round to...
-
In December, Winnipeg Seafoods Ltd., an Ontario company (Winnipeg Seafoods), orally agreed to purchase from Lakehead Fish Wholesale Co., a federally incorporated company (Lakehead Fish), 1,000...
-
Write the number 101101101.111012 Write the number 110100101.101012 in octal and hexadecimal. in octal and hexadecimal. Convert decimal 21.156 to an octal number. If more than three digits to 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...
-
In recent years, Keflavik Paper Company has been having problems with its project management process. Several commercial projects, for example, have come in late and well over budget, and product...
-
Your firm has the opportunity to invest $75,000 in a new project opportunity but due to cash flow concerns, your boss wants to know when you can pay back the original investment. Using the discounted...
-
Pracht, a popular cosmetics company in Germany, has been performing favorably and growing at a constant rate, with profits exceeding $900,000 in the last financial year. The company now wants to...
Study smarter with the SolutionInn App