Database Reference
In-Depth Information
Create queries
7
IN THIS CHAPTER, YOU WILL LEARN HOW TO
Create queries by using a wizard.
Create queries manually.
Summarize data by using queries.
Calculate by using queries.
Update records by using queries.
Delete records by using queries.
Microsoft Access 2013 provides a variety of tools you can use to locate specific items of in-
formation. In Chapter 4, “Display data,” you learned how to sort and filter tables and forms.
With a little more effort, you can create two basic types of queries:
Select Finds records in the database that match the criteria you specify and then
display those records in a datasheet, form, or report. You can use select queries to
display specific fields from specific records from one or more tables.
Action Finds records in the database that match the criteria you specify and then
do something with those records. You can use action queries to ensure the ongoing
accuracy of a database—for example, by updating information or deleting selected
records from a table.
You can save both types of queries and run the saved queries at any time to generate
updated results when data changes.
In this chapter, you'll use different methods to create queries that locate information match-
ing multiple criteria. Then you'll create queries to summarize data and perform calculations.
Finally, you'll create an update query and a delete query.
 
Search WWH ::




Custom Search