• Fall Career Week, September 26-30
    September 26 12:00am
    This week of career events offers something for everyone! Students, faculty, employers, and alumni share career expertise you won't want to miss. Attend sessions to learn more about majors, career paths, job searching, and more. Most events are in the IUPUI Campus Center. Mark your calendars for Fall Career Week 2016: Sep more »
  • Bubble Ball/Knocker Ball
    September 26 12:00am
    New intramural sport where participants climb into a bublle and play, bounce, roll, and enjoy the excitement. Team entry fee is $60. All intramurals participants are required to create an account on IMLeagues.com/iupui. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
  • Competition Pool
    September 26 5:30am
    The competition pool for lap swim is open more »
  • Stress Less with the Cultural Arts Gallery
    September 26 11:00am
    Whether you are worn-out from the weekend or need a few hours to refocus, the Gallery team has prepared a few hours of guided meditation and other stress management activities for you to enjoy. Co-sponsored by the Counseling & Psychological Services. more »
  • InDesign CC 2015: The Basics
    September 26 1:30pm
    This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals This workshop is intended to be a three-hour hands-on experience. In the context of constructing a basic newsletter, participants of this workshop will manipulate text and graphic objects using a broad r more »
Monday, September 26, 2016
    IU Calendar




    • Fall Career Week, September 26-30
      September 26 12:00am
      This week of career events offers something for everyone! Students, faculty, employers, and alumni share career expertise you won't want to miss. Attend sessions to learn more about majors, career paths, job searching, and more. Most events are in the IUPUI Campus Center. Mark your calendars for Fall Career Week 2016: Sep more »
    • Bubble Ball/Knocker Ball
      September 26 12:00am
      New intramural sport where participants climb into a bublle and play, bounce, roll, and enjoy the excitement. Team entry fee is $60. All intramurals participants are required to create an account on IMLeagues.com/iupui. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
    • Competition Pool
      September 26 5:30am
      The competition pool for lap swim is open more »
    • Stress Less with the Cultural Arts Gallery
      September 26 11:00am
      Whether you are worn-out from the weekend or need a few hours to refocus, the Gallery team has prepared a few hours of guided meditation and other stress management activities for you to enjoy. Co-sponsored by the Counseling & Psychological Services. more »
    • InDesign CC 2015: The Basics
      September 26 1:30pm
      This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals This workshop is intended to be a three-hour hands-on experience. In the context of constructing a basic newsletter, participants of this workshop will manipulate text and graphic objects using a broad r more »
    Monday, September 26, 2016
      IU Calendar




      • Fall Career Week, September 26-30
        September 26 12:00am
        This week of career events offers something for everyone! Students, faculty, employers, and alumni share career expertise you won't want to miss. Attend sessions to learn more about majors, career paths, job searching, and more. Most events are in the IUPUI Campus Center. Mark your calendars for Fall Career Week 2016: Sep more »
      • Bubble Ball/Knocker Ball
        September 26 12:00am
        New intramural sport where participants climb into a bublle and play, bounce, roll, and enjoy the excitement. Team entry fee is $60. All intramurals participants are required to create an account on IMLeagues.com/iupui. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
      • Competition Pool
        September 26 5:30am
        The competition pool for lap swim is open more »
      • Stress Less with the Cultural Arts Gallery
        September 26 11:00am
        Whether you are worn-out from the weekend or need a few hours to refocus, the Gallery team has prepared a few hours of guided meditation and other stress management activities for you to enjoy. Co-sponsored by the Counseling & Psychological Services. more »
      • InDesign CC 2015: The Basics
        September 26 1:30pm
        This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals This workshop is intended to be a three-hour hands-on experience. In the context of constructing a basic newsletter, participants of this workshop will manipulate text and graphic objects using a broad r more »
      Monday, September 26, 2016
        IU Calendar




        • Fall Career Week, September 26-30
          September 26 12:00am
          This week of career events offers something for everyone! Students, faculty, employers, and alumni share career expertise you won't want to miss. Attend sessions to learn more about majors, career paths, job searching, and more. Most events are in the IUPUI Campus Center. Mark your calendars for Fall Career Week 2016: Sep more »
        • Bubble Ball/Knocker Ball
          September 26 12:00am
          New intramural sport where participants climb into a bublle and play, bounce, roll, and enjoy the excitement. Team entry fee is $60. All intramurals participants are required to create an account on IMLeagues.com/iupui. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
        • Competition Pool
          September 26 5:30am
          The competition pool for lap swim is open more »
        • Stress Less with the Cultural Arts Gallery
          September 26 11:00am
          Whether you are worn-out from the weekend or need a few hours to refocus, the Gallery team has prepared a few hours of guided meditation and other stress management activities for you to enjoy. Co-sponsored by the Counseling & Psychological Services. more »
        • InDesign CC 2015: The Basics
          September 26 1:30pm
          This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals This workshop is intended to be a three-hour hands-on experience. In the context of constructing a basic newsletter, participants of this workshop will manipulate text and graphic objects using a broad r more »
        Monday, September 26, 2016

          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




          • Fall Career Week, September 26-30
            September 26 12:00am
            This week of career events offers something for everyone! Students, faculty, employers, and alumni share career expertise you won't want to miss. Attend sessions to learn more about majors, career paths, job searching, and more. Most events are in the IUPUI Campus Center. Mark your calendars for Fall Career Week 2016: Sep more »
          • Bubble Ball/Knocker Ball
            September 26 12:00am
            New intramural sport where participants climb into a bublle and play, bounce, roll, and enjoy the excitement. Team entry fee is $60. All intramurals participants are required to create an account on IMLeagues.com/iupui. Questions? Contact Matthew Jones - Coordinator of Intramural Sports - 317.278.9939 - mj221@iupui.edu. more »
          • Competition Pool
            September 26 5:30am
            The competition pool for lap swim is open more »
          • Stress Less with the Cultural Arts Gallery
            September 26 11:00am
            Whether you are worn-out from the weekend or need a few hours to refocus, the Gallery team has prepared a few hours of guided meditation and other stress management activities for you to enjoy. Co-sponsored by the Counseling & Psychological Services. more »
          • InDesign CC 2015: The Basics
            September 26 1:30pm
            This workshop lasts 3 hours, and is part of the certificate series Desktop Publishing Fundamentals This workshop is intended to be a three-hour hands-on experience. In the context of constructing a basic newsletter, participants of this workshop will manipulate text and graphic objects using a broad r more »
          Monday, September 26, 2016