What Is a Query and When Should You Use One?


A Select query is a stored question about the data stored in a database's tables. Select queries are the foundation of much of what you do in Access. They underlie most forms and reports, and they allow you to view the data you want, when you want. You use a simple Select query to define the tables and fields whose data you want to view and also to specify the criteria that limits the data the query's output displays. A Select query is a query of a table or tables that just displays data; the query doesn't modify data in any way. An example is a query that allows you to view customers who have placed orders in the past month. You can use more advanced Select queries to summarize data, supply the results of calculations, or cross-tabulate data. You can use Action queries to add, edit, or delete data from tables, based on selected criteria, but this hour covers Select queries. Hour 15, "Power Query Techniques," covers other types of queries, including Action queries.

    Part III: Creating Your Own Database and Objects
    Part V: Advanced Topics