Section outline

  • Computer Lab: Access: creating tables, relationships, and data entry forms

    Creating a table in design or “data dictionary” view. Field names, types, and descriptions; validation rules, primary and foreign keys, lookup tables, and relationships between tables. Creating data entry forms/subforms.

    Faculty:  Michael Kohn, Valerie French, Amy Gelfand, Susan Lee, Meghan McGarry, Varun Saxena, Frederick Wang

    Location:      CB 6702/CB 6704

    • Optional Reading:

    • Assignment:

      Complete Lab 1 on creating tables, relationships, and data entry forms in Access.

    • Epi 218 Lab 1 Instructions File
    • Data Collection Forms for Lab 1 File

    • Assignment Due Date:  Email the completed Access mdb or accdb file, LASTNAMElab1.mdb or LASTNAMElab1.accdb, to ucsfdbclass@yahoo.com by 8/7/2014 at midnight.