Question 1

Insert the letter of the choice that best matches the phrase or definition.
-The wildcard character used to match any single alphabetic character.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)! 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Question 2

The default theme for a form as well as additional themes may be found in the ____________________ when viewing a form in Layout view.

Accepted Answer

The answer of The default theme for a form as...

Question 3

Insert the letter of the choice that best matches the phrase or definition.
-The Access feature that asks a series of questions and creates a report based on the answers to those questions.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)! 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Question 4

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon.____________________

Accepted Answer

A) True 
 B)False

Question 5

A form created from two tables that have a ____ relationship creates a main form and a subform.

Accepted Answer

A) one-to-one 
B) one-to-all 
C) many-to-many 
D) one-to-many 
A) one-to-one 
B) one-to-all 
C) many-to-many 
D) one-to-many

Question 6

The less precise way to move objects in report Layout view is to ____.

Accepted Answer

A) use the Move command to move objects 
B) use the arrow keys on the keyboard to move objects 
C) drag objects 
D) use the insert key on the keyboard to move objects 
A) use the Move command to move objects 
B) use the arrow keys on the keyboard to move objects 
C) drag objects 
D) use the insert key on the keyboard to move objects

Question 7

A form must be displayed in ____________________ view to navigate,view,and edit data.

Accepted Answer

The answer of A form must be displayed in ____________________...

Question 8

The default theme for a new form that is created is the ____________________ theme.

Accepted Answer

The answer of The default theme for a new form...

Question 9

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

Accepted Answer

A) table 
B) form 
C) query 
D) subdatasheet 
A) table 
B) form 
C) query 
D) subdatasheet

Question 10

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

Accepted Answer

The answer of Records printed in Form view are distinguished...

Question 11

The Columnar form layout displays the fields from one record at a time.____________________

Accepted Answer

A) True 
 B)False

Question 12

The appearance of fields in a report that is created using the Report Wizard is determined by ____.

Accepted Answer

A) the order of the fields in the table being used for the report 
B) the data type of each field in the table 
C) the size of each field in the table 
D) the order the fields are selected in the Report Wizard 
A) the order of the fields in the table being used for the report 
B) the data type of each field in the table 
C) the size of each field in the table 
D) the order the fields are selected in the Report Wizard

Question 13

Data in Date/Time fields are automatically ____-aligned.

Accepted Answer

A) left 
B) right 
C) center 
D) top 
A) left 
B) right 
C) center 
D) top

Question 14

Data in a form may only be modified in ____ view.

Accepted Answer

A) Form 
B) Layout 
C) Design 
D) Datasheet 
A) Form 
B) Layout 
C) Design 
D) Datasheet

Question 15

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

Accepted Answer

A) # 
B) + 
C) (?) 
D) * 
A) # 
B) + 
C) (?) 
D) *

Question 16

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

Accepted Answer

A) control 
B) design box 
C) replace character 
D) wildcard character 
A) control 
B) design box 
C) replace character 
D) wildcard character

Question 17

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

Accepted Answer

A) resize the object 
B) delete the object and recreate it 
C) move the object to another location 
D) change the caption 
A) resize the object 
B) delete the object and recreate it 
C) move the object to another location 
D) change the caption

Question 18

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

Accepted Answer

The answer of A set of controls grouped together in...

Question 19

Which of the following may be used as a wildcard character when searching for a value in Access?

Accepted Answer

A) % 
B) # 
C) ^ 
D) & 
A) % 
B) # 
C) ^ 
D) &

Question 20

Insert the letter of the choice that best matches the phrase or definition.
-The wildcard character that will match any single numeric character.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)! 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Insert the letter of the choice that best matches the phrase or definition. -The wildcard character used to match any single alphabetic character.

The default theme for a form as well as additional themes may be found in the ____________________ when viewing a form in Layout view.

Insert the letter of the choice that best matches the phrase or definition. -The Access feature that asks a series of questions and creates a report based on the answers to those questions.

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon.____________________

A form created from two tables that have a ____ relationship creates a main form and a subform.

The less precise way to move objects in report Layout view is to ____.

A form must be displayed in ____________________ view to navigate,view,and edit data.

The default theme for a new form that is created is the ____________________ theme.

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

The Columnar form layout displays the fields from one record at a time.____________________

The appearance of fields in a report that is created using the Report Wizard is determined by ____.

Data in Date/Time fields are automatically ____-aligned.

Data in a form may only be modified in ____ view.

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

Which of the following may be used as a wildcard character when searching for a value in Access?

Insert the letter of the choice that best matches the phrase or definition. -The wildcard character that will match any single numeric character.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 4: Creating Forms and Reports

Insert the letter of the choice that best matches the phrase or definition. -The wildcard character used to match any single alphabetic character.

The default theme for a form as well as additional themes may be found in the ____________________ when viewing a form in Layout view.

Insert the letter of the choice that best matches the phrase or definition. -The Access feature that asks a series of questions and creates a report based on the answers to those questions.

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon.____________________

A form created from two tables that have a ____ relationship creates a main form and a subform.

The less precise way to move objects in report Layout view is to ____.

A form must be displayed in ____________________ view to navigate,view,and edit data.

The default theme for a new form that is created is the ____________________ theme.

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

The Columnar form layout displays the fields from one record at a time.____________________

The appearance of fields in a report that is created using the Report Wizard is determined by ____.

Data in Date/Time fields are automatically ____-aligned.

Data in a form may only be modified in ____ view.

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

Which of the following may be used as a wildcard character when searching for a value in Access?

Insert the letter of the choice that best matches the phrase or definition. -The wildcard character that will match any single numeric character.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters