Section outline

  • Computer Lab: Filtering by form, queries, reports, and importing data

    Filtering by form. Writing select queries and reports for monitoring study progress. Importing data and appending and updating records.

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

    Location:      CB 6702/CB 6704

    • Assignment: Optional narrative description

    • Lab 2 Instructions File

    • Assignment Due Date:  Make sure that you send the completed "Treasure Hunt" worksheet and both of the rtf files, “LastnameCountsByRace1.rtf” made prior to importing the new 2007 records and “LastnameCountsByRace2.rtf” made after importing the new records, to ucsfdbclass@yahoo.com as email attachments by 8/15/2014 at midnight.

    • Datasets:

    • Infant Jandice DB for Lab 2 File
    • Baby2012-13.xlsx File