Scribd
Upload
5 views1 page

Understanding Microsoft Access Queries

Uploaded by

Nonayobus
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views1 page

Understanding Microsoft Access Queries

Uploaded by

Nonayobus
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

What's Query?

In Microsoft Access, a query is a request for data or an action on data. Queries are powerful
tools used to retrieve specific information from one or more tables, perform calculations,
combine data, or modify data within a database.

Types of Queries:

Select Queries: The most common type, used to retrieve data from tables based on specified
criteria and display it in a datasheet view.

Action Queries: Used to make changes to data in tables. This includes:

Append Queries: Add records from one or more tables to another table.

Delete Queries: Remove records from one or more tables.

Update Queries: Modify data in existing records.

Make-Table Queries: Create a new table from the results of a query.

Crosstab Queries: Summarize data in a compact, spreadsheet-like format, calculating sums,


averages, counts, or other aggregate functions for groups of records.

Parameter Queries: Prompt the user for input (parameters) each time the query is run,
allowing for dynamic filtering of results.
,
SQL Queries: Queries written directly in Structured Query Language (SQL), offering more
advanced control over data manipulation.

You might also like