Objective 4. Copy Access Data into a Word Document

Table of content

Table of contents:

Activity 1.4. Copying Access Data to a Word Document

Copy and Paste are Windows tools. In this activity you will use them to add data from an Access database to a Word document.

1.	Start Word. Open the Word file Meeting_Topics.doc from the folder that contains your project files. Save the file as Meeting_Topics_Firstname_Lastname
	[Page 1350]
2.	On the taskbar, click the button to return to the Access file, Dept_Data.
3.	In the Access file, on the Objects list for Queries, double-click to open the Salary by Category query. You can use copy and paste tools to get data from Access and then use it in another Office application.
4.	On the Edit menu, click Select all records. On the Standard toolbar, click Copy, and then on the taskbar, click the button to return to your open Word document. When you use copy and paste, be sure to locate the correct position in the document for pasting the information.
5.	Find the area of the document under the heading II. Salary Comparisons. At the first blank line after the first paragraph, click to position the insertion point. Press to create another blank line for the information you want to add.
6.	On the Standard toolbar, click Paste. The data from the Access table is added to the Word document in a table format. You can edit and format it in the same way as you can any other Word table. Compare your screen with Figure 1.4. Figure 1.4.
7.	Save your file. Leave the Word document open for the next activity. Your taskbar should now show buttons for your Access file, your Excel document, and your Word document.

[Page 1351]

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

Word 2003

Chapter One. Creating Documents with Microsoft Word 2003

Chapter Two. Formatting and Organizing Text

Chapter Three. Using Graphics and Tables

Chapter Four. Using Special Document Formats, Columns, and Mail Merge

Excel 2003

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

Integrated Projects

Chapter One. Using Access Data with Other Office Applications

Chapter One. Using Access Data with Other Office Applications
Introduction
Project 1A. Meeting Slides
Objective 1. Export Access Data to Excel
Objective 2. Create a Formula in Excel
Objective 3. Create a Chart in Excel
Objective 4. Copy Access Data into a Word Document
Objective 5. Copy Excel Data into a Word Document
Objective 6. Insert an Excel Chart into a PowerPoint Presentation

Chapter Two. Using Tables in Word and Excel

Chapter Three. Using Excel as a Data Source in a Mail Merge

Chapter Four. Linking Data in Office Documents

Chapter Five. Creating Presentation Content from Office Documents

Table of content

Go! With Microsoft Office 2003 Brief

GO! with Microsoft Office 2003 Brief (2nd Edition)

ISBN: 0131878646
EAN: 2147483647

Year: 2004
Pages: 448

Authors: Shelley Gaskin, Linda Turpen, Robert Ferrett, John Preston, Sally Preston, Alicia Vargas

Metrics and Models in Software Quality Engineering (2nd Edition)

PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases

Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain

Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)

File System Forensic Analysis

AutoCAD 2005 and AutoCAD LT 2005. No Experience Required

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net