A query prompts a user for a data and then displays only records that contain the specified date. The type of of query is this

Related MCQs

• It is most common type of query. It retrieves records from one or more tables and then displays the
• You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
• You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
• Which of the following queries prompts users for input data by displaying dialog boxes?
• A query summarizes information in a grid, organized by regions and months. Which type of query is this?
• In Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box
• It is a query that when run displays its own dialog box prompting you for information, such as
• In access, this displays the results of a calculation in a query
• Which of the following types of joins displays records with the same value in the common field?
• This form displays multiple records, one per row, in the form window