Reference no: EM13395431

1. When constructing criteria for a query, you should use

• No delimiters for number data types.
• Quotes to enclose Date/Time data types.
• Single quotes for number data types.
• The pound sign to enclose text data.

2. In Access, query results are displayed in which view?

• Datasheet.
• Form.
• record set.
• Report.

3. Access has __________ data types.

• 6
• 8
• 10
• 12

4. The command language used with relational databases is

• PNPI.
• RDBMS.
• SQL.
• TUPLE

5. The term cardinality refers to

• A count of the total records in a table.
• A field which is a candidate for a primary key.
• The number of records in a relationship.
• The most important field in a table.

6. Validation text

• Changes the way text data is formatted.
• Determines the maximum length of a text field.
• Requires text data to be inputted correctly.
• Specifies the error message when a rule is violated.

7. In Access, the bottom portion of Query Design View that displays the fields and criteria is known as the

• Query design grid.
• Show Tables dialog.
• Simple Query Wizard.
• Query datasheet.

8. An action query is

• A select query used to warn users of database changes.
• Always initiated by a user.
• An aggregate query used to summarize field data.
• Used to add, edit, or delete data in a database.

9. A make table query

• Creates the structure of a table but does not populate the table with records.
• Is another name for an append query.
• Selects records from one or more tables and uses them to create a new table.
• Requires the destination table to exist first.