Page 54 - ModularV1.1 _c8_flipbook
P. 54

07                                           FORMS IN


                                                                                              MS ACCESS














                                 Your Aim

                                 to learn about:

                                     l  Forms                            l  Creating a Form using Wizard
                                      l  Creating a Form Using Design      l  Types of Forms
                                       l  Viewing the Records                l  Formatting a Form

                  A  form  is  a  piece  of  paper  that  has  some  spaces  for  you  to  fill  in  information.  It  is  a  fairly

                  important piece of paper that finds its use in many places. Similarly, MS Access 2010 also allows
                  you to create forms that help to add, update and retrieve data to and from a table.
                  You have already learnt about queries in the previous chapter. In this chapter, you are going to
                  learn how to use a form in MS Access.

                      FORMS

                  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 have to be 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       Views options of
                                                                                                           a form
                     of a form. When you create a form, by default it appears in the Layout
                     view.


                   Tech


                      Funda

                                    Shortcut key for switching to Form View from Design View is F5 key.






                  52      Modular (Ver. 1.1)-VIII
   49   50   51   52   53   54   55   56   57   58   59