• CLOSED
    December 17 12:00am
    The competition lap pool for lap swim is closed. more »
  • Holiday Training
    December 18 12:00am
    Holiday Training more »
  • Competition Pool
    December 18 5:30am
    lap swim more »
  • Competition Pool
    December 18 11:00am
    Lap Swim more »
  • Instructional Pool
    December 18 2:00pm
    Lap Swim more »
Sunday, December 17, 2017
    IU Calendar




    • CLOSED
      December 17 12:00am
      The competition lap pool for lap swim is closed. more »
    • Holiday Training
      December 18 12:00am
      Holiday Training more »
    • Competition Pool
      December 18 5:30am
      lap swim more »
    • Competition Pool
      December 18 11:00am
      Lap Swim more »
    • Instructional Pool
      December 18 2:00pm
      Lap Swim more »
    Sunday, December 17, 2017
      IU Calendar




      • CLOSED
        December 17 12:00am
        The competition lap pool for lap swim is closed. more »
      • Holiday Training
        December 18 12:00am
        Holiday Training more »
      • Competition Pool
        December 18 5:30am
        lap swim more »
      • Competition Pool
        December 18 11:00am
        Lap Swim more »
      • Instructional Pool
        December 18 2:00pm
        Lap Swim more »
      Sunday, December 17, 2017
        IU Calendar




        • CLOSED
          December 17 12:00am
          The competition lap pool for lap swim is closed. more »
        • Holiday Training
          December 18 12:00am
          Holiday Training more »
        • Competition Pool
          December 18 5:30am
          lap swim more »
        • Competition Pool
          December 18 11:00am
          Lap Swim more »
        • Instructional Pool
          December 18 2:00pm
          Lap Swim more »
        Sunday, December 17, 2017

          About This Event

          Summary

          This workshop lasts 3 hours, and is part of the certificate series Access 2010 End-User

          Queries enable you to retrieve, analyze and manipulate data. This workshop is intended for those participants who are interested in creating and modifying queries on related tables. Various types of queries will be introduced. This workshop also covers advanced query functions such as aggregate totals and calculated expressions.

           

           

          What You'll learn

          Available Downloads

          • build relational queries and modify query properties

          • learn to perform mathematical and text operations in a query

          • create parameter queries

          • summarize data using groups, calculated expressions, and aggregate totals

          • create Crosstab queries to summarize data

          • create and run Action queries to create, modify and delete data

          • use Find Duplicates and Find Unmatched queries to locate data

          What you need to know

          • Create and modify tables

          • Understand database relationships

          If you don't have those skills, consider first taking the workshop:

          Bookmark and Share

          Event Schedule

          There are no upcoming dates for this event.

          IU Calendar




          • CLOSED
            December 17 12:00am
            The competition lap pool for lap swim is closed. more »
          • Holiday Training
            December 18 12:00am
            Holiday Training more »
          • Competition Pool
            December 18 5:30am
            lap swim more »
          • Competition Pool
            December 18 11:00am
            Lap Swim more »
          • Instructional Pool
            December 18 2:00pm
            Lap Swim more »
          Sunday, December 17, 2017