Page 103 - iPrime_V2.2_class7
P. 103

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 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 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 which 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.
                    Crosstab Query: It shows your data in a grid with row and column headings, so you can see
                   and compare your information across two categories at once.









                                                              Query types
                 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.

                 Setting up Relationship


                 A relationship between two tables connects them through a common field. The field in the first
                 table is called the primary key, and the same field in the second table is called the foreign key.
                 The foreign key must match the primary key. To create this link, make sure both tables have a

                 primary key.
                    Table named ‘StudentsDetail’ that holds general information about the students such as their
                   Roll No, Student Name, Father’s Name and Class.


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