Page 102 - Trackpad_ipro 4.1_Class7
P. 102

Formatting a Form

                  You can change the appearance of the form by using the various options available on the Design
                  and Format tabs.

                     Using Design Tab: You can add a logo and title to your
                     form by making use of the Logo and Title commands
                     present in the Header/Footer group under the Design
                     tab.

                      Using Format Tab: You can change the font, size,           Logo
                     colour, and alignment of labels; add a background
                     image to the form; change the colour of the shapes,
                     etc. using various commands present on the Format
                     tab.












                                                                                                         Background
                                                                                                              Image








                      QUERIES IN ACCESS


                  In Access 2019, a query is one of the most important tools. It helps to find, filter, and analyse data
                  from the database. It is just similar to a question and can give you information that you might not
                  be able to find by looking at the table directly. Using a query, you can search for data from one or
                  more tables by giving specific search conditions. By using a query you are able to view the exact

                  data that you want. You can review, add, change, or delete data from the database.
                  Access allows you create and save queries in your database so you can run them as many times

                  as needed. The Query Design command, present in the Queries group under the Create tab, is
                  used to create a query.
                  Types of Queries

                  The different types of queries in Access are:

                     Select Query: A query in Access retrieves data from one or more tables and displays the
                     results in a datasheet view. It allows users to group data and perform calculations such as
                     sums, counts, averages, and more.




                   100     iPro (Ver. 4.1)-VII
   97   98   99   100   101   102   103   104   105   106   107