• 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.5 hours, and is part of the certificate series Access 2010 End-User

          Relationships are the fundamental building blocks of complex databases and are critical to designing and working with sophisticated databases. This workshop is intended for participants who are familiar with the basic features of Access but are interested in learning how to define relationships in relational databases and how to create relational queries and forms. Creating multivalued and lookup fields will be introduced. Challenge exercises will help reinforce concepts.

              What You'll learn Available Downloads

          • explore various types of relationships and create relationships between tables

          • understand how referential integrity rules work

          • build relational queries exploring different join types

          • create multivalued and lookup fields

          • export a query to Microsoft Excel

          • create a relational form

          • import columns of data from an Excel workbook into an Access table

          • explore the options for cascade update related fields and cascade delete related records

          What you need to know

          • understand the basic features of Access

          • create simple tables

          • enter and edit data in tables

          • create simple queries

          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