Question 1

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 2

Design changes cannot be made to a form in Form view . ____________________

Accepted Answer

A) True 
 B)False

Question 3

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 4

Match between columns
                        Premises: A report must be in Design view or this view to apply conditional formatting.

Accepted Answer

The Answer of # and (?) and Report Wizard and is...

Question 5

To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.

Accepted Answer

A)  HOME 
B)  CREATE 
C)  FILE 
D)  EDIT 
A)  HOME 
B)  CREATE 
C)  FILE 
D)  EDIT

Question 6

A button with the subform's name on it appears on the main form when the ____________________ option is chosen in the Form Wizard.

Accepted Answer

The answer of A button with the subform's name on...

Question 7

Case-Based Critical Thinking Questions Case 4-1
Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling.  The tables in the database and the fields for each table are illustrated in the figure below.
 
Sergio would like to create a form for Carmen to use to enter information about the participants.  Which table should Sergio use to create the form?

Accepted Answer

A) ParticipantInformation 
B) ParticipantAccount 
C) RequestedResources 
D)  Location 
A) ParticipantInformation 
B) ParticipantAccount 
C) RequestedResources 
D)  Location

Question 8

In the accompanying figure, arrow number 1 identifies the button which indicates the form is displayed in ____ view.

Accepted Answer

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

Question 9

In the accompanying figure, the fields indicated by the green brackets are fields to be included in the ____.

Accepted Answer

A)  subform 
B)  main form 
C)  related table 
D)  primary table 
A)  subform 
B)  main form 
C)  related table 
D)  primary table

Question 10

The most detailed view of a form's structure is available the Layout view. ____________________

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 Report Wizard and (?) and # and is...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

In the accompanying figure, the icons and titles shown in bracket number 2 represent the ____ Access database object.

Accepted Answer

A)  Form 
B)  Query 
C)  Report 
D)  Table 
A)  Form 
B)  Query 
C)  Report 
D)  Table

Question 14

When using the Report Wizard, the report title entered in the Wizard is also the name of the report ____________________.

Accepted Answer

The answer of When using the Report Wizard, the report...

Question 15

Case-Based Critical Thinking Questions Case 4-1
Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling.  The tables in the database and the fields for each table are illustrated in the figure below.
 
After reviewing the form Sergio decides he wants to create a form that will allow Carmen to enter both the participant information and the amount due by the participant.  Sergio will need to use two tables to accomplish this.  The second table will be the ___ in the form.

Accepted Answer

A)  subform 
B)  primary form 
C)  main form 
D)  subdatasheet 
A)  subform 
B)  primary form 
C)  main form 
D)  subdatasheet

Question 16

In the accompanying figure, which numbered arrow indicates the button that moves the Form Wizard to the second dialog box where a form layout may be chosen.

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 17

In the accompanying figure, which Access database object is represented by the icons and titles shown in bracket number 4?

Accepted Answer

A)  Tables 
B)  Queries 
C)  Reports 
D)  Forms 
A)  Tables 
B)  Queries 
C)  Reports 
D)  Forms

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: The wildcard character used to match any single alphabetic character.

Accepted Answer

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

Question 20

Case-Based Critical Thinking Questions Case 4-1
Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling.  The tables in the database and the fields for each table are illustrated in the figure below.
 
The Facet theme is currently the theme for the form Sergio has created. He wants to change the theme to the Slice theme and apply the Slice theme to all of the database objects.  To apply the new theme, Sergio must be in the ____ or Design view.

Accepted Answer

A)  Create 
B)  Arrange 
C)  Format 
D)  Layout 
A)  Create 
B)  Arrange 
C)  Format 
D)  Layout

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

Design changes cannot be made to a form in Form view . ____________________

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

To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.

A button with the subform's name on it appears on the main form when the ____________________ option is chosen in the Form Wizard.

In the accompanying figure, arrow number 1 identifies the button which indicates the form is displayed in ____ view.

In the accompanying figure, the fields indicated by the green brackets are fields to be included in the ____.

The most detailed view of a form's structure is available the Layout view. ____________________

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

In the accompanying figure, the icons and titles shown in bracket number 2 represent the ____ Access database object.

When using the Report Wizard, the report title entered in the Wizard is also the name of the report ____________________.

In the accompanying figure, which numbered arrow indicates the button that moves the Form Wizard to the second dialog box where a form layout may be chosen.

In the accompanying figure, which Access database object is represented by the icons and titles shown in bracket number 4?

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

Managing Your Files

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 Sharing a Database

Filters

Exam 5: Creating Forms and Reports

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

Design changes cannot be made to a form in Form view . ____________________

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

To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.

A button with the subform's name on it appears on the main form when the ____________________ option is chosen in the Form Wizard.

In the accompanying figure, arrow number 1 identifies the button which indicates the form is displayed in ____ view.

In the accompanying figure, the fields indicated by the green brackets are fields to be included in the ____.

The most detailed view of a form's structure is available the Layout view. ____________________

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

In the accompanying figure, the icons and titles shown in bracket number 2 represent the ____ Access database object.

When using the Report Wizard, the report title entered in the Wizard is also the name of the report ____________________.

In the accompanying figure, which numbered arrow indicates the button that moves the Form Wizard to the second dialog box where a form layout may be chosen.

In the accompanying figure, which Access database object is represented by the icons and titles shown in bracket number 4?

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

Managing Your Files

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 Sharing a Database

Filters