FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Creating a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

Microsoft Access is designed for creating and accessing ________ databases.

A) dynamic
B) relational
C) distributed
D) personal

E) A) and B)
F) C) and D)

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

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

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: _____.

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

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

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

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

Import options are listed on Access's ______________ tab.

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

An ID field's data type is IntNumber .

Each category of data is stored in a database ______.

A ______ contains one record.

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

Fields names cannot contain spaces or special characters.

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

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

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

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