Figure 290 The management of Garden Naturally has determined a number of questions it wants the database

     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.

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