Page 89 - TP_iPlus_V2.1_Class7
P. 89
• 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.
Info Byte
If primary key constraint is applied to more than one field, then it is called a composite
key.
i + ACCESS 2016
Access is a powerful and easy-to-use Relational Database Management System
(RDBMS) which is a part of the Microsoft Office Suite. It provides handy tools that
help in operating, maintaining, and manipulating the records more effectively. Access 2016
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.
To start Access 2016, follow these steps:
3 Click on the Access 2016 from the list.
1 Click on the
Start button.
2 Type here Access 2016.
i + 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.
87
Database and DBMS—An Introduction

