Question 1

Each object you place on a form is called a(n) ________.

Accepted Answer

A)  index 
B)  label 
C)  icon 
D)  control 
A)  index 
B)  label 
C)  icon 
D)  control

Question 2

Gina is working in a database that stores employee data. Gina's boss wants her to design a form that will make a data entry easier. Her boss wants her to include the company name and logo on the form. Gina can add this information to the Form ________ section.

Accepted Answer

The answer of Gina is working in a database that...

Question 3

-Referencing the image above, what number represents the section where data from a record source would appear in the report?

Accepted Answer

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

Question 4

You need to create a report from an Access database containing sales figures. You want the report to include a final grand total and page numbers. Which of the following statements accurately defines what you must do in order to achieve these results?

Accepted Answer

A)  Page numbers would included on the page footer section and the grand total would be included on the report footer section. 
B)  Page numbers would be included on the group header section and the grand total would be included on the group footer section. 
C)  Page numbers would included on the report footer section and the grand total would be included on the page footer section. 
D)  Page numbers would included on the report header section and the grand total would be included on the report footer section. 
A)  Page numbers would included on the page footer section and the grand total would be included on the report footer section. 
B)  Page numbers would be included on the group header section and the grand total would be included on the group footer section. 
C)  Page numbers would included on the report footer section and the grand total would be included on the page footer section. 
D)  Page numbers would included on the report header section and the grand total would be included on the report footer section.

Question 5

Forms cannot show data from more than one table.

Accepted Answer

A) True 
 B)False

Question 6

A report provides a professional, printed format of information contained in a database.

Accepted Answer

A) True 
 B)False

Question 7

Jill must create a report for an Access database, but is unfamiliar with creating reports in Access. Which Report tool should Jill use?

Accepted Answer

A)  Report Blank 
B)  Report Wizard 
C)  Report 
D)  Report Design 
A)  Report Blank 
B)  Report Wizard 
C)  Report 
D)  Report Design

Question 8

When you need to alter a report's appearance but do not need to see or edit underlying data, you can use ________ view.

Accepted Answer

The answer of When you need to alter a report's...

Question 9

Access can be used to create forms that match paper forms.

Accepted Answer

A) True 
 B)False

Question 10

Labels and Text Boxes are known as controls.

Accepted Answer

A) True 
 B)False

Question 11

The ________ displays form fields in vertical column, and displays one record at a time.

Accepted Answer

A)  Stacked Layout 
B)  Layout View 
C)  Tabular Layout 
D)  Print Preview 
A)  Stacked Layout 
B)  Layout View 
C)  Tabular Layout 
D)  Print Preview

Question 12

The form Layout view can be used for all of the following EXCEPT

Accepted Answer

A)  adding or removing a field. 
B)  changing the order of fields. 
C)  adding a calculated field. 
D)  changing the width of a field. 
A)  adding or removing a field. 
B)  changing the order of fields. 
C)  adding a calculated field. 
D)  changing the width of a field.

Question 13

A form can be customized to add additional functionality using, ________, Microsoft's programming language that is built into all of the Office products.

Accepted Answer

Visual Bas

Question 14

All of the following are Form views EXCEPT:

Accepted Answer

A)  Tabular View 
B)  Layout View 
C)  Form View 
D)  Design View 
A)  Tabular View 
B)  Layout View 
C)  Form View 
D)  Design View

Question 15

A(n) ________ is an unbound control that displays text.

Accepted Answer

A)  label 
B)  roster 
C)  index 
D)  listing 
A)  label 
B)  roster 
C)  index 
D)  listing

Question 16

A(n) ________ form combines two views of the same record source, displaying one section in a stacked layout and the other in a tabular layout.

Accepted Answer

The answer of A(n) ________ form combines two views of...

Question 17

A report containing more than one page should have page numbers included in the ________ section.

Accepted Answer

The answer of A report containing more than one page...

Question 18

Which of the following statements is true in reference to comparing the sections in Access forms and the sections in Access reports?

Accepted Answer

