Access-Lesson 2

The __________ contains predefined templates including in two categories , Blank Forms and Quick Start

Application

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

To save a database file in a location other than the default, click the a. Folder icon b. Blank database icon c. File name button d. Help button

a. folder icon.

After you have created a table or other database object, you should a. Save it with a descriptive name b. Copy it to create a backup c. Link it to an external data source d. Insert a blank column at the end

a. save it with a descriptive name

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

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

Structure

Which is Not a way to create a new database table? a. Use Quick Start b. Choose create on the Table menu c. Copy the structure of another table d. Create a new blank desktop database

b. Choose Create on the Table menu

When you create a new blank desktop database, Access opens a database that contains a. One of each type of database object. b. A table c. Sample data d. A template

b. a table.

The table structure is created when you a. Format the data b. enter data c. query the data d. create forms

b. enter data

The templates group commands are located on which tab? a. Home b. Create c. Database Tools d. Datasheet

b.Create

When you quit the program , Access automatically a. Creates a link between all tables b. Leave the Navigation Pane open c. Saves the data d . Renames the file

c. saves the data

To copy a table , you must first select it in a. The clipboard b. Microsoft Office online c. The Navigation pane d. Datasheet view

c. the Navigation Pane

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

column

When you paste a table , which dialog box is displayed? a. Table Structure b. Copy Table c. Paste Data d . Paste Table As

d. Paste Table As

In Access, a template is a. A database to manage contacts. b. Where a database is stored. c. Two tables linked together. d. a ready -to-use database.

d. a ready-to-use database.

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

excel worksheet

Several options for creating a database are provided on the ______ screen in Backstage view or the _______ screen when Access is initially launched.

new

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

quick start