Page 97 - iPro_trackGPT_V5_Class7
P. 97

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, 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 2021, 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.


                                                                                               More on Access    95
   92   93   94   95   96   97   98   99   100   101   102