Page 94 - iPro_trackGPT_V5_Class7
P. 94

8


                             More on Access













                       Goal Glimpse

                          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 record from all the records. 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 shortlisting the required information. It also helps in linking two or more
                  tables and displaying consolidated information from all the selected tables.

                     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.

                          Tech Tweak

                    The shortcut key for switching to Form View from the Design View is the F5 key.






                    92    TrackGPT iPRO (V5.0)-VII
   89   90   91   92   93   94   95   96   97   98   99