Question 1

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

Question 2

Microsoft Access is designed for creating and accessing _____ databases.

Accepted Answer

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

Question 3

After opening a New Query window, which of the following would you usually select?

Accepted Answer

A)  Crosstab Query Wizard 
B)  Simple Query Wizard 
C)  Find Duplicates Query Wizard 
D)  Find Unmatched Query Wizard

Question 4

Case Based Critical Thinking Questions Case 17-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 accompanying figure, 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

Question 5

Which of the following buttons should you click to open the File New Database dialog box?

Accepted Answer

A)   
B)   
C)   
D)

Question 6

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

Accepted Answer

A)  Delete 
B)  Shift + Delete 
C)  Backspace 
D)  Shift + Backspace

Question 7

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

Accepted Answer

A)  CDF 
B)  CSV 
C)  CSD 
D)  CDD

Question 8

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 9

The way databases appear on the screen is similar to the way they will look when printed.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  Navigation Pane 
B)  Manipulation Pane 
C)  Navigation Toolbar 
D)  HOME tab

Question 11

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

Question 12

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

Accepted Answer

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

Question 13

You can modify data within a field using Backspace, Delete, and typing keys. To complete the modification you should press the _____ key.

Accepted Answer

A)  Ctrl + Shift 
B)  Esc 
C)  Enter 
D)  Shift + Enter

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Which of the following buttons is a Create button?

Accepted Answer

A)   
B)   
C)   
D)

Question 16

A new database is an empty shell.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

A _____ is composed of fields and records.

Accepted Answer

A)  table 
B)  query 
C)  form 
D)  report

Question 19

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 20

All of the following are elements that make up the database, except _____.

Accepted Answer

A)  tables 
B)  requests 
C)  forms 
D)  reports

Exam 17: Creating a Database

New records are added _____.

Microsoft Access is designed for creating and accessing _____ databases.

After opening a New Query window, which of the following would you usually select?

Which of the following buttons should you click to open the File New Database dialog box?

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

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

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

The way databases appear on the screen is similar to the way they will look when printed.

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

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

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

You can modify data within a field using Backspace, Delete, and typing keys. To complete the modification you should press the _____ key.

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

Which of the following buttons is a Create button?

A new database is an empty shell.

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

A _____ is composed of fields and records.

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

All of the following are elements that make up the database, except _____.