WorksheetsBIS Workshop W10
Total questions: 8
Worksheet time: 5mins
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.
