Question 1

Which of the following contains a single fact that describes an entity?

Accepted Answer

A)  a report 
B)  a field 
C)  a form 
D)  a record 
A)  a report 
B)  a field 
C)  a form 
D)  a record

Question 2

When editing the data use the Delete key to delete text to the left of the insertion point.

Accepted Answer

A) True 
 B)False

Question 3

Creating a new database simply makes a file that becomes the storage for all database elements.

Accepted Answer

A) True 
 B)False

Question 4

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?

Accepted Answer

A)  Film Title 
B)  Director 
C)  MPAA 
D)  Nominations 
A)  Film Title 
B)  Director 
C)  MPAA 
D)  Nominations

Question 5

New records are added ______________________.

Accepted Answer

A)  at the beginning of the table 
B)  at a random location in the table 
C)  at the location specified by user 
D)  at the end of the table 
A)  at the beginning of the table 
B)  at a random location in the table 
C)  at the location specified by user 
D)  at the end of the table

Question 6

When you start Access, which of the following options are available?

Accepted Answer

A)  create a new database only 
B)  save a database 
C)  open an existing database only 
D)  create a new database or open an existing one 
A)  create a new database only 
B)  save a database 
C)  open an existing database only 
D)  create a new database or open an existing one

Question 7

The field you use for the primary key should have a checkmark in the _______ box.

Accepted Answer

A)  Required 
B)  Indexed 
C)  Validated 
D)  Unique 
A)  Required 
B)  Indexed 
C)  Validated 
D)  Unique

Question 8

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 9

A new database is an empty shell.

Accepted Answer

A) True 
 B)False

Question 10

Each table in a database is stored as a separate file.

Accepted Answer

A) True 
 B)False

Question 11

The data type for telephone numbers should be defined as ________.

Accepted Answer

A)  Short Text 
B)  Long Text 
C)  Number 
D)  AutoNumber 
A)  Short Text 
B)  Long Text 
C)  Number 
D)  AutoNumber

Question 12

Elements that make up the database include tables, records , forms, and queries.

Accepted Answer

A) True 
 B)False

Question 13

Microsoft Excel is the component of the Microsoft Office suite best suited for working with large collections of data.

Accepted Answer

A) True 
 B)False

Question 14

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 15

What is the maximum length for a field name?

Accepted Answer

A)  32 characters 
B)  64 characters 
C)  16 characters 
D)  20 characters 
A)  32 characters 
B)  64 characters 
C)  16 characters 
D)  20 characters

Which of the following contains a single fact that describes an entity?

When editing the data use the Delete key to delete text to the left of the insertion point.

Creating a new database simply makes a file that becomes the storage for all database elements.

New records are added ______________________.

When you start Access, which of the following options are available?

The field you use for the primary key should have a checkmark in the _______ box.

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

A new database is an empty shell.

Each table in a database is stored as a separate file.

The data type for telephone numbers should be defined as ________.

Elements that make up the database include tables, records , forms, and queries.

Microsoft Excel is the component of the Microsoft Office suite best suited for working with large collections of data.

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

What is the maximum length for a field name?

Getting Started With Application Software

Creating a Document

Formatting a Document

Finalizing a Document

Creating a Worksheet

Formatting a Worksheet

Finalizing a Worksheet

Creating a Presentation

Finalizing a Presentation

Finalizing a Database

Filters

Exam 10: Creating a Database

Which of the following contains a single fact that describes an entity?

When editing the data use the Delete key to delete text to the left of the insertion point.

Creating a new database simply makes a file that becomes the storage for all database elements.

New records are added ______________________.

When you start Access, which of the following options are available?

The field you use for the primary key should have a checkmark in the _______ box.

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

A new database is an empty shell.

Each table in a database is stored as a separate file.

The data type for telephone numbers should be defined as ________.

Elements that make up the database include tables, records , forms, and queries.

Microsoft Excel is the component of the Microsoft Office suite best suited for working with large collections of data.

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

What is the maximum length for a field name?

Getting Started With Application Software

Creating a Document

Formatting a Document

Finalizing a Document

Creating a Worksheet

Formatting a Worksheet

Finalizing a Worksheet

Creating a Presentation

Finalizing a Presentation

Finalizing a Database

Filters