Page 58 - TP_Modular_V2.1_Class7
P. 58
EXCEL AS DATABASE
06
Your Aim
to learn about:
Form in Excel Using Form in Excel
Sorting Data Filtering Data
Conditional Formatting Using Data Validation
Using Subtotal Command Using Pivot Table
As you know that the Excel 2016 is used to store data. Excel 2016 allows you to use an Excel
workbook as a database. A database implies that organising the data in a manner which helps
to store and retrieve a large amount of data efficiently. The database concept is one of the oldest
ways to maintain records in a conventional file-oriented data collection system. For example,
students record in school, items record in shop and employees record in an organisation are
some examples of database.
A database contains data in
the form of rows and columns.
A column is called a Field. It Field
contains only a single piece of
data. Every column has a name
like Employee Code, Employee
Record
Name, Department, etc. A set of
values for the fields is called a
Record.
Data in Excel Worksheet
FORM IN EXCEL
One of the most important features of Excel 2016 is form. A form is a window used to display
or enter a record in an Excel worksheet. It provides various controls like text box and buttons
to enter and update data. Before using an Excel file as database, you must ensure that every
column has a heading as form uses these headings to enter or retrieve a record.
By default, Form command is not visible on the ribbon. To view the Form command, follow the
given steps:
Step 1 Open Excel 2016 and click on the File tab. The Backstage view appears.
56 Modular (Ver. 2.1)-VII

