Page 35 - Computer - 8

DATABASE OBJECTS

Databases in Access are composed of six objects – tables, forms, queries, reports, macros, and modules.
These objects let you enter, view, analyse, and present the data as desired.
Table : A Table organises data in form of rows and columns in a database.
Form : A Form lets you enter and display data in a customised format.
Query : A Query searches and retrieves data from the database based on a set of selection criteria.
Report : A Report displays the data in a printable format.
Macro : A Macro automates the tasks that are performed more often in the database.
Module : A Module contains programming statements written in VBA programming language.

Try This
Critical Thinking
Identify and write the name of Access 2019 component or object which is described below:
(a) searches and retrieves data from the database based on a set of selection criteria. ___________
(b) provides options to navigate through records and search for data. ___________
(c) automates the tasks that are performed more often in the database. ___________
(d) displays a list of all the objects in the database. ___________
(e) organises data in form of rows and columns in a database. ___________

WORKING WITH DATABASES

Access 2019 lets you create a database by using a predefined template or from a blank database.
Creating a Database by using a Template

Access provides a wide variety of templates that can be used to create a database quickly. A database
template is a pre-designed database complete with professionally designed tables, forms and reports.
You can modify the design of any of these objects as per your requirement.
To create a new database using a template:
1. Click the File tab.

The Backstage view opens. 2

2. Select the New option.
A list of pre-designed templates is
displayed.

3
3. Click the template you want to use.
A dialog box opens.

4. Specify the name and location for the database and
click the Create button.
Access creates a new database according to the selected
template.
4

33