DBWebApplications 





Data Manipulation  «Prev  Next»
Lesson 1
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
  1. Create a query with the Simple Query Wizard
  2. Group and summarize data in a query by using the Simple Query Wizard
  3. Identify the commonly used features of Query Design view
  4. Create a query in Query Design view
  5. View the results of the query
  6. Save the query design
  7. Use one query as the basis for another
  8. Edit a query
  9. Add criteria to queries
  10. Understand how to use multiple criteria in queries to get the results you want
  11. Specify the sort order for a query
  12. Create a new field by using a calculation

Query Architecture

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.