Question 1

Which form tools creates a box asking for user input?

Accepted Answer

A) Modal Dialog 
B) Datasheet 
C) Navigation 
D) Form Wizard 
A) Modal Dialog 
B) Datasheet 
C) Navigation 
D) Form Wizard

Question 2

Match between columns
                        Premises:  Text Contains
Duplicate Values
Unique Values
Equal To
 Clear Format

Accepted Answer

The Answer of Formats cells that have exactly the same is...

Question 3

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 4

When you make changes to data in a form, the data in the underlying ________ are affected.

Accepted Answer

The answer of When you make changes to data in...

Question 5

Match the following terms with their description:
I. Label Wizard
II. Form Wizard
III. Report Wizard
IV. SubForm Wizard
V. SubReport Wizard
A. Simplified way to create forms
B. Simplified way to create subforms
C. Simplified way to create reports
D. Used to create name tags
E. This does not exist in Access.

Accepted Answer

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

Question 6

What is a popular label producing company?

Accepted Answer

A) Easy Labels 
B) MakeIt Labels 
C) Avery 
D) Okidata 
A) Easy Labels 
B) MakeIt Labels 
C) Avery 
D) Okidata

Question 7

The first step in creating a form is to determine the record ________.

Accepted Answer

The answer of The first step in creating a form...

Question 8

A record source and a data source are not the same.

Accepted Answer

A) True 
 B)False

Question 9

Match between columns
                        Premises:  Public domain
Copyright
Codec
Narration
 Kelvin

Accepted Answer

The Answer of Uses algorithms to compress videos and then is...

Question 10

Which of the following cannot be included on a form?

Accepted Answer

A) Check box 
B) Sub report 
C) Drop-down list 
D) Button 
A) Check box 
B) Sub report 
C) Drop-down list 
D) Button

Question 11

What is not found on the Report Layout Tools Arrange tab?

Accepted Answer

A) Insert Left 
B) Insert Right 
C) Move Up 
D) Insert Existing Field 
A) Insert Left 
B) Insert Right 
C) Move Up 
D) Insert Existing Field

Question 12

What is not found on the Data Group on Print Preview tab?

Accepted Answer

A) Excel 
B) Text File 
C) Portrait 
D) Email 
A) Excel 
B) Text File 
C) Portrait 
D) Email

Question 13

Which of the following is not a report view?

Accepted Answer

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

Question 14

If you want to resize just a few controls on a form they must be removed from the Layout control.

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises:  Multimedia
Bitmap
Vector graphic
Lossy
 Lossless

Accepted Answer

The Answer of Image created by created by mathematical statements is...

Question 16

Which of the following is not recommended as a professional way of styling a form?

Accepted Answer

A) Use several fonts to indicate different types of data 
B) Left-align the text boxes 
C) Separate the primary key from the rest of the form 
D) Right-align the labels 
A) Use several fonts to indicate different types of data 
B) Left-align the text boxes 
C) Separate the primary key from the rest of the form 
D) Right-align the labels

Question 17

Click ________ & Sort to add sorting to a report.

Accepted Answer

The answer of Click ________ & Sort to add sorting...

Question 18

Match between columns
                        Premises:  Endnote
Footnote
Table of contents
Index
 Cover page

Accepted Answer

The Answer of List of headings and page numbers in is...

Question 19

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 20

In Office 2016, Access provides how many tools for creating forms?

Accepted Answer

A) 6 
B) 8 
C) 10 
D) 14 
A) 6 
B) 8 
C) 10 
D) 14

Which form tools creates a box asking for user input?

Which of the following is not a form view?

When you make changes to data in a form, the data in the underlying ________ are affected.

What is a popular label producing company?

The first step in creating a form is to determine the record ________.

A record source and a data source are not the same.

Which of the following cannot be included on a form?

What is not found on the Report Layout Tools Arrange tab?

What is not found on the Data Group on Print Preview tab?

Which of the following is not a report view?

If you want to resize just a few controls on a form they must be removed from the Layout control.

Which of the following is not recommended as a professional way of styling a form?

Click ________ & Sort to add sorting to a report.

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

In Office 2016, Access provides how many tools for creating forms?

Access: Introduction to Access

Access: Tables and Queries in Relational Databases

Access: Using Queries to Make Decisions

Excel : Introduction to Excel

Excel : Formulas and Functions

Excel : Charts

Excel : Datasets and Tables

Power Point: Creating a Basic Presentation

Power Point: Presentation Development

Power Point: Presentation Design

Power Point: Enhancing With Multimedia

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Collaboration and Research

Office 2016 Common Features

Working With an Operating System

Filters

Exam 4: Access: Creating and Using Professional Forms and Reports

Which form tools creates a box asking for user input?

Which of the following is not a form view?

When you make changes to data in a form, the data in the underlying ________ are affected.

What is a popular label producing company?

The first step in creating a form is to determine the record ________.

A record source and a data source are not the same.

Which of the following cannot be included on a form?

What is not found on the Report Layout Tools Arrange tab?

What is not found on the Data Group on Print Preview tab?

Which of the following is not a report view?

If you want to resize just a few controls on a form they must be removed from the Layout control.

Which of the following is not recommended as a professional way of styling a form?

Click ________ & Sort to add sorting to a report.

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

In Office 2016, Access provides how many tools for creating forms?

Access: Introduction to Access

Access: Tables and Queries in Relational Databases

Access: Using Queries to Make Decisions

Excel : Introduction to Excel

Excel : Formulas and Functions

Excel : Charts

Excel : Datasets and Tables

Power Point: Creating a Basic Presentation

Power Point: Presentation Development

Power Point: Presentation Design

Power Point: Enhancing With Multimedia

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Collaboration and Research

Office 2016 Common Features

Working With an Operating System

Filters