Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

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?

Accepted Answer

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

Question 4

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 5

A primary key

Accepted Answer

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 
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 6

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 7

A relationship

Accepted Answer

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 
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 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

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

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

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/an ____________________ is the preferred Access object to use when adding, editing, and deleting data stored in tables.

A primary key

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

A relationship

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

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

Business Documents With Word

Presentations With Powerpoint

Spreadsheets With Excel

Publications With Publisher

Desktop Information Management With Outlook

Filters

Exam 6: Databases With Access

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

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

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/an ____________________ is the preferred Access object to use when adding, editing, and deleting data stored in tables.

A primary key

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

A relationship

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

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

Business Documents With Word

Presentations With Powerpoint

Spreadsheets With Excel

Publications With Publisher

Desktop Information Management With Outlook

Filters