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
   94   95   96   97   98   99   100   101   102   103   104