In Access:

Your assignment is to create a table to hold information about your friends and relatives. You should assign each person an identification number. Then you should decide what information you want to include on the table. Along with any other information you decide to keep, you must include the following data:

• Identification number
• Name
• Their relationship to you (mother, father, friend etc)
• The state they live in
• Their occupation
• Year of birth

Create the structure of the table and then populate the table with data, but first look at the queries below to make sure you populate the table with data that will test the queries. By test the queries, I want you to enter data so that when you do the queries it will select some people and not select others and will truly test the validity of the query.

Queries:

• Show all people who live in MA and have an have a relationship of friend
• Show all people who live in MA or RI
• Show all people that have an occupation of student and either live in MA or RI
• Show all people that live in MA and have a year birth > 1980 or that live in RI
• Show all people that live in RI or live in MA and do not have an occupation of student

Remember in designing the table, you should consider the following:

• Field names should not contain embedded spaces or special characters
• Fields should be an appropriate size and type
• The primary key should be data you enter, not the automatic number

Using the form wizard and the report wizard, create a form and a report that go with your table.