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.
4. The command language used with relational databases is
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.