Page 99 - iPrime_V2.2_class7
P. 99
8 More on Access
Chapter Profile
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 you may have to spend too much time looking for
a particular data from all records. Also, all 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 shortlisting the required information. It also helps in linking two or more tables
and to display consolidated information from all the selected tables.
FORMS IN ACCESS
As we know that 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 Header, Detail and
Footer sections.
Layout View is used to change the appearance and size of various
controls of a form. When you create a form, by default it appears in the
Layout view. View options of a
form
Tech Funda
The shortcut key for switching to Form View from the Design View is the F5 key.
More on Access 97

