Exam 67: Database Tables

When you create a field to hold a customer's name,you should select the ____ data type.

To begin importing Excel data into Access,click on the ____ tab.

You need to store the names of your customers in a new database.How should this be accomplished?

In Access,related fields are grouped in the Data Type Gallery for quick and easy access.

When you specify the kind of data to put in the field you want to create,you are selecting the ____ for the field.

Before you can enter data into a database,you must create a ____ to hold the data.

Data separated by commas within an imported text file is interpreted by Access as delimited content.

By default,in Access,a ____ named ID appears in every new table.

A customer's last name is a good example of a primary key.

Once a field is created in a table,it cannot be subsequently moved to a new location in the table because this action corrupts the database.

When you initially open Access,a list of the most recently opened databases appears.

Which of the following is a good example of a primary key?

In Access,the default table view is ____ view.

When opening a file from a trusted source,if needed,click the orange "Enable Editing" security warning button to work in the file.

Columns in a spreadsheet are akin to ____ in a database table.

When you use the Data Type Gallery,____.

Using the ____ category allows you to add certain groups of fields as a collection rather than adding one field at a time.

Creating a ____ sets up a relationship between tables that share a common field.

To import only an Access table's structure and not its data,choose the ____ option in the Import Tables box.

You need to create a new field in a database table.Select the best option from the following list for naming a field that will contain a company's name.