A)  Forms have more sections than reports, and working with report sections is much different from working with form sections. 
B)  Reports have more sections than forms, but working with report sections is similar to working with form sections. 
C)  Forms have the same number of sections as reports, and working with report sections is similar to working with form sections. 
D)  Forms have the same number of sections as reports, but working with report sections is much different from working with form sections. 
A)  Forms have more sections than reports, and working with report sections is much different from working with form sections. 
B)  Reports have more sections than forms, but working with report sections is similar to working with form sections. 
C)  Forms have the same number of sections as reports, and working with report sections is similar to working with form sections. 
D)  Forms have the same number of sections as reports, but working with report sections is much different from working with form sections.

Question 19

Freddie is working on a database that stores inventory information. His boss has asked him to print a report for review by auditors. Freddie wants to make sure the report prints correctly. He should view the report using ________ before printing the report.

Accepted Answer

The answer of Freddie is working on a database that...

Question 20

Form view cannot be used to change the layout or design of a form.

Accepted Answer

A) True 
 B)False

Each object you place on a form is called a(n) ________.

Gina is working in a database that stores employee data. Gina's boss wants her to design a form that will make a data entry easier. Her boss wants her to include the company name and logo on the form. Gina can add this information to the Form ________ section.

-Referencing the image above, what number represents the section where data from a record source would appear in the report?

You need to create a report from an Access database containing sales figures. You want the report to include a final grand total and page numbers. Which of the following statements accurately defines what you must do in order to achieve these results?

Forms cannot show data from more than one table.

A report provides a professional, printed format of information contained in a database.

Jill must create a report for an Access database, but is unfamiliar with creating reports in Access. Which Report tool should Jill use?

When you need to alter a report's appearance but do not need to see or edit underlying data, you can use ________ view.

Access can be used to create forms that match paper forms.

Labels and Text Boxes are known as controls.

The ________ displays form fields in vertical column, and displays one record at a time.

The form Layout view can be used for all of the following EXCEPT

A form can be customized to add additional functionality using, ________, Microsoft's programming language that is built into all of the Office products.

All of the following are Form views EXCEPT:

A(n) ________ is an unbound control that displays text.

A(n) ________ form combines two views of the same record source, displaying one section in a stacked layout and the other in a tabular layout.

A report containing more than one page should have page numbers included in the ________ section.

Which of the following statements is true in reference to comparing the sections in Access forms and the sections in Access reports?

Freddie is working on a database that stores inventory information. His boss has asked him to print a report for review by auditors. Freddie wants to make sure the report prints correctly. He should view the report using ________ before printing the report.

Form view cannot be used to change the layout or design of a form.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Filters

Exam 18: Access: Powerpoint Rich Media Tools

Each object you place on a form is called a(n) ________.

Gina is working in a database that stores employee data. Gina's boss wants her to design a form that will make a data entry easier. Her boss wants her to include the company name and logo on the form. Gina can add this information to the Form ________ section.

-Referencing the image above, what number represents the section where data from a record source would appear in the report?

You need to create a report from an Access database containing sales figures. You want the report to include a final grand total and page numbers. Which of the following statements accurately defines what you must do in order to achieve these results?

Forms cannot show data from more than one table.

A report provides a professional, printed format of information contained in a database.

Jill must create a report for an Access database, but is unfamiliar with creating reports in Access. Which Report tool should Jill use?

When you need to alter a report's appearance but do not need to see or edit underlying data, you can use ________ view.

Access can be used to create forms that match paper forms.

Labels and Text Boxes are known as controls.

The ________ displays form fields in vertical column, and displays one record at a time.

The form Layout view can be used for all of the following EXCEPT

A form can be customized to add additional functionality using, ________, Microsoft's programming language that is built into all of the Office products.

All of the following are Form views EXCEPT:

A(n) ________ is an unbound control that displays text.

A(n) ________ form combines two views of the same record source, displaying one section in a stacked layout and the other in a tabular layout.

A report containing more than one page should have page numbers included in the ________ section.

Which of the following statements is true in reference to comparing the sections in Access forms and the sections in Access reports?

Freddie is working on a database that stores inventory information. His boss has asked him to print a report for review by auditors. Freddie wants to make sure the report prints correctly. He should view the report using ________ before printing the report.

Form view cannot be used to change the layout or design of a form.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Filters