Question 1

The Datasheet view of a table is the preferred format for printing data in a table.

Accepted Answer

A) True 
 B)False  False

Question 2

The city of Chicago is creating a database of its employees. Which one of the following fields would be least likely to have a default value?

Accepted Answer

A)   state
B)   ZIP Code
C)   city
D)   position or office D

Question 3

The default field size for a text field type is

Accepted Answer

A)   2
B)   25
C)   50
D)   255 D

Question 4

You can enter, edit, and delete data in the Layout view of a form.

Accepted Answer

A) True 
 B)False

Question 5

Suppose you are using a form to edit customer data. If you accidentally delete a record, click the Undo button to restore the record.

Accepted Answer

A) True 
 B)False

Question 6

Which one of the following is not a data type?

Accepted Answer

A)   Text
B)   Currency
C)   Date/Time
D)   HTML

Question 7

You can switch between Design view and Datasheet view by clicking the

Accepted Answer

A)   Queries object tab
B)   Switch command on the View menu
C)   View button and then clicking a view option
D)   Run button

Question 8

Which one of the following field properties would be least useful for a ZIP Code field?

Accepted Answer

A)   format
B)   input mask
C)   default value
D)   required value

Question 9

When creating a table, you must enter a field name, data type, and description.

Accepted Answer

A) True 
 B)False

Question 10

Which one of the following statements concerning importing data into Access is not correct?

Accepted Answer

A)   Data must resemble the structure of an Access table, including field names in the first row.
B)   Most input data is in a delimited (versus fixed-width)  format.
C)   Data can only be imported from Excel and other Access files.
D)   You can specify your own primary key or accept a default primary key.

Question 11

The Label Wizard displays a prototype label where symbols, such as commas, can be inserted.

Accepted Answer

A) True 
 B)False

Question 12

To have changes in an Excel workbook automatically update data in an Access database, you should ____________________ the Excel workbook to the Access database.

Accepted Answer

The answer of To have changes in an Excel workbook...

Question 13

Referential integrity is used to ensure that relationships in tables are valid.

Accepted Answer

A) True 
 B)False

Question 14

To view all items of inventory that have a quantity on hand of less than or equal to 1,200, you would enter <=1,200 in the criteria line.

Accepted Answer

A) True 
 B)False

Question 15

To see the results of a query,

Accepted Answer

A)   click the Close button
B)   click the Run button
C)   you must sort or filter the query first
D)   you must save the query first

Question 16

A company assigns all of its employees an e-mail address using their first and last initial and then a three-digit number, such as AB123. The input mask for this field would be ____________________.

Accepted Answer

The answer of A company assigns all of its employees...

Question 17

A category of information, such as last names or telephone numbers, is called a

Accepted Answer

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

Question 18

Which one of the following fields would not be assigned a Text data type?

Accepted Answer

A)   phone number
B)   employee identification number
C)   ZIP Code
D)   date of birth

Question 19

Which one of the following symbols in an input mask requires the input of only a single alphabetic character?

Accepted Answer

A)   #
B)   L
C)   A
D)   *

Question 20

A complete set of fields containing information about an item, such as a person or item of inventory, is called a record.

Accepted Answer

A) True 
 B)False

Exam 6: Databases With Access

The Datasheet view of a table is the preferred format for printing data in a table.

The city of Chicago is creating a database of its employees. Which one of the following fields would be least likely to have a default value?

The default field size for a text field type is

You can enter, edit, and delete data in the Layout view of a form.

Suppose you are using a form to edit customer data. If you accidentally delete a record, click the Undo button to restore the record.

Which one of the following is not a data type?

You can switch between Design view and Datasheet view by clicking the

Which one of the following field properties would be least useful for a ZIP Code field?

When creating a table, you must enter a field name, data type, and description.

Which one of the following statements concerning importing data into Access is not correct?

The Label Wizard displays a prototype label where symbols, such as commas, can be inserted.

To have changes in an Excel workbook automatically update data in an Access database, you should ____________________ the Excel workbook to the Access database.

Referential integrity is used to ensure that relationships in tables are valid.

To view all items of inventory that have a quantity on hand of less than or equal to 1,200, you would enter <=1,200 in the criteria line.

To see the results of a query,

A company assigns all of its employees an e-mail address using their first and last initial and then a three-digit number, such as AB123. The input mask for this field would be ____________________.

A category of information, such as last names or telephone numbers, is called a

Which one of the following fields would not be assigned a Text data type?

Which one of the following symbols in an input mask requires the input of only a single alphabetic character?

A complete set of fields containing information about an item, such as a person or item of inventory, is called a record.