Access Lesson #2

Objective: students will be able to create a second table using the table wizard.

  1. Start>programs>Access>open an existing database>OK>file name: dbSurvey.mdb>open
  2. Table>new>table wizard
  3. Business>customers>Company Name
  4. Business>customer>Billing Address>rename field>Address
  5. Business>customers>City
  6. What do you want to name your table?>tblRestaurants
  7. Do you want the wizard to set a primary key for you?>yes, set a primary key for me.>next
  8. Relationships>one record in the tblRestaurants will match many records in the tblCustomers>OK>next
  9. Enter data directly into the table>finish
  10. Close>save>yes>tblcustomers>it: drive>your name>database folder>save
  11. Tools>Relationships>Show All
  12. Right Click>table design>tblRestaurantsID>rename>Restaurant ID
  13. Drag Restaurants ID from tblRestaurants to Restaurants ID from the tblCustomers
  14. Check Enforce Referential Integrity
  15. Join Type>click #2>OK
  16. Close>save>yes

Copyright@2000(K. Kim). All Rights Reserved

Hosted by www.Geocities.ws

1