Page 50 - TP_Prime_V2.2_Class8
P. 50
04
MORE ON
ACCESS
Prime (Ver. 2.2)-VIII Learning Objectives
Forms in Access
•
Queries in Access
•
Reports in Access
•
48 When we take an online exam, we need to fill a form. After completing the
exam when we click on the submit button, the information we have entered on
the form will appear with the marks scored in the exam. How is the computer
retrieving and displaying the data?
Computer retrieves the data from the database through queries and display
in the form of reports. We can also create a similar form in the Access. Let's
learn about them.
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
in looking for a particular data from all records. Also, all information about a record are
not always needed. To solve this problem, Access has some more features like Forms,
Queries and Reports. These features help in short listing the required information. It
also helps in linking two or more tables and displays a 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 displayed. By creating forms, you can make your database more user friendly for
those who edit and enter the records.

