Exam 67: Database Tables

When an Excel worksheet containing column headings is imported into Access,they can be used as field names in a new table.

The default field size for a text field is ____ characters.

The mask property allows you to create a template for an input field such as a(n)____ that requires a specific format.

Design view allows you to check data types,field properties,and descriptions in your database table.

A primary key uniquely identifies a given record within the database.

To use a database for decision making,you must first create multiple,independent tables.

Joining fields lets you extract data from two or more tables through a query.

Access tables can be created in either Datasheet or Design view.

You are ready to import a text file containing data into Access.To get started,you need to ____.

Column headings from a spreadsheet that was imported into Access will become ____ in a new table.

When importing an existing Access table into an Access database,if you do not want to import the structure,you can choose to import only its data.

A foreign key matches the ____ column of another table that has been cross referenced.

The Field Size setting specifies the number of characters you can store in a field.

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

Access tables contain individual rows,which are arranged in records.

Once a field is created in a table,it cannot be renamed.

Access databases cannot be imported into each other.

Before you can enter data into records,you need to create the ____ that will contain this data.

A database field name should contain spaces.

When importing Excel data into Access,the data can be used to create a new table.