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.

