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
-
How do price and quantity risks affect the variability of a countrys export revenue?
-
Regarding the above activity, identify your own values and principles around conflict. Write down at least two values/principle that you have. Consider different values/principles that another person...
-
Using the product life cycle, place the products discussed in this case into one of the four stages. Evaluate Mattels strategy for each of these products based on its current life cycle stage. Using...
-
You are the senior auditor-in-charge of the July 31, 20X0, audit of Reliable Auto Parts, Inc. Your newly hired staff assistant reports to you that she is unable to complete the four-column proof of...
-
Your company's old computer system cost $2.5 million 5 years ago when it was purchased new. Last year it was upgraded at a cost of $300,000. It's current maintenance cost is $500,000 per year, and it...
-
Andi is starting a Wedding Venue business. She currently has a hill top property that is semi-rural and has a view of the valley below. She contracts intends to have built build a custom gazebo in a...
-
Part 2: Sample Budget (10 marks) Prepare a Sample Budget for the work items and activities from your WBS. Refer to the sample budgets and/or MS Project Gantt Chart from the slides from Chapter 7 as...
-
Perhaps we need a way to differentiate ourselves from the competition? Is it possible that we are dividing the customer's time too much? Does this mean that we should instead look to attract more...
-
Complete these answers with full paragraph sentences. 1)What are the Mission, Vision, & Values of the Palo Alto Network? 2) What are the Four Functions of Management Planning, Organizing, Leading, &...
-
One highly visible trait of a successful leader is that of role model: behavior exhibited by a leader is carefully observed and often sets the tone for the entire center. As a role model, it is...
-
Design a flowchart that illustrates the key processes and decision points within the custom leadership system, along with the various inputs and outputs. At the center of the flowchart is the leader,...
-
Prepare a sample memo to those that have been selected to serve on the "Bulletin 1" committee. Remind them of their charge and outline a calendar of meetings. Lastly, include a list of resources. ...
-
Forward Corporation is owned by a group of 15 shareholders. During the current year, Forward pays $550,000 in salary and bonuses to Alvin, its president and controlling shareholder. The corporation's...
-
The National Collegiate Athletic Association (NCAA) and the National Federation of State High School Associations (NFHS) set a new standard for non-wood baseball bats. Their goal was to ensure that...
-
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?
-
3. On December 31, 2008, the city in question 2 makes its first annual lease payment. How does it report the payment on the government-wide financial statements? On the fund-based financial...
-
How does governmental accounting apply to public colleges and universities?
-
What is included in the management's discussion and analysis (MD&A), and why is it required of state and local governments?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App