BIS Workshop W10

Part 2 in the picture is called

• Main form

• Report

• Sub-form

• Query

The term 'Object' in Access includes

• Tables

• Forms

• Queries

• All of the above

Which of the following statements best describes a query?

• Data resulting from questions you ask of one or more tables.

• A formatted summary of data suitable for printing.

• A list of settings that control who can edit the data.

• A user-friendly interface for entering and viewing data.

Why would you want to create a report?

• Reports are used to add data collection fields to forms.

• Reports make it easier to add records to tables.

• Reports allow you to present table and query results in a easy-to-read format.

• Reports allow you to export a table as an Excel file.

Regarding the picture, which of the following statement is TRUE?

• The dynaset of this query contains data from 2 tables only.

• The dynaset of this query will be sorted in A-to-Z order by ‘Product Types’.

• This is an example of a sorted query.

• The query will return only products containing strawberry.

This is an example of a...

• Report based on a query

• Grouped report

• Report based on 3 tables

• Filtered report

Suppose you run a query, and a dialog box appears asking you to enter a date. You are most likely working with a ________ query.

• Dialog

• Date & time

• Totals

• Dynamic

__________ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.

• Design view.

• Layout view.

• Print Preview.

• Report view.