• Nanotechnology Experiences for Students and Teachers
    June 22 8:45am
    High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
  • Competition Pool
    June 22 9:00am
    lap swim more »
  • Engineering Technology Recruitment - High School Interns
    June 22 10:00am
    The School of Engineering and Technology will be hosting approximately 260 high school junior and senior students who have been interning at various manufacturing companies in Indiana.  They will attend information sessions regarding engineering technology fields of study and careers, all while becoming familiar with a college campus settin more »
  • SQL: Data Retrieval
    June 22 1:30pm
    This workshop lasts 3.5 hours. Relational databases and the data they store are increasingly at the core of how we understand our world and make decisions in it. SQL (Structured Query Language) is the standard programming language used for querying databases and answering questions about the data in databases. Mo more »
  • Patients, Families, and Medical Decision Making
    June 22 6:00pm
    How do religious beliefs influence major decisions, especially at the beginning and end of life?  How to chaplains and others provide spiritual support and/or guidance to patients and families in the healthcare setting? Guest Speaker: Beth Newton Watson, MDiv, BCC, is Director of Spiritual Care and Chaplaincy Services at IU Health more »
Thursday, June 22, 2017
    IU Calendar




    • Nanotechnology Experiences for Students and Teachers
      June 22 8:45am
      High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
    • Competition Pool
      June 22 9:00am
      lap swim more »
    • Engineering Technology Recruitment - High School Interns
      June 22 10:00am
      The School of Engineering and Technology will be hosting approximately 260 high school junior and senior students who have been interning at various manufacturing companies in Indiana.  They will attend information sessions regarding engineering technology fields of study and careers, all while becoming familiar with a college campus settin more »
    • SQL: Data Retrieval
      June 22 1:30pm
      This workshop lasts 3.5 hours. Relational databases and the data they store are increasingly at the core of how we understand our world and make decisions in it. SQL (Structured Query Language) is the standard programming language used for querying databases and answering questions about the data in databases. Mo more »
    • Patients, Families, and Medical Decision Making
      June 22 6:00pm
      How do religious beliefs influence major decisions, especially at the beginning and end of life?  How to chaplains and others provide spiritual support and/or guidance to patients and families in the healthcare setting? Guest Speaker: Beth Newton Watson, MDiv, BCC, is Director of Spiritual Care and Chaplaincy Services at IU Health more »
    Thursday, June 22, 2017
      IU Calendar




      • Nanotechnology Experiences for Students and Teachers
        June 22 8:45am
        High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
      • Competition Pool
        June 22 9:00am
        lap swim more »
      • Engineering Technology Recruitment - High School Interns
        June 22 10:00am
        The School of Engineering and Technology will be hosting approximately 260 high school junior and senior students who have been interning at various manufacturing companies in Indiana.  They will attend information sessions regarding engineering technology fields of study and careers, all while becoming familiar with a college campus settin more »
      • SQL: Data Retrieval
        June 22 1:30pm
        This workshop lasts 3.5 hours. Relational databases and the data they store are increasingly at the core of how we understand our world and make decisions in it. SQL (Structured Query Language) is the standard programming language used for querying databases and answering questions about the data in databases. Mo more »
      • Patients, Families, and Medical Decision Making
        June 22 6:00pm
        How do religious beliefs influence major decisions, especially at the beginning and end of life?  How to chaplains and others provide spiritual support and/or guidance to patients and families in the healthcare setting? Guest Speaker: Beth Newton Watson, MDiv, BCC, is Director of Spiritual Care and Chaplaincy Services at IU Health more »
      Thursday, June 22, 2017
        IU Calendar




        • Nanotechnology Experiences for Students and Teachers
          June 22 8:45am
          High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
        • Competition Pool
          June 22 9:00am
          lap swim more »
        • Engineering Technology Recruitment - High School Interns
          June 22 10:00am
          The School of Engineering and Technology will be hosting approximately 260 high school junior and senior students who have been interning at various manufacturing companies in Indiana.  They will attend information sessions regarding engineering technology fields of study and careers, all while becoming familiar with a college campus settin more »
        • SQL: Data Retrieval
          June 22 1:30pm
          This workshop lasts 3.5 hours. Relational databases and the data they store are increasingly at the core of how we understand our world and make decisions in it. SQL (Structured Query Language) is the standard programming language used for querying databases and answering questions about the data in databases. Mo more »
        • Patients, Families, and Medical Decision Making
          June 22 6:00pm
          How do religious beliefs influence major decisions, especially at the beginning and end of life?  How to chaplains and others provide spiritual support and/or guidance to patients and families in the healthcare setting? Guest Speaker: Beth Newton Watson, MDiv, BCC, is Director of Spiritual Care and Chaplaincy Services at IU Health more »
        Thursday, June 22, 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




          • Nanotechnology Experiences for Students and Teachers
            June 22 8:45am
            High School students, grades 9-12, come for 2 weeks of programming that explore the interdisciplinary field of nanotechnology.  This cutting-edge field is rapidly becoming an essential part of science, engineering, medicine, and many other disciplines.  They will earn a college credit hour in Engineering & Technology and/or Sc more »
          • Competition Pool
            June 22 9:00am
            lap swim more »
          • Engineering Technology Recruitment - High School Interns
            June 22 10:00am
            The School of Engineering and Technology will be hosting approximately 260 high school junior and senior students who have been interning at various manufacturing companies in Indiana.  They will attend information sessions regarding engineering technology fields of study and careers, all while becoming familiar with a college campus settin more »
          • SQL: Data Retrieval
            June 22 1:30pm
            This workshop lasts 3.5 hours. Relational databases and the data they store are increasingly at the core of how we understand our world and make decisions in it. SQL (Structured Query Language) is the standard programming language used for querying databases and answering questions about the data in databases. Mo more »
          • Patients, Families, and Medical Decision Making
            June 22 6:00pm
            How do religious beliefs influence major decisions, especially at the beginning and end of life?  How to chaplains and others provide spiritual support and/or guidance to patients and families in the healthcare setting? Guest Speaker: Beth Newton Watson, MDiv, BCC, is Director of Spiritual Care and Chaplaincy Services at IU Health more »
          Thursday, June 22, 2017