Transcript PowerPoint Chapter 18

Chapter 18:
Dynamic Data Exchange
18-2
Dynamic Data Exchange (DDE)


Dynamic Data Exchange is method that
allows Windows programs to share data.
Using DDE, you can enter a formula into
an Excel spreadsheet cell that refers to a
field of data in Peachtree. Whenever you
use that spreadsheet in the future, the cell
would be updated with the current data
from Peachtree.
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-3
Downloading Files from the Internet
to Peachtree, p. 651-652

1.
2.
3.
4.
In order to complete Chapter 18, you
need to download the following files
from the “Textbook Updates” link at
www.mhhe.com/business/accounting/yacht2002
Graph95.xlm
Graph97.xlm
Sample95.xlm
Sample97.xlm
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-4
Software Objectives, p. 652
Work with two Windows programs at the
same time: Peachtree Complete
Accounting 2002 and Microsoft Excel
for Windows.
 Go to the macros in Excel to create
spreadsheets from Bellwether Garden
Supply data.
 Display and save bar graphs.
 Save Excel files.

McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-5
Web Objectives, p. 652

Use your Internet browser to go to the book’s
website at
www.mhhe.com/business/accounting/yacht2002

Download four files from the textbook website to
Peachtree’s program path.
 Go to the Internet Activity link on the book’s
website. Then, select WEB EXERCISES PART
4. Continue to explore the third exercise in Part
4, “Web Development.”
 Use a word processing program to write
summaries of the websites that you visited.
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-6
Dynamic Data Exchange
flowchart, p. 653
Spreadhsheet, Database, or other software
Dynamic Data Exchange
Peachtree Complete Accounting 2002 data
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-7
Peachtree Tips
Before completing the work in Chapter 18, you
must copy the four files from the textbook
website. (See textbook pages 651-652.)
You restore Bellwether data from Exercise 6-2
to complete Chapter 18.
If you do not have Exercise 6-2 data, install
Bellwether’s starting data. This is shown in
Appendix A on pages 701-702.
Whenever you use DDE, you must start
Peachtree first, then Excel.
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-8
Backing up Chapter 18
Disk
18 of 18
Backup Name
KB
Page Nos.
A:\bgsbar2.xls
14 KB
658
A:\bgsbar1.xls
14 KB
658
A:\balsht.bgs.xls
15 KB
659
A:\Exercise 18-1
17 KB
663
A:\Exercise 18-2
15 KB
663
TOTAL KB
75 KB
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
Chapter 18 topics
1.
2.
3.
4.
5.
18-9
Downloading Files from the Internet to Peachtree, pp. 651652
Software objectives and web objectives, p. 652
Getting started, pp. 653-659
a. Microsoft Excel’s spreadsheet window, p. 656
b. Income vs. Expense Year-to-Date bar chart, p. 657
c. Actual vs. Budget (Income) Year-to-Date bar
chart, p. 658
Internet Activity, p. 660
Summary and Review, p. 660
a. Going to the net, p. 661
b. True/make true questions, pp. 661-662
c. Exercise 18-1, p. 663
e. Exercise 18-2, p. 663
e. Chapter 18 index, p. 664
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-10
Getting started, pp. 653 - 655

Read page 653.
 Complete steps 1 – 13 on pages 654, 654,
and 655.
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
Select Company, 655

Complete step 14 on page 655. The “Select
Company” window appears.

Click on <OK>. Read the paragraph at the
bottom of page 655.
McGraw-Hill/Irwin
18-11
© The McGraw-Hill Companies, Inc., 2003
18-12
Microsoft Excel – Datasht.xls, p. 656

Complete steps 16 a. and b. on page 655. Read the
“Comment” box on p. 656.
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
Microsoft Excel – Chart1, p. 657

18-13
Complete steps 17 a. – d. on pp. 656-657.
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-14
Microsoft Excel – Chart2, p. 658

Complete steps 18 a. – e. on p. 657

Complete steps 19 – 22 on page 658.
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-15
Payroll summary information,
p. 658-659

Complete steps 1-6 on pp. 658-659.

Complete steps 1 – 5 on page 659.
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-16
Glossary of Terms
Chapter 18
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-17
Dynamic Data Exchange, p. 653


DDE is a method that allows Windows
programs to share data.
Using DDE, you could enter a formula
into an Excel spreadsheet cell that
would refer to a field of data in
Peachtree.
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-18
Macro, p. 653

A macro is a series of commands and
keystrokes that automate frequently
performed tasks.
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-19
Internet Activity, p. 660
1 Go to the book’s web site at
www.mhhe.com/business/accounting/yacht2002
2 In the “Student Center” list, link to Internet Activities.
3 Link to WEB EXERCISES PART 4.
4 Continue to explore the “WEB DEVELOPMENT” exercise
started in Chapter 17.
6 Using a word processing program, write a brief summary of
what you find. Include all appropriate web site addresses.
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003
18-20
Going to the Net, p. 661
 Access
the MSDN Online Library website at
http://msdn.microsoft.com/library/default.asp?URL=/library/enus/ipc/dde_4oit.asp
1. Define the term Dynamic Data Exchange. Use the
“MSDN Library” link to learn more about MSDN
libraries.
2. What is the MSDN library?
McGraw-Hill/Irwin
© The McGraw-Hill Companies, Inc., 2003