Question 1

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

Accepted Answer

The answer of A/an ____________________ is the preferred Access object...

Question 2

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 3

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

Accepted Answer

Choosing "Text using Lookup Wizard" would allow you to create a list of primary instruments that can be selected from a dropdown menu. This would ensure consistency in the data entered and make it easier to search and analyze the data in the future.

Question 4

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

Accepted Answer

The position or office held by an employee is unlikely to have a default value as it varies from person to person and is usually unique to each employee's role within the organization. State, ZIP code, and city, on the other hand, can often be inferred based on the employee's address or location of work, and therefore may have default values.

Question 5

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

Accepted Answer

In the form Layout view, you cannot change the name of a text box. The Layout view allows for adjustments to the form's appearance and layout, but renaming objects like text boxes requires switching to Design view.

Question 6

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.

Accepted Answer

Data can be imported into Access from a variety of sources beyond just Excel and other Access files, including CSV, text files, and ODBC data sources.

Question 7

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

Accepted Answer

The answer of To view all employees that do not...

Question 8

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 9

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

Accepted Answer

Date of birth would typically be assigned a Date/Time data type, not Text, to allow for date-specific operations and formatting.

Quiz 6: Databases With Access

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

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

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?

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?

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

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

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

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

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