Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Steps for K1 and K2 pls How much credit does each customer still have available? (Question k. requires that you build one query first, make
Steps for K1 and K2 pls
How much credit does each customer still have available? (Question k. requires that you build one query first, make a table from it, and then create a second query for the final answer. So it is a multi step process. STEP \#1: First create a query called "k1 Customer Sales". When working on this query, your goal is the group the customers by their total purchases. If there are customers who have not purchased anything, their name will not be shown in the result. STEP \#2: From the result in the query "k1 Customer Sales" create a table. You must be in the design view, select "Make Table" and save the new table as "Query K". STEP \#3: Now you are ready to answer the Question k. How much credit does each customer still have available? STEP \#4: Design a query that can answer this question by using the fields located in the "Query K" table and call it " k2 Customer Credit Limit". (1) Remember the goal of this query is to figure out how much credit does each customer still have available, so you need to think about how to design the first query and table Query K to be able to perform a calculation in the second query to get this result. How do you know how much credit you have available? It is a function of your credit limit and your purchases right? (2) First, you will create Query "k1 Customer Sales" and make a table out of the query k1 (A "Make Table" is prepared the same as a normal query except that the user selects the "Make Table" option under the Query Design menu table and clicking onStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started