Microsoft Office Tutorials and References
In Depth Information
Case Problems
Use your skills
to create and
modify tables
for a recycling
agency.
Case Problem 3
Data Files needed for this Case Problem: Agency.txt, Rossi.accdb ( cont. from
Tutorial 1 ), Gifts.xlsx, and Recycle.accdb
Rossi Recycling Group Tom Rossi uses the Rossi database to maintain information
about the donors, agencies, and donations to his not-for-profi t agency. Tom asks you
to help him maintain the database by updating one table and creating two new ones.
Complete the following steps:
1. Open the Rossi database, which you created and stored in the Access1\Case3 folder
in Tutorial 1.
2. Open the Donor table in Design view, and change the following fi eld properties:
a. DonorID: Enter Primary key for the description, change the fi eld size to , and 5
enter Donor ID for the caption.
b. Title: Change the fi eld size to .
c. FirstName: Change the fi eld size to and enter First Name for the caption. 20
d. LastName: Change the fi eld size to and enter Last Name for the caption. 25
e. Phone: Change the fi eld size to 14.
3. Save and close the Donor table. Click the Yes button when a message appears
indicating some data might be lost.
4. Tom created a table named Agency in the Recycle database that is located in the
Access1\Case3 folder provided with your Data Files. Import the structure of the
Agency table in the Recycle database into a new table named Agency in the Rossi
database. Do not save the import steps.
5. Open the Agency table in Datasheet view, and then delete the following fi elds from
the table: Fax Number, Mobile Phone, and Notes.
6. Rename the ID fi eld to AgencyID , and change its data type to Text.
7. Use the Address Quick Start selection in the Data Type gallery to add fi ve fi elds
between the First Name and Phone fi elds. ( Hint: Be sure to make the Phone fi eld the
active fi eld before adding the new fi elds.)
8. Switch to Design view, and then modify the Agency table so that it matches the
design shown in Figure 2-53, including the fi eld names and their order. Make
sure the AgencyID fi eld is specifi ed as the primary key. Also, be sure to delete the
CountryRegion fi eld from the table, and delete the Caption property values for the
fi elds added with the Address Quick Start selection.
Figure 2-53
Design for the Agency table
Field Name
Data Type
Description
Field Size
Other
AgencyID
Text
Primary key
3
Caption = Agency ID
Agency
Text
40
Caption = Agency Name
FirstName
Text
20
Caption = Contact First Name
LastName
Text
25
Caption = Contact Last Name
Address
Text
30
City
Text
24
State
Text
2
Zip
Text
10
Phone
Text
14
9. Save your changes to the table design, add the records shown in Figure 2-54 to the
Agency table, and then close the Agency table.
 
Search JabSto ::




Custom Search