Microsoft Office Tutorials and References
In Depth Information
Importing and Exporting Your Excel Content
Excel Charts. It’s easy to share an Excel
chart with a PowerPoint presentation or a
Word document. Select the chart you’ve
made in Excel, and copy it to the Clipboard.
Then go to the slide where you want it to
appear in your PowerPoint presentation
(or the page in your Word document),
and paste it. If you edit the data in
Excel—the data that was used to make
the Excel chart, that is—you’ll see it
update not only the Excel chart but the
pasted version in PowerPoint or Word.
This is a great example of how this
compatibility within the Office suite creates
consistency—even if nobody will ever see
the underlying Excel data that you
painstakingly built into your workbook,
they will see it through the parts of it
used in the report you made in Word and
the slide show you created in PowerPoint.
Access is a very rich, robust database
application. If you’re not already
Accesssavvy, it’s a good idea to learn more
about the application before attempting
to use it build a database, which consists
of more than just a single table that you
bring in from an Excel worksheet. Access
requires, for example, unique fields to
facilitate some of its functionality. Note
the ID field automatically created in
Figure 14-35, for example. The copied Excel
data (Figure 14-34) did not contain this
field, but Access created it anyway, to
satisfy its own need for a field containing
unique records.
Using Access Tables and
Excel Worksheets Together
Access tables are very much like Excel worksheets.
They consist of a series of columns and rows,
filled with cells containing text and numbers.
The text in an Access table is usually spare, too—
unlike a Word table, that might contain long
paragraphs—because database text is usually
limited to single words, short phrases, or very
simple paragraphs, such as product descriptions
in an inventory database. All this makes Access
and Excel quite compatible, and it’s simple to
take an Access table and bring its content into
an Excel worksheet and to go the other way,
too—taking your Excel lists and populating an
Access table with their records.
To take your Excel worksheet data and build an
Access table, follow these steps:
1. Open your Excel worksheet and select the
range of cells you want to add to the Access
table. If you’re planning to create a new
Access table from the cells (as opposed to
adding records to an existing table), be sure
to select the headings, too, as shown in
Figure 14-33.
2. Right-click the selected cells and choose
Copy from the pop-up menu.
Search JabSto ::

Custom Search