Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Referencing the image above,this form contains a:

Accepted Answer

A)  miniform. 
B)  subform. 
C)  macroform. 
D)  split form. 
A)  miniform. 
B)  subform. 
C)  macroform. 
D)  split form.

Question 3

To sort fields in a report,click Group & Sort in the:

Accepted Answer

A)  Fields group on the DESIGN tab. 
B)  Grouping & Totals group on the DESIGN tab. 
C)  Fields group on the CREATE tab. 
D)  Grouping & Totals group on the CREATE tab. 
A)  Fields group on the DESIGN tab. 
B)  Grouping & Totals group on the DESIGN tab. 
C)  Fields group on the CREATE tab. 
D)  Grouping & Totals group on the CREATE tab.

Question 4

You can use the ________ allows to make changes to the layout while you are viewing the data on the form.

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 5

Which of the following statements accurately describes a split form?

Accepted Answer

A)  Split forms combine two different views of two different record sources 
B)  A Split form is a type of subform 
C)  You cannot edit records in a Split form 
D)  Split forms combine two different views of the same record source 
A)  Split forms combine two different views of two different record sources 
B)  A Split form is a type of subform 
C)  You cannot edit records in a Split form 
D)  Split forms combine two different views of the same record source

Question 6

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 7

A(n)________ is a defined set of colors,fonts,and graphics that can enhance the appearance of the a form or report by giving a uniform appearance.

Accepted Answer

The answer of A(n)________ is a defined set of colors,fonts,and...

Question 8

When viewing a report in Layout view,you see that the records are displayed in order based on the primary key field.You prefer print the records in alphabetical order by last names and then by first names.Explain how to sort the report to display records using the last name and first name fields.

Accepted Answer

To sort by names,click Group & Sort in t

Question 9

When modifying a report,the ________ tab is used to change the layout of a report.

Accepted Answer

The answer of When modifying a report,the ________ tab is...

Question 10

A theme can be applied to a single form or to all the forms in a database.

Accepted Answer

A) True 
 B)False

Question 11

A ________ is a replica of a table or query's Datasheet view that maintains some form properties although the form is limited in design and control options?

Accepted Answer

A)  multiple Items form 
B)  subform 
C)  split form 
D)  datasheet form 
A)  multiple Items form 
B)  subform 
C)  split form 
D)  datasheet form

Question 12

________ view is useful for testing the functionality of the form and adjusting sizes of fields as needed.

Accepted Answer

The answer of ________ view is useful for testing the...

Question 13

Which form view would be used to perform advanced layout adjustments?

Accepted Answer

A)  Design 
B)  Layout 
C)  Form 
D)  Detail 
A)  Design 
B)  Layout 
C)  Form 
D)  Detail

Question 14

You have been working in a database.Your boss asks you to design and print out a report for an upcoming board meeting.What view should you use to ensure that the report will print out as intended?

Accepted Answer

A)  Format view 
B)  Print Preview 
C)  Design view 
D)  Report view 
A)  Format view 
B)  Print Preview 
C)  Design view 
D)  Report view

Question 15

To create a form,you click Form in the Forms group on the ________ tab.

Accepted Answer

The answer of To create a form,you click Form in...

Question 16

Design view displays a form's data and layout.

Accepted Answer

A) True 
 B)False

Question 17

Text boxes,buttons,and boxes are examples of ________,which can be used to add,edit,and display data in a form or report.

Accepted Answer

A)  placeholders 
B)  controls 
C)  containers 
D)  records 
A)  placeholders 
B)  controls 
C)  containers 
D)  records

Question 18

The ________ view is used to add,edit,and delete data in a form,but it cannot be used to change the layout and design of the form.

Accepted Answer

A)  Insert 
B)  Edit 
C)  Modify 
D)  Form 
A)  Insert 
B)  Edit 
C)  Modify 
D)  Form

Question 19

A report is a document used to distribute meaningful information in printed form,on a computer screen,or saved to a file.

Accepted Answer

A) True 
 B)False

Question 20

A theme can be applied to a report in either Layout or Report views.

Accepted Answer

A) True 
 B)False

Exam 16: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Referencing the image above,this form contains a:

To sort fields in a report,click Group & Sort in the:

You can use the ________ allows to make changes to the layout while you are viewing the data on the form.

Which of the following statements accurately describes a split form?

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

A(n)________ is a defined set of colors,fonts,and graphics that can enhance the appearance of the a form or report by giving a uniform appearance.

When viewing a report in Layout view,you see that the records are displayed in order based on the primary key field.You prefer print the records in alphabetical order by last names and then by first names.Explain how to sort the report to display records using the last name and first name fields.

When modifying a report,the ________ tab is used to change the layout of a report.

A theme can be applied to a single form or to all the forms in a database.

A ________ is a replica of a table or query's Datasheet view that maintains some form properties although the form is limited in design and control options?

________ view is useful for testing the functionality of the form and adjusting sizes of fields as needed.

Which form view would be used to perform advanced layout adjustments?

You have been working in a database.Your boss asks you to design and print out a report for an upcoming board meeting.What view should you use to ensure that the report will print out as intended?

To create a form,you click Form in the Forms group on the ________ tab.

Design view displays a form's data and layout.

Text boxes,buttons,and boxes are examples of ________,which can be used to add,edit,and display data in a form or report.

The ________ view is used to add,edit,and delete data in a form,but it cannot be used to change the layout and design of the form.

A report is a document used to distribute meaningful information in printed form,on a computer screen,or saved to a file.

A theme can be applied to a report in either Layout or Report views.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters