Question 1

Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.

Accepted Answer

Answers might include: (1)It is importan

Question 2

Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.

Accepted Answer

The answer of Precise control for moving selected objects on...

Question 3

The Report Wizard allows detail records to be sorted by up to four fields. ____________________

Accepted Answer

A) True 
 B)False

Question 4

Print All, Pages, and Selected Record(s)are options available from the ____ for printing forms.

Accepted Answer

A) PRINT PREVIEW tab 
B) Print dialog box 
C) PRINT LAYOUT tab 
D) Print layout options dialog box 
A) PRINT PREVIEW tab 
B) Print dialog box 
C) PRINT LAYOUT tab 
D) Print layout options dialog box

Question 5

Match between columns
                        Premises: The wildcard character that will match any single numeric character.

Accepted Answer

The Answer of Layout view and # and $?$ and is...

Question 6

To generate a report with exact results based on specific criteria it is best to base the report on a(n)____________________ created in the database.

Accepted Answer

The answer of To generate a report with exact results...

Question 7

Report fields and field value boxes may be repositioned while viewing the report in Layout view.  ____________________

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: The button used to display the Find and Replace dialog box.

Accepted Answer

The Answer of Pencil symbol and Find and Report Wizard is...

Question 9

Options for modifying the format of report objects are found on the ____ tab in Layout view when the contextual REPORT LAYOUT TOOLS tab is available.

Accepted Answer

A) FORMAT 
B) MODIFY 
C) DESIGN 
D) PAGE SETUP 
A) FORMAT 
B) MODIFY 
C) DESIGN 
D) PAGE SETUP

Question 10

A form created from more than one table uses the primary table for the main form.  ____________________

Accepted Answer

A) True 
 B)False

Question 11

Match between columns
                        Premises: The feature used to distinguish one record from another in a form.

Accepted Answer

The Answer of Themes and Design view and Find and is...

Question 12

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

Accepted Answer

A) Changing page orientation 
B) Changing the report name 
C) Adding conditional formatting 
D) Changing font colors 
A) Changing page orientation 
B) Changing the report name 
C) Adding conditional formatting 
D) Changing font colors

Question 13

Field values edited in Form view are also changed in the form's underlying table. ____________________

Accepted Answer

A) True 
 B)False

Question 14

A form's object name appears on the tab for the form in the Access window.  ____________________

Accepted Answer

A) True 
 B)False

Question 15

Query elements may be added to a form to improve its appearance or add visual appeal.___________________

Accepted Answer

A) True 
 B)False

Question 16

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

Accepted Answer

A) $?$ 
B) * 
C) - 
D) # 
A) $?$ 
B) * 
C) - 
D) #

Question 17

Briefly explain options available for applying a theme to a form or report and other database objects.

Accepted Answer

Themes may be applied to all m

Question 18

Access allows all pages, a range of pages, or a currently selected record to be printed from Form view. ____________________

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: Indicates editing mode.

Accepted Answer

The Answer of Layout view and Design view and  is...

Question 20

Match between columns
                        Premises: The button used to change the theme of a form from the default theme to another theme in Layout view.

Accepted Answer

The Answer of Report Wizard and Design view and Layout is...

Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.

Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.

The Report Wizard allows detail records to be sorted by up to four fields. ____________________

Print All, Pages, and Selected Record(s)are options available from the ____ for printing forms.

To generate a report with exact results based on specific criteria it is best to base the report on a(n)____________________ created in the database.

Report fields and field value boxes may be repositioned while viewing the report in Layout view. ____________________

Options for modifying the format of report objects are found on the ____ tab in Layout view when the contextual REPORT LAYOUT TOOLS tab is available.

A form created from more than one table uses the primary table for the main form. ____________________

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

Field values edited in Form view are also changed in the form's underlying table. ____________________

A form's object name appears on the tab for the form in the Access window. ____________________

Query elements may be added to a form to improve its appearance or add visual appeal.___________________

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

Briefly explain options available for applying a theme to a form or report and other database objects.

Access allows all pages, a range of pages, or a currently selected record to be printed from Form view. ____________________

Access-Module 1: 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 Forms

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

Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.

Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.

The Report Wizard allows detail records to be sorted by up to four fields. ____________________

Print All, Pages, and Selected Record(s)are options available from the ____ for printing forms.

To generate a report with exact results based on specific criteria it is best to base the report on a(n)____________________ created in the database.

Report fields and field value boxes may be repositioned while viewing the report in Layout view. ____________________

Options for modifying the format of report objects are found on the ____ tab in Layout view when the contextual REPORT LAYOUT TOOLS tab is available.

A form created from more than one table uses the primary table for the main form. ____________________

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

Field values edited in Form view are also changed in the form's underlying table. ____________________

A form's object name appears on the tab for the form in the Access window. ____________________

Query elements may be added to a form to improve its appearance or add visual appeal.___________________

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

Briefly explain options available for applying a theme to a form or report and other database objects.

Access allows all pages, a range of pages, or a currently selected record to be printed from Form view. ____________________

Access-Module 1: 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 Forms

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