Access Lesson 2 Knowledge Assessment

The _______ contains predefined templates included in two categories, Blank Forms and Quick Start.

Application Parts gallery

Which is not a way to create a new database table?

Choose Create on the Table menu.

The Templates group commands are located on which tab?

Create

Several options for creating a database are provided on the _______ tab in the Backstage view.

New

When you paste a table, which dialog box is displayed?

Paste Table As

The _______ category in the Application Parts gallery contains a collection of predefined database objects for tracking comments, contacts, and issues.

Quick Start

In Access, a template is

a ready-to-use database.

When you create a new blank database, Access opens a database that contains

a table.

One way to create a table is to copy the _______ of an existing table and paste it into the database.

structure

You can use up to _______ characters (letters or numbers), including spaces, to name a database object.

64

Entering data in Datasheet view is very similar to entering data in a(n) _______.

Excel worksheet

You can create a database using one of the many templates available or by creating a new _______ database.

blank

A table is structured through rows and _______, which become meaningful when you enter data into it.

columns

The table structure is created when you

enter data.

To save a database file in a location other than the default, click the

folder icon

By default, Access creates a(n) _______ field named "ID" for all new datasheets.

primary key

When you add a new table to an existing database, that new table stands alone until you _______ it to your existing tables.

relate

After you have created a table or other database object, you should

save it with a descriptive name.

When you quit the program, Access automatically

saves the data.

To copy a table, you must first select it in

the Navigation Pane