Question 1

The most common method of finding information in a database is through the use of a(n) ________.

Accepted Answer

form

Question 2

A multiple items form shows more than one record at one time instead of the one record which is normally displayed in a form.

Accepted Answer

A) True 
 B)False  True

Question 3

Match the following terms with their description:
I. Split form
II. Multiple items form
III. Property sheet
IV. Sub form
V. Dual Record form
A. Controls the behavior of the form
B. Displays related records
C. Two views of the same record source
D. Not available in Access
E. More than one record is displayed.

Accepted Answer

C, E, A, B, D

Question 4

If you want more freedom as to where your controls are located on a form you need to remove the ________ control.

Accepted Answer

The answer of If you want more freedom as to...

Question 5

Match the following terms with their description:
I. Subform
II. Subreport
III. Subquery
IV. Datasheet format
V. SubForm Wizard
A. Provides an easy way to add a subform to form
B. This does not exist in Access.
C. Displays data in a grid like Excel
D. Displays related record on a form
E. Displays related records on a report

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 6

Most reports do not use the ________ layout because it makes the report longer than the alternative.

Accepted Answer

The answer of Most reports do not use the ________...

Question 7

The ________ Form tool enables you to create a form in Layout view.

Accepted Answer

The answer of The ________ Form tool enables you to...

Question 8

Which of the following is not a form tool that is available in Access 2019?

Accepted Answer

A)  Form 
B)  Multiple Form 
C)  Form Design 
D)  Split Form 
A)  Form 
B)  Multiple Form 
C)  Form Design 
D)  Split Form

Question 9

A(n) ________ is an Access object that outputs data in a meaningful way to those who view them.

Accepted Answer

The answer of A(n) ________ is an Access object that...

Question 10

Which of the following is not true of a form?

Accepted Answer

A)  It is the most common method of entering data. 
B)  It can be sorted independently of its data source. 
C)  It can contain background images. 
D)  It can only display one record at a time. 
A)  It is the most common method of entering data. 
B)  It can be sorted independently of its data source. 
C)  It can contain background images. 
D)  It can only display one record at a time.

Question 11

Which of the following is not a form view?

Accepted Answer

A)  Form view 
B)  Design view 
C)  Layout view 
D)  SQL view 
A)  Form view 
B)  Design view 
C)  Layout view 
D)  SQL view

Question 12

Normally when you Print Preview a report it will generate a report with how many pages?

Accepted Answer

A)  Only the first page 
B)  Only the first two pages 
C)  All the pages only if they will all fit on the screen at one time 
D)  All the pages 
A)  Only the first page 
B)  Only the first two pages 
C)  All the pages only if they will all fit on the screen at one time 
D)  All the pages

Question 13

The ________ tool enables you to create a user-interface which works on the Internet.

Accepted Answer

The answer of The ________ tool enables you to create...

Question 14

If you want to sort a form on multiple fields then you would use a(n) ________ as your record source and not the table.

Accepted Answer

The answer of If you want to sort a form...

Question 15

The Form ________ tool enables you to create a form in design view.

Accepted Answer

The answer of The Form ________ tool enables you to...

Question 16

The ________ control helps you keep your form looking neat and professional by keeping the other controls aligned properly.

Accepted Answer

The answer of The ________ control helps you keep your...

Question 17

What is not true about the Form Design view?

Accepted Answer

A)  Gives access to advanced design settings 
B)  Gives more control over form design 
C)  It allows you to see live data while you edit the form. 
D)  Allows you to remove layout controls from a form 
A)  Gives access to advanced design settings 
B)  Gives more control over form design 
C)  It allows you to see live data while you edit the form. 
D)  Allows you to remove layout controls from a form

Question 18

One advantage to using a form is that you can display data from more than one table at the same time.

Accepted Answer

A) True 
 B)False

Question 19

If a field is found in a query then it must be included in any report based on that query. If you do not want the field displayed, you can set its view property to hidden.

Accepted Answer

A) True 
 B)False

Question 20

Match the following terms with their description:
I. Form
II. Application Parts
III. Record source
IV. Stacked layout
V. Tabular layout
A. Used to build database objects
B. Fields are displayed in a vertical column
C. Fields are displayed in horizontal columns
D. A user-friendly interface
E. Supplies the records for a form or report

Accepted Answer

The answer of Match the following terms with their description:
I....

The most common method of finding information in a database is through the use of a(n) ________.

A multiple items form shows more than one record at one time instead of the one record which is normally displayed in a form.

If you want more freedom as to where your controls are located on a form you need to remove the ________ control.

Most reports do not use the ________ layout because it makes the report longer than the alternative.

The ________ Form tool enables you to create a form in Layout view.

Which of the following is not a form tool that is available in Access 2019?

A(n) ________ is an Access object that outputs data in a meaningful way to those who view them.

Which of the following is not true of a form?

Which of the following is not a form view?

Normally when you Print Preview a report it will generate a report with how many pages?

The ________ tool enables you to create a user-interface which works on the Internet.

If you want to sort a form on multiple fields then you would use a(n) ________ as your record source and not the table.

The Form ________ tool enables you to create a form in design view.

The ________ control helps you keep your form looking neat and professional by keeping the other controls aligned properly.

What is not true about the Form Design view?

One advantage to using a form is that you can display data from more than one table at the same time.

If a field is found in a query then it must be included in any report based on that query. If you do not want the field displayed, you can set its view property to hidden.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 5: Basic Forms and Reports

The most common method of finding information in a database is through the use of a(n) ________.

A multiple items form shows more than one record at one time instead of the one record which is normally displayed in a form.

If you want more freedom as to where your controls are located on a form you need to remove the ________ control.

Most reports do not use the ________ layout because it makes the report longer than the alternative.

The ________ Form tool enables you to create a form in Layout view.

Which of the following is not a form tool that is available in Access 2019?

A(n) ________ is an Access object that outputs data in a meaningful way to those who view them.

Which of the following is not true of a form?

Which of the following is not a form view?

Normally when you Print Preview a report it will generate a report with how many pages?

The ________ tool enables you to create a user-interface which works on the Internet.

If you want to sort a form on multiple fields then you would use a(n) ________ as your record source and not the table.

The Form ________ tool enables you to create a form in design view.

The ________ control helps you keep your form looking neat and professional by keeping the other controls aligned properly.

What is not true about the Form Design view?

One advantage to using a form is that you can display data from more than one table at the same time.

If a field is found in a query then it must be included in any report based on that query. If you do not want the field displayed, you can set its view property to hidden.

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters