Intro Creating Access Queries


	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. When you complete this module you will be able 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