Transcript Access Web Feature

Microsoft
Office 2003
Introductory Concepts
and Techniques
Access Web Feature
Sharing Data among
Applications
Objectives
•
•
•
•
Import or link an Excel worksheet
Export data to Excel and Word
Create report snapshots
Export and import XML data
Access Web Feature: Sharing Data among Applications
2
Creating a New Database
• Click the Start button on the Windows taskbar, click All
Programs on the Start menu, point to Microsoft Office on
the All Programs submenu, and then click Microsoft
Office Access 2003 on the Microsoft Office submenu
• Click the New button on the Database toolbar, and then
click Blank database in the New area of the New File
task pane
• Click the Save in box arrow in the File New Database
dialog box and then click USB flash drive
• Erase the current entry in the File name text box, type
Harton-Janes Clinic as the file name, and then
click the Create button
Access Web Feature: Sharing Data among Applications
3
Importing an Excel Worksheet
• With the Harton-Janes Clinic database open,
right-click in the open area of the Database
window
• Click Import
• When Access displays the Import dialog box,
click the Files of type box arrow and then click
Microsoft Excel
• If necessary, select USB flash drive in the Look
in list
• Make sure the Patient workbook is selected, and
then click the Import button
Access Web Feature: Sharing Data among Applications
4
Importing an Excel Worksheet
• When Access displays the Import Spreadsheet
Wizard dialog box, if necessary, click Show
Worksheets and then click the Next button
• Be sure the Patient worksheet is selected, and
then click the Next button
• If necessary, click First Row Contains Column
Headings to select it
• Click the Next button
• If necessary, click In a New Table to select it and
then click the Next button
Access Web Feature: Sharing Data among Applications
5
Importing an Excel Worksheet
• Because the Field Options need not be
specified, click the Next button
• Click Choose my own primary key
• Because the Patient Number field, which is the
current field, is already selected as the primary
key, click the Next button.
• Be sure the Patient appears in the Import to
Table text box
• Click the Finish button. Click the OK button
Access Web Feature: Sharing Data among Applications
6
Importing an Excel Worksheet
Access Web Feature: Sharing Data among Applications
7
Closing a Database
• Click the Close button for the HartonJanes Clinic : Database window
Access Web Feature: Sharing Data among Applications
8
Opening a Database
• Click the Open button on the Database
toolbar
• If necessary, click USB flash drive in the
Look in box. Click the Ashton James
College database name
• Click the Open button in the Open dialog
box. If a Security Warning dialog box
appears, click Open
Access Web Feature: Sharing Data among Applications
9
Using the Export Command
to Export Data to Excel
• Click Queries on the Objects bar, and then rightclick Client-Trainer Query
• Click Export
• If necessary, click the Save in box arrow and
then click USB flash drive
• Click the Save as type box arrow, and then click
Microsoft Excel 97-2003 in the Save as type list
• Be sure the file name is Client-Trainer Query,
and then click the Export button
Access Web Feature: Sharing Data among Applications
10
Using the Export Command
to Export Data to Excel
Access Web Feature: Sharing Data among Applications
11
Using Drag-and-Drop
to Export Data to Word
• Click the Start button on the Windows taskbar,
click All Programs on the Start menu, point to
Microsoft Office on the All Programs submenu,
and then click Microsoft Office Word 2003 on the
Microsoft Office submenu
• Close the Getting Started task pane
• Click the Microsoft Access button on the taskbar
to return to Microsoft Access
• Click the Restore Down button or resize the
Access window so the Access window does not
occupy the full screen
Access Web Feature: Sharing Data among Applications
12
Using Drag-and-Drop
to Export Data to Word
• Be sure the Queries object is selected
• Drag the Client-Trainer Query icon to the upperleft corner of the Word document. Do not
release the mouse button
• Release the mouse button and then click the
Save button on the Standard toolbar in Microsoft
Word
• Type Client-Trainer Query in the File
name text box, and then click the Save button in
the Save As dialog box
Access Web Feature: Sharing Data among Applications
13
Using Drag-and-Drop
to Export Data to Word
• Click in the Word window to deselect the
table
• Quit Word by clicking its Close button
• Maximize the Microsoft Office Access
window by double-clicking its title bar
Access Web Feature: Sharing Data among Applications
14
Using the Export Command
to Create a Snapshot
• If the Microsoft Access Database window is not
maximized, maximize the window by doubleclicking its title bar
• Click the Reports object, right-click the Client
Amount Report, and then click Print Preview on
the shortcut menu
• Right-click the preview of the report
• Click Export
• If necessary, click the Save in box arrow and
then click USB flash drive
Access Web Feature: Sharing Data among Applications
15
Using the Export Command
to Create a Snapshot
• Click the Save as type box arrow, select
Snapshot Format, be sure the Autostart check
box is checked, and then click the Export button
• If a Microsoft Office Access dialog box is
displayed asking if you want to install Snapshot
Viewer, click the No button and see your
instructor
• Click the Close button on the Print Preview
toolbar
• Click the C button for the Snapshot Viewer –
[Client Amount Report] window
Access Web Feature: Sharing Data among Applications
16
Using the Export Command
to Create a Snapshot
Access Web Feature: Sharing Data among Applications
17
Exporting XML Data
• Click the Tables object, and then right-click
Client
• Click Export on the shortcut menu
• Click the Save as type box arrow, scroll
down, and then click XML in the list
• If necessary, select USB flash drive in the
Save in list
• Click the Export button
Access Web Feature: Sharing Data among Applications
18
Exporting XML Data
• Click the More Options button
• Click the expand indicator (the plus sign)
to the left of [Lookup Data], and then click
the Trainer check box to select the Trainer
table
• Click the OK button
• Click the Close button for the Microsoft
Access [Ashton James College : Database
(Access 2000 file format)] window
Access Web Feature: Sharing Data among Applications
19
Exporting XML Data
Access Web Feature: Sharing Data among Applications
20
Creating a New Database
• Click the New button on the Database
toolbar, and then click Blank database in
the New area of the New File task pane
• If necessary, click the Save in box arrow in
the File New Database dialog box and
then click USB flash drive
• Type AJ Consulting in the File name
text box and then click the Create button
Access Web Feature: Sharing Data among Applications
21
Importing XML Data
• Right-click in the Database window
• Click Import on the shortcut menu
• Click the Files of type box arrow, scroll down,
and then click XML in the list
• If necessary, select USB flash drive in the Look
in list
• Click the Client file (Do not click the xsd version.
If you do, you will import both tables, but none of
the data. That is, the tables will be empty)
Access Web Feature: Sharing Data among Applications
22
Importing XML Data
• Click the Import button
• Click the OK button
• Click the OK button
Access Web Feature: Sharing Data among Applications
23
Importing XML Data
Access Web Feature: Sharing Data among Applications
24
Closing the Database
and Quitting Access
• Click the Close Window button for the AJ
Consulting : Database window
• Click the Close button for the Microsoft
Access window
Access Web Feature: Sharing Data among Applications
25
Summary
•
•
•
•
Import or link an Excel worksheet
Export data to Excel and Word
Create report snapshots
Export and import XML data
Access Web Feature: Sharing Data among Applications
26
Microsoft
Office 2003
Introductory Concepts
and Techniques
Access Web Feature
Complete