Create a copy of the total balances by client query

Assignment Help Database Management System

Reference no: EM132100177

Please show work to assess problems below. Unable to print screen the spreadsheet. Have tried several times. Below is the information I have.

Entered in using design query

Field First Name Last Name SavingsBalance
Table Clients Clients Accounts
Sort
Show
Criteria
Or

Add appropriate grouping so the client's total retirement account savings balances are displayed. Add a sort so the highest total savings balances are displayed first.

1 Switch to Datasheet view. Add a totals row displaying the count of the last name and the average of total savings balances. Save the query as Total Balances By Client, and close the query. 10

2 Create a copy of the Total Balances By Client query. Name the query Total Balances By State. Open the query in Design view and remove the client name from the query. Add grouping by the client's state. 10

3 Sort by the client's state in Ascending order and remove the sort on the savings balance. Add criteria so clients with retirement account savings balances of $10,000 or more are factored in to the query. Save and close the query.

Reference no: EM132100177

Questions Cloud

Buying-selling at spot price before maturity date : Futures contract: Can futures position be closed by buying/selling at spot price before maturity date? Or must it be closed by another futures contract?

Calculate the number of liters currently in inventory : How do I Calculate the number of liters currently in inventory Dec 31, 2014 and how many more liters are required to get to 15 days?

Why and how do you analyze data on an income statement : Why and how do you analyze data on an income statement . also I am having a hard time figuring out when Im analyzing the income

What is a privately operated insurance system : What is a privately operated insurance system? What is a market based economy?

Create a copy of the total balances by client query : Create a copy of the Total Balances By Client query. Name the query Total Balances By State

What is the annual effective rate of the inventory loan : DVDs inventory storage and evaluation fee will be 1 percent a month on the total value of the inventory. What is the annual effective rate of the inventory loan

Finish the function definition for interpret : Using two for loops call the function interpret on all the elements of linkedin and facebook.

What is the current price of the bond : Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments

Solve systems of equations using the gaussian elimination : Solve the following systems of equations using the Gaussian elimination - Agumented matrix method.

User Account

All Pages