Intro Creating Access Queries
Queries are often used to pull together data from multiple related tables.
If you want a prettier presentation, you might then use the query as the basis for a report or form.
However, queries are more powerful than just pulling data together, you can also use them to find the data you need and to perform calculations.
This module discusses how to
Create a query with the Simple Query Wizard
Group and summarize data in a query by using the Simple Query Wizard
Identify the commonly used features of Query Design view
Create a query in Query Design view
View the results of the query
Save the query design
Use one query as the basis for another
Edit a query
Add criteria to queries
Understand how to use multiple criteria in queries to get the results you want
Specify the sort order for a query
Create a new field by using a calculation
Because Access web app tables are now tables in SQL Server, it should come as no surprise to you that, when you create queries in a web app,
Access will create the SQL objects needed to support the query. Normally, simple Access queries are saved as SQL Server views while Access
parameterized queries become SQL Server inline table-valued functions.
SQL Server Views
When you work only via Access 2013 web apps, you do not have to worry about the particulars of how Access 2013 manages the SQL Server object counterparts of queries.
However, in scenarios where you connect to the SQL Server database containing your web app's data from another interface, such as a client database,
it may be useful to take note of those particulars.
First, although an Access client query allows you to define sorting as part of the query, this is not normally a part of a SQL Server view.