Question 1

You can use the filter buttons in the Sort & Filter group on the Home tab to filter records in a report.

Accepted Answer

A) True 
 B)False  True

Question 2

The Form Footer section appears at the bottom of the form and usually contains a date.

Accepted Answer

A) True 
 B)False  False

Question 3

The ____ command on the Advanced menu allows you to sort records and enter criteria to restrict retrieval.

Accepted Answer

A)  Advanced Filter/Sort 
B)  Apply Filter/Sort 
C)  Query/Sort 
D)  Filter by Form 
A)  Advanced Filter/Sort 
B)  Apply Filter/Sort 
C)  Query/Sort 
D)  Filter by Form A

Question 4

In Access, mailing labels are a special type of ____________________.

Accepted Answer

The answer of In Access, mailing labels are a special...

Question 5

You can use forms to add records, delete records, or change records.

Accepted Answer

A) True 
 B)False

Question 6

The body of the form is in the ____ section.

Accepted Answer

A)  Body 
B)  Main 
C)  Detail 
D)  Record 
A)  Body 
B)  Main 
C)  Detail 
D)  Record

Question 7

To specify grouping and sorting for a report, tap or click the ____ button on the DESIGN tab in Layout view.

Accepted Answer

A)  Group 
B)  Sort 
C)  Organize by Group 
D)  Group & Sort 
A)  Group 
B)  Sort 
C)  Organize by Group 
D)  Group & Sort

Question 8

When working with a form in Access, there are three ways you can view a form. What are these three ways and what does each view allow you to do?

Accepted Answer

1. Form view - shows the form on the scr

Question 9

The ____ aggregate function finds the smallest value.

Accepted Answer

A)  Smallest 
B)  Min 
C)  TinyInt 
D)  Least 
A)  Smallest 
B)  Min 
C)  TinyInt 
D)  Least

Question 10

To filter records on a form, tap or click the Advanced button on the ____ tab to display the Advanced menu.

Accepted Answer

A)  CREATE 
B)  FORMAT 
C)  HOME 
D)  DATABASE TOOLS 
A)  CREATE 
B)  FORMAT 
C)  HOME 
D)  DATABASE TOOLS

Question 11

In the accompanying figure, you can tap or click the More button in the Group, Sort, and Total pane to specify additional options. The ____ option allows you to customize the group title.

Accepted Answer

A)  Customize 
B)  Header 
C)  Title 
D)  Label 
A)  Customize 
B)  Header 
C)  Title 
D)  Label

Question 12

When you create reports and forms, you should follow some general guidelines for report and form design. What are these eight guidelines?

Accepted Answer

1. Determine whether the data should be

Question 13

Critical Thinking Questions Case 4-1 An employee at Bavant Publishing has created the report shown in the accompanying figure but needs some assistance in adding subtotals and grand totals. Bavant also would like some way to identify customers easily who have a current due amount of zero. 
   How can the employee emphasize those records where the current amount due is $0.00?

Accepted Answer

To emphasize a particular value, use con

Question 14

Match between columns
                        Premises: A total for just the records in a group.

Accepted Answer

The Answer of Forms and summary report and ARRANGE and is...

Question 15

The various objects on a report are called tools.

Accepted Answer

A) True 
 B)False

Question 16

The ____ section appears at the top of the form and usually contains the form title.

Accepted Answer

A)  Title 
B)  Form Header 
C)  Group Header 
D)  Form Label 
A)  Title 
B)  Form Header 
C)  Group Header 
D)  Form Label

Question 17

To add totals or other statistics to a report, use the ____ button on the DESIGN tab.

Accepted Answer

A)  Aggregate 
B)  Statistics 
C)  Sum 
D)  Totals 
A)  Aggregate 
B)  Statistics 
C)  Sum 
D)  Totals

Question 18

You can print all the records, a range of pages, or a selected record of a form by selecting the appropriate print range.

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: A selection of colors and fonts for the various sections in a report or form.

Accepted Answer

The Answer of subtotal and summary report and Print Preview is...

Question 20

To add a date to a form, tap or click the ____ button on the DESIGN tab.

Accepted Answer

A)  Date and Time 
B)  Date 
C)  Show Date 
D)  Add Date 
A)  Date and Time 
B)  Date 
C)  Show Date 
D)  Add Date

You can use the filter buttons in the Sort & Filter group on the Home tab to filter records in a report.

The Form Footer section appears at the bottom of the form and usually contains a date.

The ____ command on the Advanced menu allows you to sort records and enter criteria to restrict retrieval.

In Access, mailing labels are a special type of ____________________.

You can use forms to add records, delete records, or change records.

The body of the form is in the ____ section.

To specify grouping and sorting for a report, tap or click the ____ button on the DESIGN tab in Layout view.

When working with a form in Access, there are three ways you can view a form. What are these three ways and what does each view allow you to do?

The ____ aggregate function finds the smallest value.

To filter records on a form, tap or click the Advanced button on the ____ tab to display the Advanced menu.

In the accompanying figure, you can tap or click the More button in the Group, Sort, and Total pane to specify additional options. The ____ option allows you to customize the group title.

When you create reports and forms, you should follow some general guidelines for report and form design. What are these eight guidelines?

The various objects on a report are called tools.

The ____ section appears at the top of the form and usually contains the form title.

To add totals or other statistics to a report, use the ____ button on the DESIGN tab.

You can print all the records, a range of pages, or a selected record of a form by selecting the appropriate print range.

To add a date to a form, tap or click the ____ button on the DESIGN tab.

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating, Sorting, and Querying a Table

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters

Exam 1: Access: Creating Reports and Forms

You can use the filter buttons in the Sort & Filter group on the Home tab to filter records in a report.

The Form Footer section appears at the bottom of the form and usually contains a date.

The ____ command on the Advanced menu allows you to sort records and enter criteria to restrict retrieval.

In Access, mailing labels are a special type of ____________________.

You can use forms to add records, delete records, or change records.

The body of the form is in the ____ section.

To specify grouping and sorting for a report, tap or click the ____ button on the DESIGN tab in Layout view.

When working with a form in Access, there are three ways you can view a form. What are these three ways and what does each view allow you to do?

The ____ aggregate function finds the smallest value.

To filter records on a form, tap or click the Advanced button on the ____ tab to display the Advanced menu.

In the accompanying figure, you can tap or click the More button in the Group, Sort, and Total pane to specify additional options. The ____ option allows you to customize the group title.

When you create reports and forms, you should follow some general guidelines for report and form design. What are these eight guidelines?

The various objects on a report are called tools.

The ____ section appears at the top of the form and usually contains the form title.

To add totals or other statistics to a report, use the ____ button on the DESIGN tab.

You can print all the records, a range of pages, or a selected record of a form by selecting the appropriate print range.

To add a date to a form, tap or click the ____ button on the DESIGN tab.

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating, Sorting, and Querying a Table

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters