Deck 6: Databases With Access

Question 1

Which one of the following is not a component of the Query Design view?

A) table pane
B) field list(s)
C) navigation bar
D) design grid

Answer 1

C

Question 2

Which one of the following is not a data type?

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

Answer 2

D

Question 3

To see the results of a query,

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

Answer 3

B

Question 4

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.

Question 5

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

Question 6

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

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

Question 7

The results of a filter performed in a query will be saved when the query is saved.

Question 8

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

Question 9

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

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

Question 10

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

Question 11

The report Design view gives you the most control over the layout of labels and text boxes.

Question 12

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

Question 13

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

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

Question 14

The default field size for a text field type is

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

Question 15

A relationship

A) is a way to print tables
B) is a combination of two tables
C) links identical fields between two tables
D) links queries between two files

Question 16

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

Question 17

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

Question 18

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

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

Question 19

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

Question 20

A primary key

A) is required for every field
B) is the default value of a field
C) uniquely defines a record
D) is required in all forms

Question 21

A/an ____________________ is the preferred Access object to use when adding, editing, and deleting data stored in tables.

Question 22

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 ____________________.

Question 23

If you were creating a database table to contain the names of your school's band members, which data type would you select for the Primary Instrument field?

A) Text
B) Text using the Lookup Wizard
C) OLE Object
D) Memo

Question 24

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?

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

Question 25

In the form Layout view, which one of the following objects cannot be changed?

A) name of a text box
B) contents of the form title
C) color scheme
D) name of a label

Question 26

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

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 27

To view all employees that do not have a phone number, you would enter ____________________ as the criteria for the phone number field.

Question 28

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

Question 29

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

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