• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part: IV Power Access Techniques > Power Query Techniques

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint