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