• Assessment 1 - Create Tables in a Cornerstone Catering Database
  • Pages 137-139
  • File needed - Create file and folder yourself
    • CSCI20 - 04AccessLevel1 - Access2007L1U1 - Cornerstone.accdb
  • Create the following tables:
    • Employee
      • Enter data
      • Enter yourself as Employee #: 1
      • Automatically adjust column widths
      • Save, print, write your name on the printout
    • Plans
      • Enter data
      • Automatically adjust column widths
      • Save, print, write your name on the printout
    • Prices
      • Enter data
      • Automatically adjust column widths
      • Save, print, write your name on the printout
    • Clients
      • Enter data
      • Automatically adjust column widths
      • Save, print, write your name on the printout
    • Events
      • Enter data
      • Automatically adjust column widths
      • Save, print, write your name on the printout
        
• Assessment 2 - Create Relationships Between Tables
  • Page 140
  • File needed - Cornerstone.accdb from Assessment 1
  • Create a one-to-many relationship between the Client# in the Clients table and the Client# in the Events table
  • Create a one-to-many relationship between the Employee# in the Employees table and the Employee# in the Events table
  • Create a one-to-many relationship between the PlanCode in the Plans table and the PlanCode in the Events table
  • Create a one-to-many relationship between the PriceCode in the Prices table and the PriceCode in the Events table
  • Save, print, write your name on the printout

Helpful Hints:

• Make sure you save your work with the proper file name
• Make sure you have your full name on each document
• Recheck the instructions to make sure you completed each step
• Print all documents, 3-hole punch, staple together, and turn in to the instructor

Please send any comments or questions about this site to David Donica.
© 2008 College of the Siskiyous. All rights reserved.