Question 1

Press [Esc] once to undo a change to the current field.

Accepted Answer

This is the correct method to undo a change in the current field. Pressing the Escape key once will undo the previous change made in the field.

Question 2

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

Accepted Answer

A subdatasheet is a view that shows related records from a table or query on the "many" side of a one-to-many relationship. It allows you to see and edit the related records without having to switch to a different view or form.

Question 3

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

Accepted Answer

False

Question 4

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables. _________________________

Accepted Answer

primary

Question 5

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

Accepted Answer

This is correct. The foreign key field is used to link the "many" side of the relationship to the primary key field on the "one" side of the relationship.

Question 6

In Access, data entry screens are called forms . _________________________

Accepted Answer

This is true. In Access, forms are used to create data entry screens for users to input or edit data in a more user-friendly way than directly modifying tables.

Question 7

No two records can have the same value in the primary key field.

Accepted Answer

This is the fundamental concept of a primary key in a database - it must uniquely identify each record in the table.

Question 8

Pressing [Ctrl][;] will insert the current date in a Date field.

Accepted Answer

Pressing [Ctrl][;] will insert the current date in a Date field.

Question 9

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

AutoNumber fields are designed to automatically generate a unique number for each record in a table. Access creates these values automatically without any input from the user.

Question 10

The [F2] key switches between Edit and Navigation modes.

Accepted Answer

The F2 key does switch between Edit and Navigation modes in many software applications, such as Microsoft Excel and Microsoft Word.

Question 11

More than one person can enter, update, and analyze data in an Access database at the same time.

Accepted Answer

Microsoft Access supports multi-user functionality, allowing multiple users to work on the database simultaneously, provided it is set up correctly for shared access.

Question 12

Access databases cannot be password protected.

Accepted Answer

Access databases can be password protected to restrict unauthorized access and ensure data security.

Question 13

"Focus" refers to which data you would edit if you started typing.

Accepted Answer

When you start typing, the cursor is placed where you want to type and that is where you would insert, edit or delete the data. Therefore, focus refers to the data you would edit if you started typing.

Question 14

The navigation buttons are found at the top of the datasheet. _________________________

Accepted Answer

bottom
lower-left corner

Question 15

Field properties change depending on the data type of the field.

Accepted Answer

Field properties such as field size, format, input mask, validation rule, etc. vary based on the data type of the field in a database.

Question 16

Tables contain all of the data in the database.

Accepted Answer

The answer of Tables contain all of the data in...

Question 17

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode. _________________________

Accepted Answer

If Access assumes that you are attempting to make changes to a field value, you are not in Navigation mode, but in Edit mode. Navigation mode is when you are browsing through data and not making any changes to it.

Question 18

An Access database is limited to a size of 1 gigabyte.

Accepted Answer

The answer of An Access database is limited to a...

Question 19

The navigation buttons on a datasheet display the total number of fields in the datasheet.

Accepted Answer

The navigation buttons on a datasheet display the total number of records in the datasheet, not the number of fields.

Question 20

A primary key field uniquely identifies each record.

Accepted Answer

A primary key field is a unique identifier for each record in a database table. It ensures that each record is uniquely identified and can be accessed easily.

Quiz 1: Getting Started With Access

Press [Esc] once to undo a change to the current field.

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables. _________________________

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

In Access, data entry screens are called forms . _________________________

No two records can have the same value in the primary key field.

Pressing [Ctrl][;] will insert the current date in a Date field.

Values in an AutoNumber field are automatically created by Access.

The [F2] key switches between Edit and Navigation modes.

More than one person can enter, update, and analyze data in an Access database at the same time.

Access databases cannot be password protected.

"Focus" refers to which data you would edit if you started typing.

The navigation buttons are found at the top of the datasheet. _________________________

Field properties change depending on the data type of the field.

Tables contain all of the data in the database.

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode. _________________________

An Access database is limited to a size of 1 gigabyte.

The navigation buttons on a datasheet display the total number of fields in the datasheet.

A primary key field uniquely identifies each record.