Exam 10: Creating a Database

You should use the ________ data type for fields that contain words and symbols of up to 255 characters in length.

A primary key is a field that _________ identifies each record.

Which of the following contains information about a single entity in the database?

To open a table the next time you start Access, open the database and then right-click the table name in the Navigation Pane.

An ID field's data type is IntNumber .

To identify the table you should give it a(n) __________ name.

When you create a new database, Access creates an empty table called Table1.

Access provides tools you can use to manipulate data in the database and they are contained in the ___________.

Which of the following icons should you click to save the table?

Which of the following buttons should you click to add all fields to the query?

After a query is saved, you can run it repeatedly to display all the records that match the criteria you've specified.

A ______ contains one record.

By default, the data type for the primary key is _________.

Import options are listed on Access's ______________ tab.

Microsoft Access is designed for creating and accessing ________ databases.

A comma-delimited file is simply data separated by commas, and it is referred as a _____ file.

Case Based Critical Thinking Questions Case 10-1 Maxwell has developed a Movies database. He presented his design to his class, and some of his listeners had questions. Here is one of the tables Maxwell showed to the audience. Kyra asks how to select all movies that received an award between 1940 and 1955. Maxwell tells her that the query criteria for the Award Year field should be: _____.

The ________ key is used to delete text to the left of the insertion point.

Each category of data is stored in a database ______.

Fields names cannot contain spaces or special characters.