Question 1

How many characters can be stored in a field with a Short Text data type?
A)100
B)255
C)500
D)256

Accepted Answer

A field with Short Text data type can store up to 255 characters.

Question 2

What data type assigns the next consecutive number to new records?
A)Number
B)AutoNumber
C)IncreaseNumber
D)Integer

Accepted Answer

The AutoNumber data type assigns the next consecutive number to new records. The other options are not specific to this function.

Question 3

What field property increases the speed at which searches can be performed?
A)Indexed
B)Allow Zero Length
C)Required
D)Result Type

Accepted Answer

Indexing a field creates a separate table that stores the values of that field in a more efficient way for searching and sorting. This speeds up queries that use that field in the WHERE or ORDER BY clauses.

Question 4

What field property forces data to follow certain rules of data entry?
A)Validation Rule
B)Validation Text
C)Format
D)Required

Accepted Answer

Validation Rules force data to follow specific rules during data entry, such as requiring a certain format or range of values. Validation Text provides a message to the user if the validation rule is not met. Format and Required are field properties that affect the appearance and behavior of the field, but do not enforce specific rules for data entry.

Question 5

When does the validation rule check the entered data?
A)As soon as it is typed into the field
B)When the user exits the field
C)When the table or form is saved
D)When the table of form is closed

Accepted Answer

The validation rule checks the entered data when the user exits the field. This allows the user to see if they have entered any incorrect data before moving on to the next field or submitting the form. Checking the data as soon as it is typed into the field may be too strict and cause frustration for the user, while waiting until the table or form is saved or closed may allow incorrect data to be entered and stored in the database.

Question 6

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?
A)Required
B)Indexed
C)Allow Zero Length
D)Allow Null Length

Accepted Answer

The "Allow Zero Length" field property allows the user to enter two quote marks with nothing between them ("") into a field with a Short Text data type. This is because the property allows for empty or null values to be entered into the field. The other field properties, such as Required and Indexed, would not allow for this type of input.

Question 7

What field property makes up for the limitation of the field naming rules or common practices?
A)Validation Rule
B)Input Mask
C)Format
D)Caption

Accepted Answer

The Caption property allows users to define how the field name appears in forms and reports, offering a way to use more user-friendly or descriptive names than what might be allowed or practical in the database schema itself. This makes up for limitations in field naming conventions or practices by providing a more flexible, readable label for users.

Question 8

What is not true about the hyperlink data type?
A)It can store the URL for a web page.
B)It can store the path to a file.
C)The hyperlink becomes active anytime you hover over it.
D)It can store the path to a folder.

Accepted Answer

The statement "The hyperlink becomes active anytime you hover over it" is not true. The hyperlink becomes active only when it is clicked on. A hyperlink data type can store URLs for web pages, paths for files, and folders.

Question 9

What is not true about data types?
A)It is best to choose Short Text for all fields at first,because they can easily be changed later.
B)Every field is assigned a data type.
C)They determine what operations can be performed on the data.
D)They can be changed after the table has been created.

Accepted Answer

It is not always best to choose Short Text for all fields at first because it may not be suitable for certain types of data, such as numeric or date/time fields. It is important to choose the appropriate data type for each field from the outset to ensure data accuracy and prevent problems later on.

Question 10

What is the suggested data type for a street address?
A)Long Text
B)Number
C)OLE Object
D)Short Text

Accepted Answer

Street addresses vary in length and can include alphanumeric characters, as well as special characters such as punctuation marks and spaces. Short Text data type can accommodate up to 255 characters, making it the most appropriate choice for street addresses. Numbers (B) would not work because it cannot accommodate special characters and spaces. Long Text (A) and OLE Object (C) are both excessive and unnecessary for a simple street address field.

Question 11

What option automatically deletes records in related tables that match the primary key?
A)Autodelete Related Records
B)Cascade Update Related Fields
C)Cascade Delete Related Records
D)Delete and Update Related Records

Accepted Answer

Cascade Delete Related Records is the option that automatically deletes records in related tables that match the primary key. This is useful when dealing with data that has dependencies and ensuring that all related data is removed when a primary record is deleted. The other options, Autodelete Related Records, Cascade Update Related Fields, and Delete and Update Related Records, do not have the same functionality.

