• Get Ahead and Stay Ahead: Breaking through with Problem People at Work
    May 25 12:00am
    This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
  • Installing and Configuring Windows Server 2012 (MOC 20410)
    May 25 9:00am
    This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
  • Installing and Configuring Windows Server 2012 (MOC 20410)
    May 25 9:00am
    This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
  • Excel 2013: Charts & Graphics
    May 25 1:30pm
    This session is being delivered in room IT 121 at IUPUI, and simultaneously being offered online. This is the face-to-face session, so please register for this session only if you plan to attend in person. This workshop lasts 3 hours, more »
  • Excel 2013: Charts & Graphics
    May 25 1:30pm
    This session is being delivered online and simultaneously in IT 121 at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. This workshop lasts 3 hours, and is part of the certifi more »
Wednesday, May 25, 2016
    IU Calendar




    • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
      May 25 12:00am
      This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
    • Installing and Configuring Windows Server 2012 (MOC 20410)
      May 25 9:00am
      This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
    • Installing and Configuring Windows Server 2012 (MOC 20410)
      May 25 9:00am
      This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
    • Excel 2013: Charts & Graphics
      May 25 1:30pm
      This session is being delivered in room IT 121 at IUPUI, and simultaneously being offered online. This is the face-to-face session, so please register for this session only if you plan to attend in person. This workshop lasts 3 hours, more »
    • Excel 2013: Charts & Graphics
      May 25 1:30pm
      This session is being delivered online and simultaneously in IT 121 at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. This workshop lasts 3 hours, and is part of the certifi more »
    Wednesday, May 25, 2016
      IU Calendar




      • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
        May 25 12:00am
        This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
      • Installing and Configuring Windows Server 2012 (MOC 20410)
        May 25 9:00am
        This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
      • Installing and Configuring Windows Server 2012 (MOC 20410)
        May 25 9:00am
        This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
      • Excel 2013: Charts & Graphics
        May 25 1:30pm
        This session is being delivered in room IT 121 at IUPUI, and simultaneously being offered online. This is the face-to-face session, so please register for this session only if you plan to attend in person. This workshop lasts 3 hours, more »
      • Excel 2013: Charts & Graphics
        May 25 1:30pm
        This session is being delivered online and simultaneously in IT 121 at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. This workshop lasts 3 hours, and is part of the certifi more »
      Wednesday, May 25, 2016
        IU Calendar




        • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
          May 25 12:00am
          This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
        • Installing and Configuring Windows Server 2012 (MOC 20410)
          May 25 9:00am
          This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
        • Installing and Configuring Windows Server 2012 (MOC 20410)
          May 25 9:00am
          This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
        • Excel 2013: Charts & Graphics
          May 25 1:30pm
          This session is being delivered in room IT 121 at IUPUI, and simultaneously being offered online. This is the face-to-face session, so please register for this session only if you plan to attend in person. This workshop lasts 3 hours, more »
        • Excel 2013: Charts & Graphics
          May 25 1:30pm
          This session is being delivered online and simultaneously in IT 121 at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. This workshop lasts 3 hours, and is part of the certifi more »
        Wednesday, May 25, 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




          • Get Ahead and Stay Ahead: Breaking through with Problem People at Work
            May 25 12:00am
            This workshop lasts 4 weeks. If you do not have an IU account, just create an IU guest account that you can use to register. The IU Alumni Association has teamed up with Nora Simpson of Get Ahead and Stay Ahead to bring you this special four-week online course, designed to h more »
          • Installing and Configuring Windows Server 2012 (MOC 20410)
            May 25 9:00am
            This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
          • Installing and Configuring Windows Server 2012 (MOC 20410)
            May 25 9:00am
            This workshop lasts 5 days. The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, more »
          • Excel 2013: Charts & Graphics
            May 25 1:30pm
            This session is being delivered in room IT 121 at IUPUI, and simultaneously being offered online. This is the face-to-face session, so please register for this session only if you plan to attend in person. This workshop lasts 3 hours, more »
          • Excel 2013: Charts & Graphics
            May 25 1:30pm
            This session is being delivered online and simultaneously in IT 121 at IUPUI. This is the online session, so please register for this session only if you plan to attend remotely. This workshop lasts 3 hours, and is part of the certifi more »
          Wednesday, May 25, 2016