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

Here are some tutorials on MS office. Explaining excel and other features. This tutorial includes: Access Web Feature, Import or Link an Excel Worksheet, Export Data to Excel and Word, Create Report Snapshots, Export and Import Xml Data, Closing a Database

Typology: Slides

2013/2014

Uploaded on 01/29/2014

jamil
jamil 🇮🇳

4

(12)

139 documents

1 / 27

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Access Web Feature
Sharing Data among Applications
docsity.com
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b

Partial preview of the text

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