What is a query in Microsoft Access?
A query poses a question to retrieve a subset of information already contained in a Microsoft Access relational database, as described by Microsoft in its Access training courses. The database query applies prescribed conditions to limit the data retrieved.Record SetA query retrieves data based on the criteria and structure specified in the tool by the user. The record set contains the data that meets the criteria of the query.Select QueryThe commonly used select query performs simple prescribed calculations using data from one or more tables in the relational database. The select query can group data returned in the record set.Parameter QueryA parameter query runs a prompt each time for user input to limit the criteria used in retrieving a subset of data.Advanced QueriesMicrosoft Access provides more advanced queries to perform actions and manage record sets and their presentation. Advanced queries include the cross-tab query, action query and the structured query language (SQL) query
