Page 62 - Computer - 8

10. Click the Next button.

9 11

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.

Database Subject Enrichment

Queries may appear like tables, but the key difference is that while a table physically stores the data, a query
is just a view of the data from a certain perspective. A query in Access can be a SELECT query, which does not
change values but instead views the information from tables and other queries, or an ACTION query, which
can alter values in a table. All queries in Access are written as SQL (Structured Query Language) queries,
which is the standard backbone language for most database applications. When you save a MS Access
query, the SQL statement behind the query is saved as text in a file but with no data.

Post-Processing  


 A Query is used to extract information from one or more tables in a database.
 A query in Access 2019 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 three ways to create a form for a table – the Form Command, Split Form, and the
Form Wizard.
 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.
 Access provides two ways to create a report – the Report Command and the Report Wizard.

60