Question 1

A default value is a value that Access will display on the screen in a particular field before the user begins adding a record.____________________

Accepted Answer

This statement is true. A default value can be set for a field in Access, and it will appear in the field before the user begins adding a new record.

Question 2

You can use a make-table query to create an archive table.

Accepted Answer

A make-table query can be used to create a new table based on the results of a select query, which can be used as an archive table to store historical data.

Question 3

When you have created a filter using Advanced Filter/Sort,you can save the filter settings as a query by using the ____________________ command on the Advanced menu.

Accepted Answer

The answer of When you have created a filter using...

Question 4

You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.

Accepted Answer

In many database and spreadsheet systems, you can convert data between Number and Currency fields, although the process and capabilities may vary. Converting from Currency to Number is typically possible, but you might lose currency-specific formatting or information.

Question 5

You cannot preview the data to be updated in an update query before actually performing the update.

Accepted Answer

Most database management systems allow you to write a SELECT query to preview the data that will be affected by an UPDATE query, by using the same conditions/filters as the UPDATE query.

Question 6

Validation rules are rules that a user must follow when entering the data.

Accepted Answer

Validation rules ensure that the data entered by the user meets certain criteria or conditions, such as a specific format or range of values. The user is required to follow these rules in order to successfully enter the data.

Question 7

A lookup field allows the user to select from a list of values when updating the contents of a field.

Accepted Answer

A lookup field provides a dropdown list of values that the user can choose from when updating a field. Therefore, the statement is true.

Question 8

You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.

Accepted Answer

The answer of You can restore filter settings that you...

Question 9

When the Book Rep table is related to the Customer table,it is possible to view the customers of a given book rep when you are viewing the datasheet for the Book Rep table.The customers for the book rep will appear below the book rep in a split form.____________________

Accepted Answer

subdatasheet

Question 10

Maintenance of a database can involve the need to _________________________ periodically;that is,to change the database structure.

Accepted Answer

The answer of Maintenance of a database can involve the...

Question 11

To sort the data that appears in a datasheet on multiple fields,the major and minor keys must be next to each other in the datasheet with the major key on the right.

Accepted Answer

The major and minor keys should be next to each other in the datasheet, but the major key should be on the left, not the right.

Question 12

Normally,Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

Accepted Answer

This is known as referential integrity and is a key concept in database design. It ensures that the data remains consistent and prevents orphaned records.

Question 13

You can use the asterisk (*)wildcard in a filter but not the question mark (?)wildcard.

Accepted Answer

Both the asterisk (*) and the question mark (?) can be used as wildcards in filters, with the asterisk representing any number of characters and the question mark representing a single character.

Question 14

A(n)____________________ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

Accepted Answer

The answer of A(n)____________________ is a form that allows you...

Question 15

A secondary key is a field in one table whose values are required to match the primary key of another table.____________________

Accepted Answer

foreign

Question 16

A multilookup field is a field that contains more than one value.____________________

Accepted Answer

multivalued

Question 17

If you add a field to a table and later realize the field is in the wrong location,you can move the field.To move the field,tap or click the ____________________ for the field and then drag the field to the new location.

Accepted Answer

The answer of If you add a field to a...

Question 18

When you create a calculated field,users can update the field.

Accepted Answer

Calculated fields are automatically generated based on a formula, and cannot be edited or updated by users.

Question 19

In the Bavant Publishing database,a one-to-many relationship exists between the Book Rep table and the Customer table.

Accepted Answer

This means that each Book Rep can have many customers, but each customer can only have one Book Rep assigned to them.

Question 20

To display the Total row in a datasheet,tap or click the Sum button on the ribbon.____________________

Accepted Answer

Totals

Quiz 6: Access: Maintaining a Database