Exam 1: Access 1: Getting Started With Access

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) ____________________ field automatically assigns a new number each time you add a record.

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

Which keystroke combination moves focus to the last field of the last record?

In Access, two users can edit the same record at the same time. ____________________​

Which Access object provides an easy-to-use data entry screen?

Which editing keystroke deletes one character to the right of the insertion point?

Critical Thinking Questions Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. A Purchase Price field should be which data type?

While editing a record, pressing [Esc] a second time ____.

If the Navigation Pane is not open, click the _____ to open it and view the database objects.​

Tables contain all of the data in the database.

What are the advantages of using Access for database management?

A(n) ____________________ key field contains unique data for each record.

Which shortcut key moves focus to the previous field of the current record?

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

Each object in an Access database application displays at the left side of the Access window in the ____.

You can use the Calendar Box to enter dates in a Date/Time field. _________________________

A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data.