Page 25 - Code & Click - 8

Ribbon
The Ribbon, present below the Title Bar, is divided into various Tabs and Groups. The main tabs
present on the Access 2016 Ribbon are – Home, Create, External Data, Database Tools, and Help.

File Tab
The File Tab, present below the Quick Access Toolbar, is used to open the Backstage view, which
provides options to create, open, save, print, and close the database.

Navigation Pane
The Navigation Pane, present at the left of the Access window, displays a list of all the objects in the
database. It organises objects into groups on the basis of their type such as tables, queries, forms,
and reports. You can open, rename, and delete objects using the Navigation Pane.

Work Area
The Work Area, present at the centre of the Access window, is the area where you work on objects
in a database. Access 2016 displays all open objects in tabs on the Document Tabs bar.

Record Navigation Bar
The Record Navigation Bar, present at the bottom of the Work area, provides options to navigate
through records and search for data.
Status Bar
Datasheet view Design view

The Status bar, located at the bottom of the Access window, displays information about the current
database. It also contains buttons to switch between the different views of the current database
object.
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 2016 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. ___________

23