Which of the following types of joins displays records with the same value in the common field?

Related MCQs

• 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 most common type of query. It retrieves records from one or more tables and then displays the
• The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
• This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.
• A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.
• 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
• This form displays multiple records, one per row, in the form window
• Using the keyword _______________ will return records in which the field value equals a defined text.
• In a query, using the keyword _______________ will return records in which the field value is between two numbers.
• 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?