Question 1

________ allows you to move from record to record and field to field using keystrokes.

Accepted Answer

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

Question 2

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

Accepted Answer

A) joined form 
B) main form 
C) subform 
D) split form 
A) joined form 
B) main form 
C) subform 
D) split form

Question 3

A(n)________ control is a control whose data source is an expression that you create.

Accepted Answer

The answer of A(n)________ control is a control whose data...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT true about working with a report in Print Preview?

Accepted Answer

A) Print Preview provides a view of the report representing how it will look when it is actually printed and provides you with printing options such as orientation,margins,and size. 
B) To make any changes to the report,you can work in Print Preview. 
C) Once a report is created using the wizard,it will open in Print Preview. 
D) The current date and page numbers are added,and you can navigate the report in this view using the Navigation bar. 
A) Print Preview provides a view of the report representing how it will look when it is actually printed and provides you with printing options such as orientation,margins,and size. 
B) To make any changes to the report,you can work in Print Preview. 
C) Once a report is created using the wizard,it will open in Print Preview. 
D) The current date and page numbers are added,and you can navigate the report in this view using the Navigation bar.

Question 6

When you click a control in Layout view,a(n)________ border appears around the control.

Accepted Answer

The answer of When you click a control in Layout...

Question 7

________ allows you to modify the report while seeing the data.

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 8

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

Accepted Answer

A) layout selector 
B) subform control 
C) control selector 
D) Form Wizard 
A) layout selector 
B) subform control 
C) control selector 
D) Form Wizard

Question 9

A(n)________ is created from one table and displays each record individually at the top of the window and then again as part of the whole table datasheet in the bottom of the window.

Accepted Answer

The answer of A(n)________ is created from one table and...

Question 10

A ________ control may be the name of the field or some other text you manually enter.

Accepted Answer

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

Question 11

An advantage to editing data in a table is that the number of records and/or fields in the datasheet can be overwhelming.

Accepted Answer

A) True 
 B)False

Question 12

On a report,you can change the sorting and grouping options from either Layout or Design view.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is NOT true about creating groups in a report?

Accepted Answer

A) Grouping allows you to separate related records for the purpose of creating a visual summary of the data. 
B) A group is a collection of records along with introductory and summary information about the records. 
C) Groups can only be created with data from individual tables. 
D) In the Report Wizard,you will have the option to group the data in your report. 
A) Grouping allows you to separate related records for the purpose of creating a visual summary of the data. 
B) A group is a collection of records along with introductory and summary information about the records. 
C) Groups can only be created with data from individual tables. 
D) In the Report Wizard,you will have the option to group the data in your report.

Question 14

A disadvantage to editing data in a form is that some fields may be missing.

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises: $$$Home$$$
$$$End$$$
$$$Tab$$$
$$$Ctrl$$$ + $$$Home$$$
$$$Ctrl$$$ + $$$End$$$

Accepted Answer

The Answer of Moves to the first field of the is...

Question 16

Keystroke mode allows you to move from record to record and field to field using keystrokes.

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: Bound
Unbound
Calculated
Text box
Label

Accepted Answer

The Answer of Does not have a data source and is...

Question 18

A calculated control is a control whose data source is a calculated expression that you create.

Accepted Answer

A) True 
 B)False

Question 19

On a report,the ________ calculates the total for all records.

Accepted Answer

The answer of On a report,the ________ calculates the total...

Question 20

________ view allows you to modify the report while seeing the data.

Accepted Answer

The answer of ________ view allows you to modify the...

________ allows you to move from record to record and field to field using keystrokes.

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

A(n)________ control is a control whose data source is an expression that you create.

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

Which of the following is NOT true about working with a report in Print Preview?

When you click a control in Layout view,a(n)________ border appears around the control.

________ allows you to modify the report while seeing the data.

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

A(n)________ is created from one table and displays each record individually at the top of the window and then again as part of the whole table datasheet in the bottom of the window.

A ________ control may be the name of the field or some other text you manually enter.

An advantage to editing data in a table is that the number of records and/or fields in the datasheet can be overwhelming.

On a report,you can change the sorting and grouping options from either Layout or Design view.

Which of the following is NOT true about creating groups in a report?

A disadvantage to editing data in a form is that some fields may be missing.

Keystroke mode allows you to move from record to record and field to field using keystrokes.

A calculated control is a control whose data source is a calculated expression that you create.

On a report,the ________ calculates the total for all records.

________ view allows you to modify the report while seeing the data.

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

________ allows you to move from record to record and field to field using keystrokes.

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

A(n)________ control is a control whose data source is an expression that you create.

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

Which of the following is NOT true about working with a report in Print Preview?

When you click a control in Layout view,a(n)________ border appears around the control.

________ allows you to modify the report while seeing the data.

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

A(n)________ is created from one table and displays each record individually at the top of the window and then again as part of the whole table datasheet in the bottom of the window.

A ________ control may be the name of the field or some other text you manually enter.

An advantage to editing data in a table is that the number of records and/or fields in the datasheet can be overwhelming.

On a report,you can change the sorting and grouping options from either Layout or Design view.

Which of the following is NOT true about creating groups in a report?

A disadvantage to editing data in a form is that some fields may be missing.

Keystroke mode allows you to move from record to record and field to field using keystrokes.

A calculated control is a control whose data source is a calculated expression that you create.

On a report,the ________ calculates the total for all records.

________ view allows you to modify the report while seeing the data.

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