Question 1

Which of the following is NOT true about enhancing a report with grouping and sorting?

Accepted Answer

A) The Report Wizard gives you the opportunity to sort and group records,but sometimes seeing the report changes your mind about what and how to group and sort. 
B) You can change the sorting and grouping options from either Layout or Report view. 
C) Groups are added to a section of the report called the group header. 
D) Calculations performed on a group in a report are added to a section called the group footer. 
A) The Report Wizard gives you the opportunity to sort and group records,but sometimes seeing the report changes your mind about what and how to group and sort. 
B) You can change the sorting and grouping options from either Layout or Report view. 
C) Groups are added to a section of the report called the group header. 
D) Calculations performed on a group in a report are added to a section called the group footer.

Question 2

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

Accepted Answer

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

Question 3

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.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

Which of the following is NOT true about creating a report using the Report Wizard?

Accepted Answer

A) In the Report Wizard,you can choose the table or query to base the report on,and choose the fields to include in the report. 
B) Once a report is created using the wizard,it will open in Design view. 
C) In the Report Wizard,you have the option to group the data in your report. 
D) The Report Wizard will walk you step by step through the process of building your report. 
A) In the Report Wizard,you can choose the table or query to base the report on,and choose the fields to include in the report. 
B) Once a report is created using the wizard,it will open in Design view. 
C) In the Report Wizard,you have the option to group the data in your report. 
D) The Report Wizard will walk you step by step through the process of building your report.

Question 6

Which of the following is NOT true about editing,adding,and deleting records?

Accepted Answer

A) Records can be deleted from a single table without additional steps if the table is not part of a relationship. 
B) When you add a record to a form,you are actually adding the record to the table it will be stored in. 
C) Changes to data are saved automatically. 
D) If the table is part of a relationship,referential integrity has been enforced,and the cascade delete option has been chosen,a record cannot be deleted if there are related records in another table until those records have also been deleted. 
A) Records can be deleted from a single table without additional steps if the table is not part of a relationship. 
B) When you add a record to a form,you are actually adding the record to the table it will be stored in. 
C) Changes to data are saved automatically. 
D) If the table is part of a relationship,referential integrity has been enforced,and the cascade delete option has been chosen,a record cannot be deleted if there are related records in another table until those records have also been deleted.

Question 7

On a report,a(n)________ is a collection of records along with introductory and summary information about the records.

Accepted Answer

The answer of On a report,a(n)________ is a collection of...

Question 8

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 9

If you want to delete a customer from tblCustomer when referential integrity is turned on,and that customer has appointments in tblSchedule,then the appointments for the customer have to be deleted from the tblCustomer first.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

A split form 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 12

Match the following keystrokes with how they are used in Navigation Mode on datasheets and forms.
I.$$$Home$$$
II.$$$End$$$
III.$$$Tab$$$
IV.$$$Ctrl$$$ + $$$Home$$$
V.$$$Ctrl$$$ + $$$End$$$
A.Moves to the first field of the first record
B.Moves to the first field in the record
C.Move one field at a time
D.Moves to the last field of the last record
E.Moves to the last field in the record

Accepted Answer

The answer of Match the following keystrokes with how they...

Question 13

A(n)________ control represents the actual value of a field and is a bound control.

Accepted Answer

The answer of A(n)________ control represents the actual value of...

Question 14

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.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is NOT true about multiple-table forms?

Accepted Answer

A) The main form will display the first table one record at a time just like a single-table form. 
B) Access will automatically use the common field between the tables to create the form. 
C) Before you can use two tables in a form,you must make sure there is a one-to-many relationship between the tables. 
D) The subform will display "one" record in the one-to-many relationship. 
A) The main form will display the first table one record at a time just like a single-table form. 
B) Access will automatically use the common field between the tables to create the form. 
C) Before you can use two tables in a form,you must make sure there is a one-to-many relationship between the tables. 
D) The subform will display "one" record in the one-to-many relationship.

Question 16

The layout view selector allows you to move the whole table at one time.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

The answer of A(n)________ control is a control that does...

Question 18

A(n)________ control may be the name of the field or some other text you manually enter and is an unbound control.

Accepted Answer

The answer of A(n)________ control may be the name of...

Question 19

________ mode allows you to edit,or change,the contents of a field.

Accepted Answer

The answer of ________ mode allows you to edit,or change,the...

Question 20

Changes to data are saved automatically,but can be undone while the table or form is open by using the Undo button.

Accepted Answer

A) True 
 B)False

Which of the following is NOT true about enhancing a report with grouping and sorting?

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

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.

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

Which of the following is NOT true about creating a report using the Report Wizard?

Which of the following is NOT true about editing,adding,and deleting records?

On a report,a(n)________ is a collection of records along with introductory and summary information about the records.

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

If you want to delete a customer from tblCustomer when referential integrity is turned on,and that customer has appointments in tblSchedule,then the appointments for the customer have to be deleted from the tblCustomer first.

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

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

A(n)________ control represents the actual value of a field and is a bound control.

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.

Which of the following is NOT true about multiple-table forms?

The layout view selector allows you to move the whole table at one time.

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

A(n)________ control may be the name of the field or some other text you manually enter and is an unbound control.

________ mode allows you to edit,or change,the contents of a field.

Changes to data are saved automatically,but can be undone while the table or form is open by using the Undo button.

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

Which of the following is NOT true about enhancing a report with grouping and sorting?

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

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.

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

Which of the following is NOT true about creating a report using the Report Wizard?

Which of the following is NOT true about editing,adding,and deleting records?

On a report,a(n)________ is a collection of records along with introductory and summary information about the records.

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

If you want to delete a customer from tblCustomer when referential integrity is turned on,and that customer has appointments in tblSchedule,then the appointments for the customer have to be deleted from the tblCustomer first.

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

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

A(n)________ control represents the actual value of a field and is a bound control.

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.

Which of the following is NOT true about multiple-table forms?

The layout view selector allows you to move the whole table at one time.

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

A(n)________ control may be the name of the field or some other text you manually enter and is an unbound control.

________ mode allows you to edit,or change,the contents of a field.

Changes to data are saved automatically,but can be undone while the table or form is open by using the Undo button.

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