[ Team LiB ] Previous Section Next Section

Hour 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.

    [ Team LiB ] Previous Section Next Section