Access Web Feature - Microsoft Office - Lecture Slides, Slides of MS Microsoft Office skills

Download Access Web Feature - Microsoft Office - Lecture Slides and more Slides MS Microsoft Office skills in PDF only on Docsity!

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

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 3½ Floppy (A:) in the Look in list
• Make sure the Patient workbook is selected, and then click the Import button

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

Importing an Excel Worksheet

Closing a Database

• Click the Close button for the Harton-Janes Clinic : Database window

Using the Export Command

to Export Data to Excel

• Click Queries on the Objects bar, and then right- click Client-Trainer Query
• Click Export
• If necessary, click the Save in box arrow and then click 3½ Floppy (A:)
• 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

Using the Export Command

to Export Data to Excel

Using Drag-and-Drop

to Export Data to Word

• Be sure the Queries object is selected
• Drag the Client-Trainer Query icon to the upper-left 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

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

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

Using the Export Command

to Create a Snapshot

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

Exporting XML Data