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.

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