Page 36 - Computer Genius Class 07
P. 36
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 retrie e a large amount o data e ciently. The data ase concept is one o the oldest ays
to maintain records in a con entional file oriented data collection system. For e ample students
record in school items record in shop and employees record in an organisation are some e amples
of database.
Field
Record
A database contains data in the form of rows and columns. A column is called a Field. It contains only
a single piece o data. ery column has a name li e mployee ode mployee ame Department
etc. A set o alues or the fields is called a Record.
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. e ore using an cel file as data ase you must ensure that e ery column has a
heading as form uses these headings to enter or retrieve a record.
y de ault Form command is not isi le on the ri on. To ie the Form command ollo the
given steps:
1 Click on the File tab.
2 Select the
Options option.
34 Computer Genius-VII

