Question 1

What is not true about Navigation forms?

Accepted Answer

A) Can give the look and feel of web-based forms 
B) Allows the quick navigation between objects in the database 
C) Simplifies navigation for data-entry people 
D) It is not designed to be changed after it is set up 
A) Can give the look and feel of web-based forms 
B) Allows the quick navigation between objects in the database 
C) Simplifies navigation for data-entry people 
D) It is not designed to be changed after it is set up

Question 2

Which of the following is not a primary consideration when designing a report?

Accepted Answer

A) The purpose of the report 
B) Who will use the report 
C) What information will be needed in the report 
D) How many pages long the report will be 
A) The purpose of the report 
B) Who will use the report 
C) What information will be needed in the report 
D) How many pages long the report will be

Question 3

What cannot be used as a record source?

Accepted Answer

A) A report 
B) Table 
C) Query 
D) Multitable query 
A) A report 
B) Table 
C) Query 
D) Multitable query

Question 4

When running a report,which sort order takes precedence?

Accepted Answer

A) Underlying table 
B) Report 
C) Underlying query 
D) Underlying form 
A) Underlying table 
B) Report 
C) Underlying query 
D) Underlying form

Question 5

________ & Sort is used to add sorting to a report.

Accepted Answer

The answer of ________ & Sort is used to add...

Question 6

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 7

Match between columns
                        Premises: Tabular layout
Form
Record source
Stacked layout
Application Parts

Accepted Answer

The Answer of Fields are displayed in horizontal columns and is...

Question 8

The Form ________ tool enables you to create a form by answering a series of questions.

Accepted Answer

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

Question 9

A Split form shows two records at one time instead of the one record which is normally displayed in a form.

Accepted Answer

A) True 
 B)False

Question 10

What is not true about a split form?

Accepted Answer

A) You can pick one record for the top and a different record for the bottom 
B) Combines two views of the same record 
C) Top section uses a stacked layout 
D) Bottom section uses a tabular layout 
A) You can pick one record for the top and a different record for the bottom 
B) Combines two views of the same record 
C) Top section uses a stacked layout 
D) Bottom section uses a tabular layout

Question 11

________ will allow you to see what a report will look like before it is printed.

Accepted Answer

The answer of ________ will allow you to see what...

Question 12

Sketching out a form's layout on paper is often a helpful first step in designing an Access form.

Accepted Answer

A) True 
 B)False

Question 13

What can you not easily do using a form?

Accepted Answer

A) Enter data 
B) Edit data 
C) Move data 
D) Delete data 
A) Enter data 
B) Edit data 
C) Move data 
D) Delete data

Question 14

The ________ tool enables you to create a form using a tabular layout.

Accepted Answer

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

Question 15

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 16

A record source and a data source are synonymous.

Accepted Answer

A) True 
 B)False

Question 17

Mailing labels are considered reports in Access 2019.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is not considered one of the most common methods to create a form?

Accepted Answer

A) Default Form 
B) Form Wizard 
C) Blank Form 
D) Form Design 
A) Default Form 
B) Form Wizard 
C) Blank Form 
D) Form Design

Question 19

Good forms need to balance efficiency with a user-friendly interface.

Accepted Answer

A) True 
 B)False

Question 20

Navigation forms enable users to quickly navigate between the objects of a database.

Accepted Answer

A) True 
 B)False

What is not true about Navigation forms?

Which of the following is not a primary consideration when designing a report?

What cannot be used as a record source?

When running a report,which sort order takes precedence?

________ & Sort is used to add sorting to a report.

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

The Form ________ tool enables you to create a form by answering a series of questions.

A Split form shows two records at one time instead of the one record which is normally displayed in a form.

What is not true about a split form?

________ will allow you to see what a report will look like before it is printed.

Sketching out a form's layout on paper is often a helpful first step in designing an Access form.

What can you not easily do using a form?

The ________ tool enables you to create a form using a tabular layout.

Which of the following is not a form view?

A record source and a data source are synonymous.

Mailing labels are considered reports in Access 2019.

Which of the following is not considered one of the most common methods to create a form?

Good forms need to balance efficiency with a user-friendly interface.

Navigation forms enable users to quickly navigate between the objects of a database.

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

What is not true about Navigation forms?

Which of the following is not a primary consideration when designing a report?

What cannot be used as a record source?

When running a report,which sort order takes precedence?

________ & Sort is used to add sorting to a report.

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

The Form ________ tool enables you to create a form by answering a series of questions.

A Split form shows two records at one time instead of the one record which is normally displayed in a form.

What is not true about a split form?

________ will allow you to see what a report will look like before it is printed.

Sketching out a form's layout on paper is often a helpful first step in designing an Access form.

What can you not easily do using a form?

The ________ tool enables you to create a form using a tabular layout.

Which of the following is not a form view?

A record source and a data source are synonymous.

Mailing labels are considered reports in Access 2019.

Which of the following is not considered one of the most common methods to create a form?

Good forms need to balance efficiency with a user-friendly interface.

Navigation forms enable users to quickly navigate between the objects of a database.

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