Sams Teach Yourself Microsoft® Office Access 2003 in 24 Hours

Chapter 15. Power Query Techniques

You learned the basics of query design in Hour 10, “Creating Queries,” but Access has a wealth of other query capabilities. In addition to the relatively simple Select queries covered in Hour 10, you can create queries that accomplish the following tasks:

• Include calculated fields

• Filter information

• Include parameters that vary at runtime

• Insert, update, and delete table data

• Aggregate table data

This hour covers these topics and some of the more advanced aspects of query design.

Adding Calculated Fields to Select Queries

One of the rules of data normalization is that you should not include the results of calculations in a database. You can output the results of calculations by building those calculations into queries, ...