Page 44 - Code & Click - 8

10. Click the Next button.

11
9

12

10
11. Type a name for the report.

12. Select Preview the report radio button and click the Finish button.

Access creates the report object and displays the report in Print Preview view.

Post-Processingost-Processing
P
 A Query is used to extract information from one or more tables in a database.
 A query in Access 2016 can be created using either the Query Wizard or the Query Design.
 The Query Design allows you to specify the fields covered in the query, the condition to retrieve
specific records, change the order of fields, and arrange the retrieved records as desired.
 Form is a database object that provides a Windows-like interface to view and edit data
easily in a table.
 Access provides the Form Wizard to create a form for a table.
 A Report is a database object that lets you view data from a table or a query in printable
format but does not allow to edit the data.

Info Retention
A. Select the correct option for each of the following statements.

1. The database object that is used to extract information from one or more tables is ______.
(a) Report (b) Macro (c) Table (d) Query
2. The database object that is used to view data from a table or a query in printable form is

______.
(a) Report (b) Macro (c) Table (d) Query

42