Page 99 - Trackpad_ipro 4.1_Class7
P. 99

More on Access





                                                                                   Chapter
                                                                                   08





                                   Your Aim

                                   to learn about:

                                      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


                     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