Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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 5

An ID field's data type is IntNumber .

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  unique and short 
B)  numeric 
C)  unique and descriptive 
D)  automatically generated

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

A)   
B)   
C)   
D)

Question 10

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

Accepted Answer

A)   
B)   
C)   
D)

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

A ______ contains one record.

Accepted Answer

A)  cell 
B)  column 
C)  row 
D)  table

Question 13

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

Accepted Answer

A)  Number 
B)  AutoNumeric 
C)  AutoNumber 
D)  UniqueNumber

Question 14

Import options are listed on Access's ______________ tab.

Accepted Answer

A)  EXTERNAL DATA 
B)  EXPORT DATA 
C)  IMPORT DATA 
D)  DATABASE TOOLS

Question 15

Microsoft Access is designed for creating and accessing ________ databases.

Accepted Answer

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

Question 16

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 17

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

Accepted Answer

A)  >= 1940 AND = 1940 OR <= 1955 
C)  = 1940 AND = 1955 
D)  HIGHER THAN 1940 AND LOWER THAN 1955

Question 18

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 19

Each category of data is stored in a database ______.

Accepted Answer

A)  query 
B)  field 
C)  table 
D)  record

Question 20

Fields names cannot contain spaces or special characters.

Accepted Answer

A) True 
 B)False

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.

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.