Page 100 - TP_iPlus_V2.1_Class7
P. 100
More on Access
8
Learning Outcomes
Forms in Access Queries in Access
Reports in Access
You have learnt how Access is used to create tables and maintain records in a database. Suppose
there are many columns in a table, then finding a particular record among all the entries can
be time-consuming. Also, all the information about a record is not always needed. To solve this
problem, Access has some more features like Forms, Queries and Reports. These features help
in filtering the required information. It also helps in linking two or more tables and displaying
consolidated information from all the selected tables.
i + FORMS IN ACCESS
As we know, a form is a database object used to add, edit, and display data from a table in a
user-friendly manner. While creating a form, you can choose the fields to be displayed and how
they are displayed. By creating forms, you can make your database more user-friendly for those
who edit and enter the records.
The three main views in which a form can be displayed are:
• Form View is used to enter, edit, and view data.
• Design View is used to adjust the design of your form. It gives you a
more detailed view of the structure of a form, such as a Header, Detail,
and Footer sections.
• Layout View is used to change the appearance and size of various
controls on a form. When you create a form, by default it appears in the
Layout view.
Quick Byte
The shortcut key for switching to Form View from the Design View is F5 key.
98
iPlus (Ver. 2.1)-VII

