ch 2 access Flashcards
An illustration of a one-to-many relationship would be:
A. each employee in an Employees table has a matching entry in the Salaries table.
B. an employee leaves the company so that when he is deleted from the Employees table, his salary data will be deleted from the Salaries table.
C. an employee listed in the Employees table earns a raise, so the Salaries table must be updated.
D. a customer may have more than one account in an Accounts table.
D. a customer may have more than one account in an Accounts table.
Which of the following is true for the Query Wizard?
A. You are required to summarize the data.
B. Fields with different data types are not allowed.
C. No criteria can be added as you step through the Wizard.
D. You can only select related tables as a source.
C. No criteria can be added as you step through the Wizard.
All of the following are suggested guidelines for table design except:
A. store data in their smallest parts.
B. avoid date arithmetic.
C. include all necessary data.
D. link tables using common fields.
B. avoid date arithmetic.
When entering, deleting, or editing data:
A. the table must be in Datasheet view.
B. data can only be entered in a form.
C. the table can be in either Datasheet or Design view.
D. the table must be in Design view.
A. the table must be in Datasheet view.
With respect to importing data into Access, which of the following statements is true?
A. The Import Wizard works only for Excel files.
B. Imported table designs cannot be modified in Access.
C. The Import Wizard is found on the Create tab.
D. You can assign a primary key while you are importing Excel data.
D. You can assign a primary key while you are importing Excel data.
A query’s specifications as to which records to include must be entered on the:
A. Table row of the query design grid.
B. Show row of the query design grid.
C. Criteria row of the query design grid.
D. Sort row of the query design grid.
C. Criteria row of the query design grid.
It is more efficient to make a copy of an existing query rather than to create a new query when which of the following is true?
A. The existing query and the new query use the same tables and fields.
B. The existing query and the new query have the exact same criteria.
C. The existing query contains only one table.
D. The original query is no longer being used.
A. The existing query and the new query use the same tables and fields.
When adding date criteria to the Query Design view, the dates you enter will be delimited by:
A. quotes
B. pound signs
C. parentheses
D. at signs
B. pound signs
The main reason to set a validation rule in Access is to:
A. make it possible to delete records.
B. keep redundant data from being entered in a table.
C. keep your database safe from unauthorized users.
D. limit the entry of incorrect values in a table.
D. limit the entry of incorrect values in a table.
Which of the following determines the amount of space a field uses in the database?
A. Data type
B. Field Size
C. Caption property
D. Normalization
B. Field Size
