CIS 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions
1.) When entering, deleting, or editing table data:
A.) The table must be in Design View
B.) The table must be in Datasheet View
C.) The table may be in either Datasheet or Design View
D.) Data may be entered only in a form
2.) Which of the following is true for the Query Wizard?
A.) You can only select tables as a source
B.) No criteria can be added
C.) Fields from multiple tables are not allowed
D.) You do not need a summary
3.) Which of the following was not a suggested guideline for designing a table?
A.) Include all necessary data
B.) Store data in its smallest parts
C.) Avoid calculated fields
D.) Link tables using common fields
4.) A query’s specifications providing instructions about which records to include must be entered:
A.) On the Show row of the query design grid
B.) On the Sort row of the query design grid
C.) On the Criteria row of the query design grid
D.) On the Table row of the query design grid
5.) An illustration of a one-to-many relationship would be:
A.) A person changes his/her primary address
B.) A customer may have multiple orders
C.) A branch location has an internal branch ID code
D.) A balance field is totaled for all accounts for each person
6.) When adding criteria to the query design view:
A.) The value you enter must be delimited by quotes
B.) The value you enter must be delimited by pound signs
C.) The value you enter must be delimited by nothing
D.) Access will add the correct delimiters for you.
7.) When importing data into Access, which of the following statements is true?
A.) The Import Wizard only works for Excel files
B.) The wizard can be found on the Create tab
C.) You can assign the primary key while you are importing Excel data
D.) The wizard will import the data in one...