Page 49 - ModularV1.1 _c8_flipbook
P. 49

06                                      QUERIES IN


                                                                                             MS ACCESS














                                Your Aim

                                to learn about:

                                   l  What is a Query?                 l  Types of Queries
                                    l  Setting up Relationship                   l  Creating a Query

                 Data is mostly stored in large quantities. Suppose, there are many columns in a table; then, you may
                 have to spend too much time looking for a particular data from all the records. MS Access provides

                 a feature called query that helps you to extract a particular record from a set of records. Till now,
                 you have learnt how to work with tables. Now, you will learn about queries in MS Access 2010.
                     WHAT IS A QUERY?

                 A query is the most important object provided by MS Access 2010. 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 data from one or more tables by giving specific search conditions.
                 By using query, you will be able to view the exact data that you want. You can then review, add,
                 change or delete data from your database.

                     TYPES OF QUERIES
                 The different types of queries in MS Access are:

                     Select Query: It retrieves data from one or more tables. It displays the records in a datasheet
                   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.

                     Crosstab Query: It is a query that uses a row heading and column heading so that you can
                   see your data in terms of two categories at once.
                 Clickipedia



                     Structured Query Language (SQL) is a fifth generation computer language for relational
                   database  and data  manipulation. It is used to insert, update  and  retrieve  data  from a
                   database table.



                                                                                           Queries in MS Access   47
   44   45   46   47   48   49   50   51   52   53   54