Figure 290 The management of Garden Naturally has determined a number of questions it wants the database
Fantastic news! We've Found the answer you've been seeking!
Question:
Figure 2–90
Transcribed Image Text:
The management of Garden Naturally has determined a number of questions it wants the database management system to answer. You must obtain the answers to these questions. Note: Use the database modified in Lab 1 of Module 1 for this assignment, or see your instructor for information on accessing the required files. Instructions: Perform the following tasks: 1. Run Access. Open the Lab 1 Garden Naturally database you modified in Module 1 and create a new query for the Customer table. Add the Customer Number, Customer Name, Amount Paid, Balance Due, and Sales Rep Number fields to the design grid, and restrict the query results to only those customers where the sales rep number is 29. Save the query as Lab 2-1 Step 1 Query. 2. Create a query for the Customer table that includes the Customer Number, Customer Name, and Balance Due fields for all customers located in Delaware (DE) with a balance due greater than $1,000.00. Save the query as Lab 2-1 Step 2 Query. 3. Create a query for the Customer table that includes the Customer Number, Customer Name, Address, City, and State fields for all customers located in cities that begin with Ch. Save the query as Lab 2-1 Step 3 Query. 4. Create a query for the Customer table that lists all states in ascending order. Each state should appear only once. Save the query as Lab 2-1 Step 4 Query. 5. Create a query for the Customer table that allows the user to type the name of the desired city when the query is run. The query results should display the Customer Number, Customer Name, Balance Due, and Amount Paid fields in that order. Test the query by searching for those records where the customer is located in Quaker. Save the query as Lab 2-1 Step 5 Query. 6. Create a query for the Sales Rep table that includes the First Name, Last Name, and Start Date for all sales reps who started after June 1, 2015. Save the query as Lab 2-1 Step 6 Query. 7. Create a query that joins the Sales Rep and Customer tables. Include the Sales Rep Number, Last Name, and First Name from the Sales Rep table. Include the Customer Number, Customer Name, and Amount Paid from the Customer table. Sort the records in ascending order by sales rep's last name and then by customer name. All sales reps should appear in the result even if they currently have no customers. Save the query as Lab 2-1 Step 7 Query. The management of Garden Naturally has determined a number of questions it wants the database management system to answer. You must obtain the answers to these questions. Note: Use the database modified in Lab 1 of Module 1 for this assignment, or see your instructor for information on accessing the required files. Instructions: Perform the following tasks: 1. Run Access. Open the Lab 1 Garden Naturally database you modified in Module 1 and create a new query for the Customer table. Add the Customer Number, Customer Name, Amount Paid, Balance Due, and Sales Rep Number fields to the design grid, and restrict the query results to only those customers where the sales rep number is 29. Save the query as Lab 2-1 Step 1 Query. 2. Create a query for the Customer table that includes the Customer Number, Customer Name, and Balance Due fields for all customers located in Delaware (DE) with a balance due greater than $1,000.00. Save the query as Lab 2-1 Step 2 Query. 3. Create a query for the Customer table that includes the Customer Number, Customer Name, Address, City, and State fields for all customers located in cities that begin with Ch. Save the query as Lab 2-1 Step 3 Query. 4. Create a query for the Customer table that lists all states in ascending order. Each state should appear only once. Save the query as Lab 2-1 Step 4 Query. 5. Create a query for the Customer table that allows the user to type the name of the desired city when the query is run. The query results should display the Customer Number, Customer Name, Balance Due, and Amount Paid fields in that order. Test the query by searching for those records where the customer is located in Quaker. Save the query as Lab 2-1 Step 5 Query. 6. Create a query for the Sales Rep table that includes the First Name, Last Name, and Start Date for all sales reps who started after June 1, 2015. Save the query as Lab 2-1 Step 6 Query. 7. Create a query that joins the Sales Rep and Customer tables. Include the Sales Rep Number, Last Name, and First Name from the Sales Rep table. Include the Customer Number, Customer Name, and Amount Paid from the Customer table. Sort the records in ascending order by sales rep's last name and then by customer name. All sales reps should appear in the result even if they currently have no customers. Save the query as Lab 2-1 Step 7 Query.
Expert Answer:
Answer rating: 100% (QA)
1 Create a query for the Customer table that includes the Customer Number Customer Name and Balance Due fields for all customers located in Delaware DE with a balance due greater than 100000 Save the ... View the full answer
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these programming questions
-
What will happen to the Cash account if a company overdraws its bank account? discuss it briefly.
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
THIRD AVENUE SOFTWARE HEALTH-CARE APP PROJECT This case is new for the ninth edition of Information Technology Project Management . The case provides an opportunity to apply agile and Scrum...
-
The following exercises are of mixed variety. Factor each polynomial. x 2 - 2xy + y 2 - 4
-
A sample of tissue absorbs a 55-rad dose of a particles (RBE = 20). How many rad of protons (1RBE = 10) cause the same amount of damage to the tissue?
-
The living wage set by municipalities tends to be ________. a) higher than the federal minimum wage b) lower than the federal minimum wage c) about the same as the federal minimum wage
-
Comparative balance sheets and the intervening statement of income for Sears Canada Inc. appear below. Sears Canada is a subsidiary of Sears Holdings Corporation, a U.S. corporation. All amounts are...
-
Recognition of Profit and Entries on Long-Term Contract On March 1, 2010, Chance Company entered into a contract to build an apartment building. It is estimated that the building will cost $2,000,000...
-
Q1. Outline the maximum penalty for not paying trust monies collected on behalf of a client into the trust account according to the Property and Stock Agents Act 2002 (NSW)? Q2. Explain the...
-
Table 1 shows Apple's online orders for the last week. When shoppers place an online order, several "recommended products" (upsells) are shown as at checkout an attempt to upsell See table 2 in cell...
-
Cosmic Corporation had the following transactions in June: More Info Jun. 1 Sold merchandise inventory on account to Cody Company, $1,485. Jun. 6 Sold merchandise inventory for cash, $560. Jun. 12...
-
Laney purchased a new lawn mower yesterday for $350 from the local home improvement warehouse . When she arrived home and attempted to use the new mower, it would not start. Exasperated , Laney...
-
Mauve Company uses a standard cost system that applies manufacturing overhead to units of product on the basis of direct labour hours (DLHS). The following data pertain to last month: Actual Hours...
-
Five Defendants are on trial for burglarizing a cash vault at a casino on the Las Vegas Strip. The prosecution alleges that the Defendants hacked the security cameras, wore SWAT clothing, and used...
-
Here are four major activities in drug law enforcement: Source Control - activities targeting cultivation, manufacturing and production of controlled dangerous substances in foreign countries....
-
On November 1, 2017, Hunter opened a sandwich shop in Northridge across the street from a sandwich shop run by Donald. Donald's sandwich shop had been in business for 10 years and had made between...
-
QUESTION 4: CASE STUDIES 15 MARKS Identify the transportation network structure in each case study below. You are required to justify your answer: = 15 Marks FP Du Toit transports products from CIC...
-
Selected condensed data taken from a recent statement of financial position of Morino Ltd. are as follows. MORINO LTD. Statement of Financial Position (partial) Other current assets...
-
Review the material in Chapter 4 on corporate and information systems strategic planning. How are these processes different from BPR? What new perspectives might BPR bring that classical strategic...
-
Assume that entity PART has attributes Part_Number, Drawing_Number, Weight, Description, Storage_Location, and Cost. Which attributes are candidate keys? Why? Which attribute would you select for the...
-
What elements of a DFD should be analyzed as part of data modeling?
-
Correctly apply the rules for the order of operations to accurately compute \(\left(\frac{5}{7}-\frac{2}{7} ight) \times 2^{3}\).
-
James is mixing soil for a raised garden, in which he plans to grow a variety of vegetables. For the soil to be suitable, he determines that \(\frac{2}{5}\) of the soil can be topsoil, but...
-
Correctly apply the rules for the order of operations to accurately compute \(4+\frac{2}{3} \div\left(\left(\frac{5}{9} ight)^{2}-\left(\frac{2}{3}+5 ight) ight)^{2}\).
Study smarter with the SolutionInn App