Microsoft Office Tutorials and References
In Depth Information
Project — Sharing Data Among Applications
AC 207
fi rst row contains column
headings that convert to
fi eld names in table
data
Item worksheet tab
(a)
Microsoft
Excel
Worksheet
Item table tab
fi eld names
data
(b) Microsoft Access Table
Figure 1
As the fi gures illustrate, the worksheet, shown in Figure 1a, is copied to an Access
table, shown in Figure 1b. The columns in the worksheet become the fi elds. The column
headings in the fi rst row of the worksheet become the fi eld names. The rows of the
worksheet, other than the fi rst row, which contains the labels, become the records in the table.
In the process, each fi eld will be assigned the data type that seems the most reasonable,
given the data currently in the worksheet.
Organizations that currently use Access for their data needs often fi nd that they
need to export the data to other applications. JSP Recruiters has determined that it needs
to make some of the data in its database available to other applications. Some users need
the data in Excel; others want it placed in a Microsoft Word document. Still others want
the ability to receive a report by e-mail.
You can export (copy) data from an Access database so that another application (for
example, Excel) can use the data. Figure 2a on the next page shows the Recruiter-Client
query exported to Excel and Figure 2b on the next page shows the same query exported
to Word.
At times you may want to send a report to a user by e-mail. It would be prohibitive
to send the whole database to the other user, just so the user could print or view the report.
In addition, doing so would require the other user to have Microsoft Access installed. A
Search JabSto ::




Custom Search