Exam 1: Introduction to Access: Finding Your Way Through an Access Database

The ________ Database utility in Access creates a duplicate copy of a database.

How is referential integrity helpful?

What is an Access Web app?

A number, phrase, or expression used to select records in a table is called:

A sort can only list records in a database in a specific numeric sequence.

The F2 key puts you in Edit mode when in Access.

Tables, queries, reports, and forms are all examples of ________.

Both Access and Excel contain tools that can be used to extract and analyze information.

SharePoint is an add-on program for Access.

A primary key from one table that is used to form a relationship with a second table is called a(n) ________.

Which of the following is FALSE about the navigation bar in Access 2013?

The ________ displays the number of the current record as well as the total number of records in a table.

Match the following parts of an Access window to their descriptions: I. Navigation Pane II. Ribbon II. title bar IV. Field Properties pane V. Backstage view A. provides access to database tools such as Save, Save As, and Print B. contains details of each field C. displays full path name and file name D. area that organizes and lists database objects E. includes five tabs

You can create or modify a table's field names and data types in ________ view.

You may choose Access over Excel in all of the following situations EXCEPT when you:

A(n) ________ is the smallest data element of a table.

You can click the ________ button on the table toolbar to sort records in alphabetical order, from A to Z.

A template is a predefined database that can be used to jumpstart the creation of a database.