Question 12

If you want the results of a query to display only those records that meet all criteria,you would use the ________ operator.
A)OR
B)NOT
C)AND
D)NOR

Accepted Answer

The AND operator only selects records that meet all of the criteria specified in the query. Therefore, it is the best choice to display only those records that meet all criteria. The OR operator selects records that meet any of the criteria, while the NOT operator selects records that do not meet the criteria. The NOR operator is not a valid logical operator in this context.

Question 13

What field property insures that all phone numbers have a consistent look?
A)Caption
B)Format
C)Default Value
D)Input Mask

Accepted Answer

The Input Mask field property allows for a consistent format in phone numbers by specifying the characters that should be entered and where they should be placed. For example, (###) ###-#### could be the Input Mask for a phone number field, ensuring all entries follow the same format.

Question 14

What is not true about field names?
A)They can be up to 64 characters in length.
B)They should describe the data they will store.
C)They can contain numbers.
D)They can begin with a space.

Accepted Answer

Field names cannot begin with a space as this may cause errors in data retrieval and manipulation.

Question 15

Storing a book's title in more than one table within a database is considered data ________.
A)backup
B)redundancy
C)duplication
D)consistency

Accepted Answer

Storing a book's title in more than one table within a database is considered data redundancy, which means having duplicated data in more than one place in a database. It can lead to inconsistencies and errors in the data. The best option is to avoid redundancy and ensure consistency in the data.

Question 16

What field property would you use to automatically enter "PA" in a state field?
A)Format
B)Caption
C)Default Value
D)Start Value

Accepted Answer

The Default Value field property allows you to define a default value for a field, which will automatically populate that field for new records. In this case, setting the Default Value to "PA" for a state field would automatically enter "PA" in that field for any new records created.

Question 17

How many characters can be stored in a field with a Long Text data type?
A)1,000
B)12,256
C)Unlimited
D)64,000

Accepted Answer

A field with a Long Text data type in databases such as Microsoft Access can store up to 64,000 characters.

Question 18

What is not true about the Caption property?
A)It allows labels to be more readable than field names.
B)It displays at the column head instead of the field name.
C)It is used in both forms and reports.
D)The Pascal case is preferred in this property.

Accepted Answer

The Pascal case is not preferred in the Caption property. It is recommended to use proper capitalization, with the first letter of each word capitalized and the rest in lowercase.

Question 19

"lastName" is an example of ________.
A)Camel case
B)Pascal case
C)a typing error
D)a naming convention that is not recommended because of possible compatibility issues

Accepted Answer

"lastName" follows the camel case naming convention, where the first letter of the first word is lowercase and the first letter of each subsequent concatenated word is capitalized.

Question 20

What is not one of the six guidelines for designing tables?
A)Store data in as large of number of parts as possible
B)Determine the primary keys
C)Link the tables on related fields
D)Think of what needs you might have in the future

Accepted Answer

Storing data in as large of number of parts as possible is not one of the guidelines for designing tables. It is generally recommended to keep data organized, normalized and in appropriate sized parts.

Quiz 3: Tables and Queries in Relational Databases

How many characters can be stored in a field with a Short Text data type?

What data type assigns the next consecutive number to new records?

What field property increases the speed at which searches can be performed?

What field property forces data to follow certain rules of data entry?

When does the validation rule check the entered data?

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?

What field property makes up for the limitation of the field naming rules or common practices?

What is not true about the hyperlink data type?

What is not true about data types?

What is the suggested data type for a street address?

What option automatically deletes records in related tables that match the primary key?

If you want the results of a query to display only those records that meet all criteria,you would use the ________ operator.

What field property insures that all phone numbers have a consistent look?

What is not true about field names?

Storing a book's title in more than one table within a database is considered data ________.

What field property would you use to automatically enter "PA" in a state field?

How many characters can be stored in a field with a Long Text data type?

What is not true about the Caption property?

"lastName" is an example of ________.

What is not one of the six guidelines for designing tables?