0
When you sort data in a query the records in the underlying table are actually rearranged?
No. Most queries list off data, but does not affect the underlying data. Certain types of query can be used to change data in a table, but do not re-arrange the order of the data in the table itself. That is determined by the indexes, mainly the primary key. You can sort the data in the table itself and have it remain that way.
What else can I help you with?
What is the difference between update and append query?
Update queries modify information within a record at one or more fields at a time.Append queries copy complete records at a time, adding to the existing set of records in a table.For example, if an "Address" field needs to be changed for the records in a table, you can use an update query to make that change. If you have two tables with various "Customer Information" listings, you can use an append query to copy the records of one table to the other.
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 The query that provides the underlying information for a report is known as the?
The query that provides the underlying information for a report is known as the data source query. It is used to retrieve specific data from a database that will be included in the report. The data source query helps ensure that the report is accurately populated with the necessary information.
What is a condition that the records to be in a query must satisfy?
Criterion
Does a query displays records in a Datasheet View?
Yes.
In a 30 record result set if the LIMIT clause is set to LIMIT 2010 how many records will the query return?
The idea here is that the query returns either the number of records which match the query, or the number of records specified in the LIMIT clause - whichever is less. In this case, 30 is less than 2010, so all 30 records will be returned.
What can you use to list only certain records in a table?
A query
Adding to a query specifies conditions that must be met for the values of the records to be returned by the query.?
search parameters
What does sorted mean?
To order the records in the answer to a query in a particular way.
How is a query different from a record?
Records are the data that's stored in a database and a query is a command used to display and/or manipulate records (for example, adding/deleting records, displaying records by a search term, sorting records).
The total number of records in an opened table is displayed?
To display the total number of records in an opened table, you can use the SQL query: SELECT COUNT(*) FROM [table_name]. This query will return the total number of records present in the specified table.
What is a condition that the records to be included in a query must satisfy in Access?
Criterion
