Microsoft Office Tutorials and References
In Depth Information
Case Problems
Figure 2-54
Records for the Agency table
Contact
Contact
Agency ID Agency Name
First Name Last Name
Address
City
State
Zip
Phone
K64
Community Development Jerri
Clarkson
223 Penn Ave
Salina
KS
67401
785-309-3351
K82
SeniorCare Program
Todd
Groverman
718 N Walnut
McPherson
KS
67460
620-241-3668
10. Tom exported the agency data that he was maintaining in another computer system
to a text fi le, and he asks you to add this data to the Agency table. The data you need
to import is contained in the Agency text fi le (located in the Access1\Case3 folder
provided with your Data Files).
a. Specify the Agency text fi le as the source of the data.
b. Select the option for appending the data to the table.
c. Select Agency as the table.
d. In the Import Text Wizard dialog boxes, choose the options to import delimited
data, to use a comma delimiter, and to import the data into the Agency table. Do
not save the import steps.
11. Resize columns in the Agency datasheet to their best fi t (as necessary), and then save
and close the table.
12. Use Design view to create a table using the table design shown in Figure 2-55.
Figure 2-55
Design for the Donation table
Field Name
Data Type
Description
Field Size
Other
DonationID
Text
Primary key
4
Caption = Donation ID
DonorID
Text
Foreign key
5
Caption = Donor ID
AgencyID
Text
Foreign key
3
Caption = Agency ID
DonationDate
Date/Time
Format = Short Date
Caption = Donation Date
Description
Text
50
Caption = Donation Description
DonationValue
Currency
Cash amount donated
Format = Currency
or estimated value of
Decimal Places = 2
goods donated
Caption = Donation Value
Pickup
Yes/No
Caption = Pickup Required
Format = Yes/No
13. Specify DonationID as the primary key, save the table as Donation , and then close
the table.
14. Use the Import Spreadsheet Wizard to add data to the Donation table. The data you
need to import is contained in the Gifts workbook, which is an Excel fi le located in
the Access1\Case3 folder provided with your Data Files.
a. Specify the Gifts workbook as the source of the data.
b. Select the option for appending the data to the table.
c. Select Donation as the table.
d. In the Import Spreadsheet Wizard dialog boxes, choose the Sheet1 worksheet,
make sure Access confi rms that the fi rst row contains column headings, and
import to the Donation table. Do not save the import steps.
15. Open the Donation table, and add the records shown in Figure 2-56. ( Hint : Use the
New button in the Records group on the Home tab to add a new record.)
Search JabSto ::




Custom Search