Microsoft Office Tutorials and References
In Depth Information
Project — Sharing Data Among Applications
ﬁ rst row contains column
headings that convert to
ﬁ eld names in table
Item worksheet tab
Item table tab
ﬁ eld names
(b) Microsoft Access Table
As the ﬁ 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 ﬁ elds. The column
headings in the ﬁ rst row of the worksheet become the ﬁ eld names. The rows of the
worksheet, other than the ﬁ rst row, which contains the labels, become the records in the table.
In the process, each ﬁ 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 ﬁ 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
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