Page 103 - TP_iPlus_V2.1_Class7
P. 103

•  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









                  i +  QUERIES IN ACCESS


                 In Access 2010, 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 provide 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.
                 •  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 for determining the result.

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




                                                                                                                 101
                                                                                                More on Access
   98   99   100   101   102   103   104   105   106   107   108