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...
-
Explain the difference between indirect exporting and direct exporting.
-
Is the force of gravity on a piece of paper stronger when it is crumpled? Defend your answer.
-
Bottling Company acquired a 75 percent interest in Regional Bottling Partnership on January |, 2008. Assume the following information related to this acquisition: The excess of fair value over book...
-
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....
-
I am lost. how is this completed. Gone from class this day. I don't know how to solve it. 1 Journalize the required entries for the following dates in relation to a cash dividend totaling $ 62,000.00...
-
The book balance in the checking account of Lyles Salon as of November 30 is $3,282.95. The bank statement shows an ending balance of $2,127.00. By examining last months bank reconciliation,...
-
You are given the following mortality rates: qx0 - 0.07, qs = 0.08, qs2- 0.09, qss = 0.10 Max is currently age 80 and Darlene is current age 81. What is the probability that exactly one of Max and...
-
Why are firms of accountants reluctant to contest charges of negligence in court? Is such an attitude in the best interests of the profession as a whole?
-
Should a system of peer review be introduced in the United Kingdom? What would be the advantages and disadvantages?
-
Discuss the proposition that the expectation gap has arisen because of the publics ignorance and should, therefore, be resolved by the public themselves.
-
The following questions relate to the selection of audit samples. Select the best response. a. Which of the following statistical selection techniques is least desirable for use by an auditor? 1....
-
Why should the accountancy profession be unwilling to take full responsibility for the detection of fraud during the annual audit?
-
In light of our post-COVID working environment, what are the most crucial accommodation and enhancement benefits companies can offer employees today? Why? 1 answer
-
The cash records of Holly Company show the following four situations. 1. The June 30 bank reconciliation indicated that deposits in transit total $720. During July, the general ledger account Cash...
-
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...
-
You are required to prepare a purchases ledger control account from the following for the month of June. The balance of the account is to be taken as the amount of creditors as on 30 June. 19X6 June...
-
Prepare a sales ledger control account from the following: 19X5 May 1 Debit balances Totals for May: Sales journal Cash and cheques received from debtors Discounts allowed Debit balances in the sales...
-
Prepare a sales ledger control account from the following information for July 19X9, carrying down the balance at 31 July: 19X9 July 1 July 31 Sales ledger balances Sales journal 9,700 99,280 Bad...
Study smarter with the SolutionInn App