Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

A(n)________ is an object in Access that you can use to enter,edit,or view records in a table.

Accepted Answer

The answer of A(n)________ is an object in Access that...

Question 3

A theme is a built-in combination of colors and fonts.

Accepted Answer

A) True 
 B)False

Question 4

To update data in a table,you must be in Edit mode.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of A(n)________ is a form created from one...

Question 6

________ a form can be useful if you need only one record's information,or if you want to use a form for other people to manually fill in the information.

Accepted Answer

The answer of ________ a form can be useful if...

Question 7

A control is a part of a form or report that you use to enter,edit,or display data.

Accepted Answer

A) True 
 B)False

Question 8

When the text of a field is selected and highlighted,you are in ________.

Accepted Answer

A) Edit mode 
B) Design view 
C) Datasheet mode 
D) Navigation mode 
A) Edit mode 
B) Design view 
C) Datasheet mode 
D) Navigation mode

Question 9

When you select a subform control,an orange border appears around the control and a(n)________ appears in the top-left corner.

Accepted Answer

The answer of When you select a subform control,an orange...

Question 10

When navigating a main form,pressing ________ will move the cursor from field to field within a record.

Accepted Answer

A) $$$Home$$$ 
B) $$$End$$$ 
C) $$$Tab$$$ 
D) $$$Ctrl$$$ + $$$Enter$$$ 
A) $$$Home$$$ 
B) $$$End$$$ 
C) $$$Tab$$$ 
D) $$$Ctrl$$$ + $$$Enter$$$

Question 11

________ allows you to change more details of the report design or add other controls that are only available in this view.

Accepted Answer

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

Question 12

When navigating forms with a subform,the Navigation bar buttons at the bottom of the main window are used to navigate the records in the main form,and a second Navigation bar at the bottom of the subform datasheet is used to navigate the records in the subform.

Accepted Answer

A) True 
 B)False

Question 13

When editing a main form,pressing ________ will move the cursor to the last character in the field.

Accepted Answer

A) $$$Home$$$ 
B) $$$Ctrl$$$ + $$$End$$$ 
C) $$$Enter$$$ 
D) $$$End$$$ 
A) $$$Home$$$ 
B) $$$Ctrl$$$ + $$$End$$$ 
C) $$$Enter$$$ 
D) $$$End$$$

Question 14

A(n)________ control is a control that does not have a source of data such as the title of the form.

Accepted Answer

A) unbound 
B) bound 
C) calculated 
D) text box 
A) unbound 
B) bound 
C) calculated 
D) text box

Question 15

Which of the following is NOT true about customizing a report?

Accepted Answer

A) Reports created by the wizard can be easily customized after they have been created and saved. 
B) Themes can be applied to just the report or the whole database to change the colors,fonts,or both. 
C) Controls,bound and unbound,can be added or modified on the report to make room for more information or to rearrange the information already there. 
D) To break a report into smaller sections,grand totals or sorts may be added. 
A) Reports created by the wizard can be easily customized after they have been created and saved. 
B) Themes can be applied to just the report or the whole database to change the colors,fonts,or both. 
C) Controls,bound and unbound,can be added or modified on the report to make room for more information or to rearrange the information already there. 
D) To break a report into smaller sections,grand totals or sorts may be added.

Question 16

________ allows you to filter data or copy parts of the report to the Clipboard.

Accepted Answer

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

Question 17

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) subform 
C) co-form 
D) split form 
A) joined form 
B) subform 
C) co-form 
D) split form

Question 18

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 19

A form with a subform 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

A) True 
 B)False

Question 20

Which of the following is NOT true about printing a report?

Accepted Answer

A) One way to print a report is to use the Print dialog box on the File tab to select your printing options. 
B) In Print Preview,you have many options to make design changes to your report before you send it to the printer. 
C) Before you print,it is always a good idea to view the report in Layout view to make sure it looks the way you want. 
D) In Print Preview,you can change the margins and orientation,and you can select how many pages,if not all,you want to print. 
A) One way to print a report is to use the Print dialog box on the File tab to select your printing options. 
B) In Print Preview,you have many options to make design changes to your report before you send it to the printer. 
C) Before you print,it is always a good idea to view the report in Layout view to make sure it looks the way you want. 
D) In Print Preview,you can change the margins and orientation,and you can select how many pages,if not all,you want to print.

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

A(n)________ is an object in Access that you can use to enter,edit,or view records in a table.

A theme is a built-in combination of colors and fonts.

To update data in a table,you must be in Edit mode.

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

________ a form can be useful if you need only one record's information,or if you want to use a form for other people to manually fill in the information.

A control is a part of a form or report that you use to enter,edit,or display data.

When the text of a field is selected and highlighted,you are in ________.

When you select a subform control,an orange border appears around the control and a(n)________ appears in the top-left corner.

When navigating a main form,pressing ________ will move the cursor from field to field within a record.

________ allows you to change more details of the report design or add other controls that are only available in this view.

When navigating forms with a subform,the Navigation bar buttons at the bottom of the main window are used to navigate the records in the main form,and a second Navigation bar at the bottom of the subform datasheet is used to navigate the records in the subform.

When editing a main form,pressing ________ will move the cursor to the last character in the field.

A(n)________ control is a control that does not have a source of data such as the title of the form.

Which of the following is NOT true about customizing a report?

________ allows you to filter data or copy parts of the report to the Clipboard.

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 ________.

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

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

Which of the following is NOT true about printing a report?

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters

Exam 4: Workshop 4: Access Information From an Access Database

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

A(n)________ is an object in Access that you can use to enter,edit,or view records in a table.

A theme is a built-in combination of colors and fonts.

To update data in a table,you must be in Edit mode.

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

________ a form can be useful if you need only one record's information,or if you want to use a form for other people to manually fill in the information.

A control is a part of a form or report that you use to enter,edit,or display data.

When the text of a field is selected and highlighted,you are in ________.

When you select a subform control,an orange border appears around the control and a(n)________ appears in the top-left corner.

When navigating a main form,pressing ________ will move the cursor from field to field within a record.

________ allows you to change more details of the report design or add other controls that are only available in this view.

When navigating forms with a subform,the Navigation bar buttons at the bottom of the main window are used to navigate the records in the main form,and a second Navigation bar at the bottom of the subform datasheet is used to navigate the records in the subform.

When editing a main form,pressing ________ will move the cursor to the last character in the field.

A(n)________ control is a control that does not have a source of data such as the title of the form.

Which of the following is NOT true about customizing a report?

________ allows you to filter data or copy parts of the report to the Clipboard.

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 ________.

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

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

Which of the following is NOT true about printing a report?

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters