• CLOSED - Memorial Day
    May 29 12:00am
    Closed more »
  • Competition Pool
    May 30 5:30am
    Lap Swim more »
  • Instructional Pool
    May 30 7:00am
    Lap Swim  more »
  • Access 2016: Structuring & Relating Data
    May 30 9:00am
    This workshop lasts 3 hours, and is part of the certificate series Access 2016 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 ba more »
  • Competition Pool
    May 30 9:00am
    Lap Swim more »
Monday, May 29, 2017
    IU Calendar




    • CLOSED - Memorial Day
      May 29 12:00am
      Closed more »
    • Competition Pool
      May 30 5:30am
      Lap Swim more »
    • Instructional Pool
      May 30 7:00am
      Lap Swim  more »
    • Access 2016: Structuring & Relating Data
      May 30 9:00am
      This workshop lasts 3 hours, and is part of the certificate series Access 2016 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 ba more »
    • Competition Pool
      May 30 9:00am
      Lap Swim more »
    Monday, May 29, 2017
      IU Calendar




      • CLOSED - Memorial Day
        May 29 12:00am
        Closed more »
      • Competition Pool
        May 30 5:30am
        Lap Swim more »
      • Instructional Pool
        May 30 7:00am
        Lap Swim  more »
      • Access 2016: Structuring & Relating Data
        May 30 9:00am
        This workshop lasts 3 hours, and is part of the certificate series Access 2016 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 ba more »
      • Competition Pool
        May 30 9:00am
        Lap Swim more »
      Monday, May 29, 2017
        IU Calendar




        • CLOSED - Memorial Day
          May 29 12:00am
          Closed more »
        • Competition Pool
          May 30 5:30am
          Lap Swim more »
        • Instructional Pool
          May 30 7:00am
          Lap Swim  more »
        • Access 2016: Structuring & Relating Data
          May 30 9:00am
          This workshop lasts 3 hours, and is part of the certificate series Access 2016 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 ba more »
        • Competition Pool
          May 30 9:00am
          Lap Swim more »
        Monday, May 29, 2017

          About This Event

          Summary

          This workshop lasts 3 hours. This workshop introduces experienced Access users to issues relating to database design and the packaging of completed databases for distribution to end users. The workshop begins with an extensive lecture and discussion section on database modeling, then proceeds into a series of hands-on exercises to implement the database design and create a usable application for end users. Also provides a brief introduction to database security considerations.     What You'll learn Available Downloads

          • define database needs

          • use business rules in database design

          • model a database before creating it

          • normalize imported flat file data into separate tables

          • create and maintain complex table relationships

          • package and password protect a database

          • compact a database

          What you need to know

          • Understand database relationships

          • Create and edit relational forms and reports

          • Create a form-based application

          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 - Memorial Day
            May 29 12:00am
            Closed more »
          • Competition Pool
            May 30 5:30am
            Lap Swim more »
          • Instructional Pool
            May 30 7:00am
            Lap Swim  more »
          • Access 2016: Structuring & Relating Data
            May 30 9:00am
            This workshop lasts 3 hours, and is part of the certificate series Access 2016 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 ba more »
          • Competition Pool
            May 30 9:00am
            Lap Swim more »
          Monday, May 29, 2017