Microsoft Office Excel

Computing

Quiz 3 :

Tables and Queries in Relational Databases

Quiz 3 :

Tables and Queries in Relational Databases

Question Type
search
arrow
"lastName" is an example of ________.
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
What field property insures that all phone numbers have a consistent look?
Free
Multiple Choice
Answer:

Answer:

D

Tags
Choose question tag
close menu
arrow
What field property increases the speed at which searches can be performed?
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
What field property makes up for the limitation of the field naming rules or common practices?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What field property would allow the user to enter two quote marks with nothing between them ("") into a field with a Short Text data type?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What field property forces data to follow certain rules of data entry?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
How many characters can be stored in a field with a Short Text data type?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What data type assigns the next consecutive number to new records?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
How many characters can be stored in a field with a Long Text data type?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What option automatically deletes records in related tables that match the primary key?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What is not true about data types?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What is not true about the Caption property?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What is not true about the hyperlink data type?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What is the suggested data type for a street address?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Storing a book's title in more than one table within a database is considered data ________.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What field property would you use to automatically enter "PA" in a state field?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
If you want the results of a query to display only those records that meet all criteria, you would use the ________ operator.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What is not true about field names?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What is not one of the six guidelines for designing tables?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
When does the validation rule check the entered data?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 97