Page 45 - Digicode_AI_class_7
P. 45
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.
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 of data. Every column has a name like Employee Code, Employee Name, Department,
etc. A set of values for 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. 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:
1 Click on the File tab.
2 Select the
Options option.
Advanced Features of Excel 2016 43

