Question 1

When you enter data in a form,it is stored in the form and not the table.

Accepted Answer

A) True 
 B)False

Question 2

Design view shows all the records and fields at one time,which is one advantage to using it to update your records.

Accepted Answer

A) True 
 B)False

Question 3

A(n)________ is a built-in combination of colors and fonts.

Accepted Answer

The answer of A(n)________ is a built-in combination of colors...

Question 4

The correct terminology for saving a report as a PDF file format is to ________ the report.

Accepted Answer

The answer of The correct terminology for saving a report...

Question 5

When you create a form from two tables that have a one-to-many relationship,the first table selected becomes the main form and the second table you select becomes the ________.

Accepted Answer

A)  joined form 
B)  co-form 
C)  split form 
D)  subform 
A)  joined form 
B)  co-form 
C)  split form 
D)  subform

Question 6

Print Preview adds the ________ to the page footer at the bottom of every page.

Accepted Answer

A)  file name 
B)  current date and page numbers 
C)  creator's name 
D)  file path 
A)  file name 
B)  current date and page numbers 
C)  creator's name 
D)  file path

Question 7

When navigating a main form,pressing ________ will move the cursor to the first field of the current record.

Accepted Answer

The answer of When navigating a main form,pressing ________ will...

Question 8

An advantage to editing data in a query is that there may be fewer records and/or fields in the datasheet making the data more manageable.

Accepted Answer

A) True 
 B)False

Question 9

A form with a(n)________ allows you to see one record at a time from the main form and multiple records in Datasheet view from the other related table.

Accepted Answer

The answer of A form with a(n)________ allows you to...

Question 10

When the Report Wizard is done creating the report,it shows you the report in Layout view.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is NOT true when changing a form theme?

Accepted Answer

A)  Once a theme is applied to the form, the colors and fonts can be changed independently of the theme, so you can combine the colors of one theme and a font of another. 
B)  Changing the theme will not only change the colors of the form but also the font type and size and any border colors or object colors added to the form. 
C)  Because the form is displayed in Form view, once it is created, the first step is to switch to Layout view to make changes to the form itself. 
D)  By default, Access uses the Office theme when you create a form using AutoForm. 
A)  Once a theme is applied to the form, the colors and fonts can be changed independently of the theme, so you can combine the colors of one theme and a font of another. 
B)  Changing the theme will not only change the colors of the form but also the font type and size and any border colors or object colors added to the form. 
C)  Because the form is displayed in Form view, once it is created, the first step is to switch to Layout view to make changes to the form itself. 
D)  By default, Access uses the Office theme when you create a form using AutoForm.

Question 12

Groups are added to a section of the report called the ________.

Accepted Answer

The answer of Groups are added to a section of...

Question 13

________ view allows you to make changes to the form while viewing the data at the same time.

Accepted Answer

The answer of ________ view allows you to make changes...

Question 14

When resizing and managing controls,the ________ allows you to move the whole table at one time.

Accepted Answer

A)  subform control 
B)  Layout Selector 
C)  control selector 
D)  Form Wizard 
A)  subform control 
B)  Layout Selector 
C)  control selector 
D)  Form Wizard

Question 15

When you create a form from two tables that have a one-to-many relationship,the first table selected becomes the subform and the second table you select becomes the main form.

Accepted Answer

A) True 
 B)False

Question 16

A subform is a form created from one table,but it has a Form view and a Datasheet view in the same window.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is NOT true regarding split forms?

Accepted Answer

A)  You can highlight a different record in the form part and the datasheet part at the same time. 
B)  You can view one record at a time at the top of the window, and see the whole table in Datasheet view at the bottom of the window. 
C)  This kind of form is helpful when you want to work with one record at a time and still see the big picture in the main table. 
D)  In a split form, there are buttons on the Navigation bar to move only from record to record, and each record shown at the top is the record highlighted in the datasheet at the same time. 
A)  You can highlight a different record in the form part and the datasheet part at the same time. 
B)  You can view one record at a time at the top of the window, and see the whole table in Datasheet view at the bottom of the window. 
C)  This kind of form is helpful when you want to work with one record at a time and still see the big picture in the main table. 
D)  In a split form, there are buttons on the Navigation bar to move only from record to record, and each record shown at the top is the record highlighted in the datasheet at the same time.

Question 18

Match between columns
                        Premises: Subform
Navigation mode
Edit mode
Split form
Main form

Accepted Answer

The Answer of Allows you to move from record to is...

Question 19

When the Report Wizard has finished creating the report,it shows you the report in ________.

Accepted Answer

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

Question 20

A(n)________ is a part of a form or report that you use to enter,edit,or display data.

Accepted Answer

The answer of A(n)________ is a part of a form...

When you enter data in a form,it is stored in the form and not the table.

Design view shows all the records and fields at one time,which is one advantage to using it to update your records.

A(n)________ is a built-in combination of colors and fonts.

The correct terminology for saving a report as a PDF file format is to ________ the report.

When you create a form from two tables that have a one-to-many relationship,the first table selected becomes the main form and the second table you select becomes the ________.

Print Preview adds the ________ to the page footer at the bottom of every page.

When navigating a main form,pressing ________ will move the cursor to the first field of the current record.

An advantage to editing data in a query is that there may be fewer records and/or fields in the datasheet making the data more manageable.

A form with a(n)________ allows you to see one record at a time from the main form and multiple records in Datasheet view from the other related table.

When the Report Wizard is done creating the report,it shows you the report in Layout view.

Which of the following is NOT true when changing a form theme?

Groups are added to a section of the report called the ________.

________ view allows you to make changes to the form while viewing the data at the same time.

When resizing and managing controls,the ________ allows you to move the whole table at one time.

When you create a form from two tables that have a one-to-many relationship,the first table selected becomes the subform and the second table you select becomes the main form.

A subform is a form created from one table,but it has a Form view and a Datasheet view in the same window.

Which of the following is NOT true regarding split forms?

When the Report Wizard has finished creating the report,it shows you the report in ________.

A(n)________ is a part of a form or report that you use to enter,edit,or display data.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters

Exam 14: Using Forms and Reports in Access

When you enter data in a form,it is stored in the form and not the table.

Design view shows all the records and fields at one time,which is one advantage to using it to update your records.

A(n)________ is a built-in combination of colors and fonts.

The correct terminology for saving a report as a PDF file format is to ________ the report.

When you create a form from two tables that have a one-to-many relationship,the first table selected becomes the main form and the second table you select becomes the ________.

Print Preview adds the ________ to the page footer at the bottom of every page.

When navigating a main form,pressing ________ will move the cursor to the first field of the current record.

An advantage to editing data in a query is that there may be fewer records and/or fields in the datasheet making the data more manageable.

A form with a(n)________ allows you to see one record at a time from the main form and multiple records in Datasheet view from the other related table.

When the Report Wizard is done creating the report,it shows you the report in Layout view.

Which of the following is NOT true when changing a form theme?

Groups are added to a section of the report called the ________.

________ view allows you to make changes to the form while viewing the data at the same time.

When resizing and managing controls,the ________ allows you to move the whole table at one time.

When you create a form from two tables that have a one-to-many relationship,the first table selected becomes the subform and the second table you select becomes the main form.

A subform is a form created from one table,but it has a Form view and a Datasheet view in the same window.

Which of the following is NOT true regarding split forms?

When the Report Wizard has finished creating the report,it shows you the report in ________.

A(n)________ is a part of a form or report that you use to enter,edit,or display data.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters