Tuesday, April 26, 2011

Access Activity One

You are going to make a database titled Computer Applications Class. You will create a table in design view. You are to go around to 10 of your classmates and get the following information:

1. First Name
2. Last Name
3. Address
4. City
5. State
6. Zip Code
7. Phone Number
8. Birthday

After you collect that information, you will create a table in design view using those fields. You will then save the table as “Classmates.”  The phone number will be your primary key. You will type all the information that you gathered from your classmates  into the table.

Access Activity Two

You are going to make a database of books that you have read. The database will be titled Books. You will list the names of 10 books that you have read in your lifetime. You will make a table in design view using the following information as fields:

1. Name of book
2. Author first name
3. Author last name
4. Copyright
5. ISBN Number

You will go to the internet to find the information. Amazon.com would be a useful website. You will type in the information into your table and save the table as books. The ISBN number will be the primary key.