Question 1

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

Themes gallery

Question 2

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

Accepted Answer

The Answer of Find and $?$ and Themes and control is...

Question 3

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 C

Question 4

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control. ____________________

Accepted Answer

A) True 
 B)False

Question 5

To resize an image without changing its proportions, simply drag  ____ of the image.

Accepted Answer

A) the left side 
B) the top 
C) any corner 
D) the bottom 
A) the left side 
B) the top 
C) any corner 
D) the bottom

Question 6

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 7

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 8

A placeholder used in a value search when only part of a value is known is called a ____________________ character.

Accepted Answer

The answer of A placeholder used in a value search...

Question 9

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 10

When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option. ____________________

Accepted Answer

A) True 
 B)False

Question 11

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table.  
____________________

Accepted Answer

A) True 
 B)False

Question 12

The ____ is located to the right of the navigation buttons and is used to locate a specific record in a form.

Accepted Answer

A) Record number 
B) Search box 
C) Find box 
D) Locate box 
A) Record number 
B) Search box 
C) Find box 
D) Locate box

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 16

When a form is created based on two or more tables, a relationship must be defined between queries . ____________________

Accepted Answer

A) True 
 B)False

Question 17

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 18

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 19

Layout view shows both the form and its data while allowing the form to be modified.  ____________________

Accepted Answer

A) True 
 B)False

Question 20

To print two records from a form, select the ____ option in the Print dialog box.

Accepted Answer

A) Selected Page(s) 
B) Current Page 
C) Range 
D) Selected Record(s) 
A) Selected Page(s) 
B) Current Page 
C) Range 
D) Selected Record(s)

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

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

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control. ____________________

To resize an image without changing its proportions, simply drag ____ of the image.

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

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

A placeholder used in a value search when only part of a value is known is called a ____________________ character.

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

When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option. ____________________

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table. ____________________

The ____ is located to the right of the navigation buttons and is used to locate a specific record in a form.

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

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

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

When a form is created based on two or more tables, a relationship must be defined between queries . ____________________

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

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

Layout view shows both the form and its data while allowing the form to be modified. ____________________

To print two records from a form, select the ____ option in the Print dialog box.

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

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

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

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control. ____________________

To resize an image without changing its proportions, simply drag ____ of the image.

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

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

A placeholder used in a value search when only part of a value is known is called a ____________________ character.

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

When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option. ____________________

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table. ____________________

The ____ is located to the right of the navigation buttons and is used to locate a specific record in a form.

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

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

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

When a form is created based on two or more tables, a relationship must be defined between queries . ____________________

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

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

Layout view shows both the form and its data while allowing the form to be modified. ____________________

To print two records from a form, select the ____ option in the Print dialog box.

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