Page 86 - iPrime_V2.2_class7
P. 86
Query: A query is the most powerful object of a database. It helps you to retrieve information
from a table based on some criteria or conditions. You can find and retrieve data from the
database just by creating and running the query.
Report: A report is a database object that is specially designed to display or print the data in a
formatted way. It is the final result of the manipulated data that comes from tables or queries
in DBMS is known as a report.
Form: A form is a database object used to create a user interface to enter or update a record
in a table that is connected to it. It also allows us to view all the records from the table one by
one.
Clickipedia
If more than one field is combined to form a primary key, then it is called a composite key.
ACCESS 2016
Access is a powerful and easy-to-use Relational Database Management
System (RDBMS) which is a part of Office Suite. It provides handy tools that
help in operating, maintaining and manipulating the records more effectively.
It prevents the duplication of data. It allows you to add, delete, modify and update
the records in a database by establishing a relationship between the tables. Access 2016
To start Access 2016, click on the Start → Access 2016. This will open the Access window.
COMPONENTS OF ACCESS 2016
Access 2016 has the following components:
Quick Access Toolbar: It is a small bar at the top-left corner of the Access 2016 window. It
usually has buttons for Save, Undo, and Redo, and it can be customised to include additional
commands as needed.
Title Bar: It is the topmost bar of the Access window that displays the name of the currently
opened database.
Ribbon: In Access 2016, the long bar located just below the Title bar is known as the Ribbon.
It is organised into different tabs, such as File, Home, Create, and others. Each tab is further
divided into groups, which contain various commands and tools used in Access 2016.
Navigation Pane: This pane is present on the left side of the Access window. It displays the
names of the objects used in the database such as Table, Query, Form, etc. It allows users to
easily access and manage the objects.
Navigation Buttons: These buttons help in navigating through the records.
Work Area: It is the area where records are added to the various fields in a table.
Objects Tabs: The objects such as Tables, Queries, and Forms that we open in the database
are present in the form of tabs under the Ribbon.
84 Touchpad iPRIME (Ver. 2.2)–VII

