Page 61 - modular4.0
P. 61
Chapter Profile
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. Follow the given steps to view the Form
command:
1 Click on
the File tab.
2 Select the
Options option.
4 Select the Commands Not in the
Ribbon option from the Choose
commands from drop-down list.
6 Select the
Form command
and click on the
Add >> button
to add the
command in the
3 Click on the selected group.
Customize
Ribbon option.
5 Click on Insert
under Main Tabs
and click on New
Group button
to create a new
group.
7 Click on the OK button.
The Form command will appear on the ribbon.
USING FORM IN EXCEL
As you know that you can add, update and delete a record using a form. A form displays only one
record at a time. To perform all these operations, first you need to create an Excel worksheet and
enter the required data.
Excel as Database 59

