A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be

Related MCQs

• In table design view, which key can be used to switch between the field names and properties panels?
• 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?
• In a junction table, the _____ field consists of the foreign key from both the linked tables.
• The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
• What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
• In the Field List of a table, the primary key appears _______________.
• 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
• Which of the following creates a drop down list of values to choose from a list?
• The quickest way to add a field to the selected fields list is to double-click its field name in this list.
• 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?