Introduction:
One simple application of an Access database is an address book. In this activity you will be creating the structure, adding the data and retrieving information from your address book. Make sure you create the database matching exactly what you see in the images that follow.
Procedure:
Create the Database:
- Open access and create a blank database
- Save as: last first address book in your thawspace
Create the table:
- Select the table tab (it should default to this)
- Create the table in "Design View"
- Match the fields and data types exactly as you see in the image below:
- Once you have completed this, save the table as: last first data
Entering Data:
To enter data you must switch from "Design View" to "Datasheet View". To do this you must select the button in the upper left portion of the tool bar. See the image below to find this "button".
Once you have selected the "button", you will be able to enter data. Enter the following information. Please match exactly
Doug Adkins
- 2373 Kuebler Rd S
- Salem Or, 97302
- 503-399-3261
- dadkins@hotmail.com
- Computer Teacher
Steve Adkins
- 123 9th St.
- Corvallis Or, 97330
- 541-745-1234
- sadkins@hotmail.com
- Lawyer
Jean Lorenz
- 2373 Kuebler Rd S
- Salem Or, 97302
- 503-399-3261
- lorez_jean@salkeiz.k12.or.us
- Math teacher
George Lindholdt
- 2373 Kuebler Rd S
- Salem Or, 97302
- 503-399-3261
- lindholdt_george@salkeiz.k12.or.us
- Teacher
Doug Livermore
- 2373 Kuebler Rd S
- Salem Or, 97302
- 503-399-3261
- livermore_doug@salkeiz.k12.or.us
- Teacher
Entering Your Own Data
- Add 5 more entries of your choice
- The data can be faked (if you want)
- Make sure the data is realisitic or it will cause you problems later
- Make sure the information is appropriate because this data may be shared with other students
- Lastly, make sure you use a "friend" comment somewhere in your data (see query #6 below)
Queries and Reports
Build the following queries and a report for each query:
- Query #1 Use Fields:
- First Name, Last Name, City
- Sort by Last Name in ascending order
- Query #2 same as query #1
- Limit the data (using the criteria option) to City = "Corvallis"
- Query #3
- Show all fields
- Sort by Zip Code
- Show records where last name begins with "L"
- Query #4 Use fields:
- Last, First, Email
- Sort by last name
- Return only "hotmail" addresses
- Query #5 Use fields
- Last, First, Phone, Comment
- Sort by last name
- Return all teachers
- Query #6 Use Fields:
- First, Last, Email, Comment
- Sort by Last Name
- Return all your "friends"
- **If you don't have a "friend" comment, add one to a record**
- **This query/report should not come up blank when grading**
Grading:
Select this link to see the grading process
