Computers and Technology, 11.08.2021 14:50 Leigh7726

Using Wildcards in a Query, Creating a Parameter Query, Joining Tables, and Creating a Report Perform the following tasks:

1. Import the Accounting table from the pdf , there is link.

2.Create a query for the Accounting table and add the Client Number, Client Name, Amount Paid, and Advisor fields to the design grid. Sort the records in descending order by Amount Paid. Add a criterion for the Advisor field that allows the user to enter a different advisor each time the query is run. Run the query and enter 114 as the advisor to test the query. Save the query as Apply 2 Step 2 Query.

3.Create a query for the Accounting table and add the Client Number, Client Name, and Current Due fields to the design grid. Add a criterion to find all clients whose current due amount is less than $500. Run the query and then save it as Apply 2 Step 3 Query.

4.Create a query that joins the Advisor and Client tables. Add the Advisor Number, Last Name, and First Name fields from the Advisor table and the Client Number and Client Name fields from the Client table to the design grid. Sort the records in ascending order by Client within Advisor. Run the query and save it as Advisor-Client Query. Note: if any error messages appear, check the field types of the fields in the query tables and make changes as necessary.

5. Create the report shown in the attachment.

Using Wildcards in a Query, Creating a Parameter Query, Joining Tables, and Creating a Report

Per

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 07:00, yyy77uh

You will be given two character arrays of the same size, one will contain a number of ships. ships will move around the character array based on which way they are facing and the route they are on. routes are given in the other array. the route consists of '-' and '|' for straight paths, '\' and '/' for curves, and '+' for intersections. there are ships on these routes. ships always face a direction, '^' for up, '> ' for right, 'v' for down, and '< ' for left. any time the ships hit a '\' or a '/' it will turn as you would expect a ship to turn (e. g. a '^' that moves into a '/' will turn right). at an intersection, ships will always continue straight through. all ships move at the same speed, ships take turns moving and all ships move during one 'tick'. the one in the most top left goes first, followed by those to its right, then the ones in the next row. it iterates along the rows and then down the columns. each ship moves one space on its turn moving along the route. your function needs to return the position of the first collision between two ships and the number of ticks before the crash occurred.

Answers: 2

continue

Computers and Technology, 22.06.2019 10:30, hope564

Dave has to create animations for a game. which tool can dave use?

Answers: 3

continue

Computers and Technology, 22.06.2019 18:30, cascyrio2002

What is outfitting a workplace with video in a technology

Answers: 2

continue

Computers and Technology, 23.06.2019 01:00, Ltik11900

Write the command that can be used to answer the following questions. (hint: try each out on the system to check your results.) a. find all files on the system that have the word test" as part of their filename. b. search the path variable for the pathname to the awk command. c. find all files in the /usr directory and subdirectories that are larger than 50 kilobytes in size. d. find all files in the /usr directory and subdirectories that are less than 70 kilobytes in size. e. find all files in the / directory and subdirectories that are symbolic links. f. find all files in the /var directory and subdirectories that were accessed less than 60 minutes ago. g. find all files in the /var directory and subdirectories that were accessed less than six days ago. h. find all files in the /home directory and subdirectories that are empty. i. find all files in the /etc directory and subdirectories that are owned by the group bin."

Answers: 1

continue

You know the right answer?

Using Wildcards in a Query, Creating a Parameter Query, Joining Tables, and Creating a Report Perfo...