00:01
Hello student to create a query with the criteria that allows the user to enter a different advisor each time the query is run in the microsoft access follow these steps.
00:12
Number one open microsoft access and the support underscore ac underscore financial services database.
00:20
So step number two import the accounting table from the support underscore ac underscore financial services.
00:27
So extra table so extra so database from this database the import the accounting table.
00:36
Now click on the external data tab in the ribbon select access to import data from the another access database browse and select the support underscore ac financial services extra table database.
00:50
So this is the database and choose the accounting table and click ok to import it because we now because our task is to import this table create a query for the accounting table.
01:03
So go to the create tab in the ribbon and click on the query design to open the query designer.
01:08
Now add the following field to the queries design grid, client number, client name, amount paid and the advisor.
01:16
So these field we have to add now sort the record in descending order by the amount paid.
01:22
So in the in the sort row under the amount paid column select descending from the drop down list so that we can sort it in the descending order add a criteria for the advisor field to allow the user to enter a different advisor each time the query is run to create a parameter query for the advisor add the following to the criteria row under the advisor column...