0
In access to order the records in the answer to a query in a particular way you what the records?
Wiki User
∙ 10y ago
I took the same quiz. The answer is "sort" (I got it wrong because I said arrange [serioussly this is rediculous!])
Wiki User
∙ 10y ago
Wiki User
∙ 13y agosort the records
Add your answer:
Earn +20 pts
What does sorted mean?
To order the records in the answer to a query in a particular way.
What is a condition that the records to be included in a query must satisfy in Access?
Criterion
What do you use to find a particular record or group of records in a database?
To find a particular record or group of records in a database, you can use a query language like SQL. By writing a query with specific conditions, such as matching values in certain fields, you can retrieve the desired information from the database.
What is the process in which Access searches a table of records and then displays the records in a datasheet?
What you seem to be describing is a Query. Databases run queries when the humans want information out of the database. Microsoft Access has a separate Table structure for creating and running Query. The correct answer is called a Run. (report)
What is ment by query?
Query is an instruction given to Database engine to retrieve the results. Example: Select EmployeeName From tblEmployees Where EmployeeID = 123; This is a sample query to retrieve the Name of a particular employee from the set of records saved already.
What is a delete query?
A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.A delete query can delete some or all of the records from a table. You can choose which ones to delete by using criteria, like choosing to remove all records that have a date beyond a certain point, or all the staff working in a particular department etc.
A query that that retrieves records based on the results of another query is referred to as a?
This is called a correlated sub-query.
What is a complex query in Microsoft access?
A select query with multiple criteria
Why do data appear many times on a query using access database?
It will depend on the design of your table and your query. If you have done something like brought the table in twice into the design of the query you will get multiple records. There are occasions when you would need to bring in the same table twice, but usually you don't. If you have it in twice it will list records multiple times. Go to the design view of the query and if you see the table there more than once, delete the extra copies of it, so that there is only one. Then design your query and it should be ok.
Is a query the same as a filter?
Not exactly. A query is much more powerful. Essentially it can filter records, but queries can do all sorts of other things that filters cannot do. A filter will reduce down the amount of records you see by apply a condition. You can then scroll through the visible records. A query can do the same thing, but it will give you a list of the records. It can deal with more complex conditions and do many other things like delete records, change values in records, build new tables and many other things that filters cannot do. You would use a filter for simple things, like to filter out all the people working in a particular department, but would use a query for something more complex like to show the people working in a particular department, who are earning a certain amount of pay and have worked in the company for more than a certain amount of years.
What do you click to create a query on the query wizard on the ribbon in access?
create tab
Is there a Database program and or a Spreadsheet program that can easily locate and delete duplicate entries?
Microsoft Access can easily locate and remove duplicate records from a table of data. The data is stored in a table, and a query is used to extract the duplicate records. You need to click on "new" query and a box will popup asking what sort of query you want to create. Pick the "find duplicates query". follow the wizard instructions and it should be quite clear. Any problems let me know.
