Page 102 - iPlus_Ver_2.0_class_7
P. 102

•  Using Design Tab: You can add a logo and title to your
                     form by making use of the Logo and Title commands
                     present under the Header/Footer group in 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










                   i +  QUERIES IN ACCESS

                  A query is the most important object provided by Access. 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 then review, add,
                  change, or delete data from your database.

                  Access allows you to create or build a query and save it in the database so that you can run it
                  multiple times. The Query Design command, present under the Queries group on the Create
                  tab, is used to create a query.
                  Types of Queries

                  The different types of queries in Access are:

                  •  Select Query: It retrieves data from one or more tables. It displays the record in a datasheet,
                     allowing users to group data and calculate sum, count, average, etc.

                  •  Parameter Query: It is a type of select query that prompts you for the input before it runs. It
                     uses the input as the criteria that controls the result.

                  •  Action Query: It creates a new table or alters your data by adding, deleting, updating, and
                     appending data from it.





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