Worksheet: Downloading, E-mail attachments, and Introduction
to Databases using MS-Access (Homework Version)
Prerequisites for this Worksheet:
You should be able to navigate your way around a PC with MS Office. In addition,
this worksheet assumes that you have completed the Worksheet on downloading
files. In addition, this worksheet assumes that you have worked through the
in class version of this worksheet.
Assignment:
- An Excel spreadsheet entitled “wage_for_access.xls” has been uploaded
on the website in Rockefeller College. This spreadsheet is a fictitious employment
data for faculty in GSPA. Download this
Excel Spreadsheet from the website, using Netscape Navigator, Internet
Explorer, or any other browser you are familiar with.
- Import the Excel Spreadsheet into an MS Access database. Next using
the report Wizard in Access, generate a table of output from the database
that looks like the this linked report
. Export the report from Access as a word processing document in Rich Text
Format (RFT) Refer to the Access Guide
as needed.
- Attach the word processing version of the report to an e-mail message
and mail it to the course TA.
Discussion:
This worksheet is designed to give you additional practice in moving and
formatting files. Please see the previous
version of this worksheet for more information on how to complete this
worksheet.