Question 1

Each category of data is stored in a database _________.

Accepted Answer

The answer of Each category of data is stored in...

Question 2

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: _____. A) >= 1940 AND <= 1955 B) >= 1940 OR <= 1955 C) = 1940 AND = 1955 D) HIGHER THAN 1940 AND LOWER THAN 1955

Accepted Answer

The query criteria for the Award Year field should include movies with award year greater than or equal to 1940 and less than or equal to 1955. Therefore, the correct syntax is >= 1940 AND <= 1955.

Question 3

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

Accepted Answer

The answer of A primary key is a field that...

Question 4

To open a table, double-click the name of the table in the ___________.

Accepted Answer

The answer of To open a table, double-click the name...

Question 5

To define a field for a table, you begin by selecting a(n) __________.

Accepted Answer

The answer of To define a field for a table,...

Question 6

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.  Referring to the figure above, Leon asks which of the following fields uses a Number data type. What field does Maxwell point to?
A) Film Title
B) Director
C) MPAA
D) Nominations

Accepted Answer

Maxwell points to the "Nominations" field, which uses a Number data type to store the number of award nominations a particular movie has received. The other fields (Film Title, Director, MPAA) all use Text data types to store their respective information.

Question 7

The primary key is an important field in an Access table. Please describe a primary key. Does Access create the primary key or can you create it yourself?

Accepted Answer

The answer of The primary key is an important field...

Question 8

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.  Referring to the figure above, James asks which of the columns is a primary key. Maxwell points to _____.
A) A
B) B
C) C
D) D

Accepted Answer

The answer of Case Based Critical Thinking Questions Case 10-1...

Question 9

A(n) _____________ file is simply data separated by commas.

Accepted Answer

The answer of A(n) _____________ file is simply data separated...

Question 10

When you create a table you must specify a data type for each field. Please describe each of these data types: Date & Time, Number, AutoNumber, Yes/No.

Accepted Answer

The answer of When you create a table you must...

Question 11

A(n) _______ contains criteria that specify what you would like to find.

Accepted Answer

The answer of A(n) _______ contains criteria that specify what...

Question 12

New records are always added at the _____ of the table.

Accepted Answer

The answer of New records are always added at the...

Question 13

To enter the field name, simply type it, then press the ______ key.

Accepted Answer

The answer of To enter the field name, simply type...

Question 14

A(n) _________ database is very flexible because it can store data for several different but related categories.

Accepted Answer

The answer of A(n) _________ database is very flexible because...

Question 15

The quickest way to save a table is to click the Save button on the ___________ toolbar.

Accepted Answer

The answer of The quickest way to save a table...

Quiz 10: Creating a Database