Page 52 - ModularV1.1 _c7_flipbook
P. 52
06 EXCEL AS DATABASE
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, MS Excel is used to store data. MS Excel allows you to use an Excel workbook as
a database. A database implies organising the data in a manner that 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 records in
school, items records in shop and employees records in an organisation.
A database contains data in
the form of rows and columns.
A column is called a Field. It
contains only a single piece
of data. Every column has a Field
name such as Employee Code,
Employee Name, Department,
etc. A set of values for the
fields is called a Record. Record
FORM IN EXCEL Data in Excel Worksheet
One of the most important features of MS Excel 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 MS Excel 2010 and click on the File tab. The Backstage view appears.
50 Modular (Ver. 1.1)-VII

