Question 1

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 it is a feature of relational databases. It ensures that data remains consistent and prevents orphaned records in linked tables. If a record with a matching primary key in another table is deleted, it could result in a loss of data integrity, so Access enforces this restriction by default.

Question 2

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

Accepted Answer

Yes, a make-table query can be used to create a new table based on the results of a select query or an existing table. This new table can serve as an archive table for storing historical data or for backup purposes.

Question 3

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

Accepted Answer

Validation rules set specific criteria that must be met when entering data to ensure accuracy, completeness, and consistency. They can help to prevent errors, such as entering incorrect data types, values, or formats.

Question 4

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 one book rep can have many customers, but each customer can only be associated with one book rep.

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

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 7

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 8

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

A default value can be set for a field in a table in Access, and it will be displayed in that field when a new record is added unless the user enters a different value.

Question 9

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 10

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 pre-defined list of values which a user can choose from while updating the contents of the field. This helps to ensure data consistency and accuracy.

Question 11

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 12

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 13

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

Accepted Answer

Totals

Question 14

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 15

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

For sorting data on multiple fields, the major and minor keys should be adjacent to each other, but the major key should be on the left, followed by the minor keys to its right.

Question 16

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 17

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

Accepted Answer

Calculated fields are automatically generated by a formula or expression and their values cannot be manually changed or updated by users.

Question 18

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 19

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

Accepted Answer

multivalued

Question 20

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.

Quiz 17: Access: Maintaining a Database