Question: Copy the All Grants Query to create a new query with the name Grant Types Query. Redesign the query so that the following fields display

Copy the All Grants Query to create a new query with the name Grant Types Query. Redesign the query so that the following fields display in the order given: Grant ID, Department, Type, Grant Name, and Award Amount. Sort the records in 16 ascending order by the Type field and in ascending order by the Grant Name field. Run the query, and then close the query, saving the changes to the query. Copy the All Grants Query to create a new query with the name Grants Sort Query. Redesign the query so that the following fields display in the order given: Grant Name, Department, Award Amount, and Award Date. Sort the records in 16 ascending order by the Department field and in descending order by the Award Amount field. Run the query, and then close the query, saving the changes to the query. Copy the Grants Sort Query to create a new query with the name All Private 20 Grants Query. Redesign the query so that the following fields display in the order given: Grant Name, Department, Award Amount, Award Date, and Type. Sort the records in ascending order only by the Grant Name field. Set the criteria so that when you run the query only those records display that have private as the Type. Do not display the Type field in the query results. Run the query (11 records

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Copy the All Grants Query to create a new query with the name Grant Types Query. Redesign the query so that the following fields display in the order given: Grant ID, Department, Type, Grant Name,...

Question no.6, how can I create a query with criteria 'radio' and 'festival' AaBbC AaBbCl AaBbCl Aab Emphasis Heading 1 1 Normal Normal L Stre Paragra Styles Access. Open the downloaded file nained...

Copy the Concerts $1000 or More Query to create a new query with the name Jan-Apr Concerts Query. Redesign the query so that the following fields display in the order given: Date, Concert Name,...

for coffee or tea inventory and whether these items are flavored or not. The prompt text of each parameter should make clear to the user what input values are possible. The resulting dynaset should...

I don't have any more information. Whatever information I have can you help me with this? all I know it's about Microsoft access. Kindly help me with this problem. 1. In the Member table, find the...

Microsoft Office 365. Office 2016. Please explain in detail. Case Problem 2 Data File needed for this Case Problem: Programming.accdb (cont. from Module 2) Programming Pros After reviewing the...

Please try to answer all if possible :-) Practice Database - March 2021 1. Create a database in your HOME FOLDER, C-Database Systems called Practice March21.accdb a. Remember to click on the yellow...

Hello, thank you for taking the time to read, and help with with my questions. That is to the person who has chosen to help me, thank you. There questions are geared towards MicroSoft Access 2016. I...

Hi, working on this assignment on acess2016, and cannot figure out how to get these queries working. Here are the instructions: Create a query that displays data from all three tables in the database...

Miley Railroad Co. is about to issue $300,000 of 10-year bonds paying an 11% interest rate, with interest payable semiannually. The discount rate for such securities is 10%. How much can Miley expect...

The roof over a 7.0-m X 10.0-m room in a school has a total mass of 12,600 kg. The roof is to be supported by vertical 2 X 4s (actually about 4.0cm X 9.0cm) along the 10.0-m sides, How many supports...

Which statement about leading questions is true? Multiple Choice In surveys, it is better to incorporate leading questions than non leading questions. Leading questions allow respondents to provide...

Assume all the following taxpayers do not have a qualifying child for EIC purpose, their earned income is the same as their AGI, and their investment income is less than $3,500. Which person(s) below...