Week 2 Assignment: Relational Database Tables
Assignment Prompt:
Watch the five videos in the Reading & Resources section under Content in week 2 bin. This week you will be creating two new databases in Access (this assignment does not use the Excel databases you downloaded in week 1).
Complete instructions are listed below for how to create your two new “Contacts” databases inside of Access. As this file will go no further than your instructor if you want to complete these two databases with family, friends, coworkers, business, and social contacts, you are free to do so. A great source for all of this information is in your Cell phone. Likewise, if you are uncomfortable with using real contacts, you may make some up (Mickey Mouse, Donald Duck, Frank Zappa, Paul McCartney, Elvis Presley, etc.). The two databases you are creating this week will be used in the next assignment, so, take care of developing and complete them as accurately as possible.
Assignment Instructions:
Complete the databases in one Access file that you will submit below as your homework for week 2.
The work you do this week may look like a lot of busywork, however this database, once completed, will be used in two future classes (week 3 and week 5) where you build queries, forms, and reports.
Create your own personal database of contacts (individual and Company). Your Cell phone or contacts database in your personal email software is an excellent source for the data you will need for this assignment.
If you would like to review how to create forms you can also use this hyperlink: Access Forms Transcript can be accessed on video host site.
Include a minimum of 35 contacts, more would be better. Use at least 10 organizations, businesses, or service provider company contacts, again more would be better
