Question 1

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 rule forces data to follow certain rules of data entry. It allows setting conditions for data entry and displays an error message if the conditions are not met. Validation rule ensures accurate and consistent data entry.

Question 2

Which option would this wildcard, "H[!oe]" not display?
A)House
B)Hat
C)His
D)Humming

Accepted Answer

The answer of Which option would this wildcard, "H[!oe]" not...

Question 3

Which field property helps a user know why an entry error was generated?
A)Validation Text
B)Validation Rule
C)Expression
D)Error Code

Accepted Answer

Validation Text provides a message that appears when a user enters data that does not meet the requirements of the Validation Rule. The message can help the user understand why the error occurred and what needs to be corrected.

Question 4

When you purchase from a store several times this would be an example of what kind of table relationship?
A)Many-to-one (many purchases - one customer)
B)One-to-one (one customer - one store)
C)Many-to-many (many items purchased - many times)
D)One-to-many (one customer - many purchases)

Accepted Answer

This is a one-to-many relationship because one customer can make many purchases at the store.

Question 5

What field property helps to make sure that correct data is entered?
A)Validation text
B)Validation rule
C)Format
D)Required

Accepted Answer

The validation rule is the field property that helps to make sure that correct data is entered. It sets parameters for the data that can be entered into the field, ensuring that it meets certain criteria such as being within a specific range or format. This helps prevent data entry errors and ensures consistency and accuracy in the database.

Question 6

What objects will not use the caption instead of the field names?
A)Macros
B)Datasheets
C)Forms
D)Reports

Accepted Answer

Macros do not display data directly, so they do not use captions instead of field names.

Question 7

What field property would allow the user to enter "" 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" property allows the user to enter an empty string ("") into a field with a Short Text data type.

Question 8

The first step to resizing a column in datasheet view is to move the pointer until it looks like a ________.
A)four-headed arrow and then click
B)two-headed arrow and then click
C)thick black line and then click
D)thick green line and then click

Accepted Answer

To resize a column in datasheet view, you move the pointer to the edge of the column header until it changes to a two-headed arrow, indicating that you can click and drag to adjust the column width.

Question 9

To limit the number of records displayed when a query is run you add ________.
A)sorting
B)criteria
C)less fields
D)less tables

Accepted Answer

Adding criteria to a query will limit the number of records displayed to only those that meet the specified conditions. Sorting, reducing the number of fields, or reducing the number of tables will not necessarily limit the number of records displayed.

Question 10

The query wizard is best used to create what kind of query?
A)Multitable queries
B)Single table queries
C)Advanced queries
D)Basic queries

Accepted Answer

The query wizard is best used to create basic queries.

Question 11

Where can you not use calculated fields?
A)In a report
B)In a module
C)In a form
D)In a table

Accepted Answer

The answer of Where can you not use calculated fields?
A)In...

Question 12

If you wanted the user to pick from a particular list, what would you pick from the data type drop down list for that field?
A)List
B)Short Text
C)Lookup Wizard
D)Long Text

Accepted Answer

The Lookup Wizard is the best choice for allowing the user to pick from a particular list. This allows the user to easily select a value from pre-defined options, rather than having to manually enter the data into a text field.

Question 13

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

Accepted Answer

The suggested data type for a street address is Short Text because it typically contains alphanumeric characters such as letters, numbers, and symbols. A Long Text data type would allow for more characters than necessary and could make data entry more time-consuming, while a Number or OLE Object data type would not be suitable for capturing the variety of characters present in a street address.

Question 14

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

Indexed fields create a separate table that can be searched more quickly, thus increasing the speed at which searches can be performed. Allow Zero Length and Required fields do not have an impact on search speed. Result Type is not a relevant field property in this context.

Question 15

What view offers the most flexibility in setting the properties of a field?
A)Datasheet view
B)Page Layout view
C)SQL view
D)Design View

Accepted Answer

Design View offers the most flexibility in setting the properties of a field, allowing detailed customization of data types, field sizes, and other attributes.

Question 16

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)It lists the hyperlink, but you must press the Ctrl key while you click the hyperlink for it to work
D)It can store the path to a folder

Accepted Answer

The statement is not true because you do not need to press the Ctrl key while clicking a hyperlink for it to work; this is a common behavior in some software applications, but not a requirement of the hyperlink data type itself.

Question 17

When you import data, where can you not store it?
A)New form
B)New table
C)Existing table
D)Linked table

Accepted Answer

When importing data, you cannot store it in a new form as forms are used for displaying data, not storing it. Storing data is typically done in tables. Therefore, options B, C, and D are all possible places to store imported data depending on the situation.

Question 18

Which of the following would make a good primary key?
A)AutoNumber data type
B)Customer number
C)Number data type
D)Birthday

Accepted Answer

The answer of Which of the following would make a...

Question 19

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 any error messages and make necessary changes before moving on to the next field. Checking the data as soon as it is typed into the field can be frustrating for users as they may have to correct mistakes repeatedly before being able to move on. Checking when the table or form is saved or closed may be too late, as it may lead to incorrect data being saved.

Question 20

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 specify a value that will automatically populate a field when a new record is created. So, setting the default value of the state field to "PA" will automatically enter "PA" in the field for every new record.

Quiz 2: Access: Tables and Queries in Relational Databases

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

Which option would this wildcard, "H[!oe]" not display?

Which field property helps a user know why an entry error was generated?

When you purchase from a store several times this would be an example of what kind of table relationship?

What field property helps to make sure that correct data is entered?

What objects will not use the caption instead of the field names?

What field property would allow the user to enter "" into a field with a Short Text data type?

The first step to resizing a column in datasheet view is to move the pointer until it looks like a ________.

To limit the number of records displayed when a query is run you add ________.

The query wizard is best used to create what kind of query?

Where can you not use calculated fields?

If you wanted the user to pick from a particular list, what would you pick from the data type drop down list for that field?

What is the suggested data type for a street address?

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

What view offers the most flexibility in setting the properties of a field?

What is not true about the hyperlink data type?

When you import data, where can you not store it?

Which of the following would make a good primary key?

When does the validation rule check the entered data?

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