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.
   45   46   47   48   49   50   51   52   53   54   55