Page 54 - TP_Prime_V2.2_Class8
P. 54

Queries in Access

                  In Access 2016, 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 query,
           Prime (Ver. 2.2)-VIII  delete data from the database.
                  you are able to view the exact data that you want. You can then review, add, change or



                  Access allows you create and save queries in your database so you can run them as many
                  times as needed. The Query Design command presents 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:
          52      •  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

                                        Structured Query Language (SQL) is a fifth generation computer
                          Fun
                          Fact!         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.
   49   50   51   52   53   54   55   56   57   58   59