Transcript Chapter 18: Dynamic Data Exchange

Chapter 18:
Dynamic Data Exchange
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 is updated with
the current data from Peachtree.
©The McGraw-Hill Companies, Inc.
2 of 21
Downloading Files from the Internet
to Peachtree, p. 636
In order to complete Chapter 18, you
need to download the files shown on p.
625 from Peachtree’s website at
www.peachtree.com/support/dde
DDE-BalSheet.xls
2. DDE-Graph.xlm
3. DDE-Requests.xls
4. DDE-TrialBal-EmpList.xls
1.
©The McGraw-Hill Companies, Inc.
3 of 21
Downloading Files from the Internet to
Peachtree (concluded), pp. 625-627
Complete steps 1-14 on pages 625-627 to download
Peachtree’s DDE files.
In order to complete the activities in Chapter 18, you
must download the four files shown on page 625 to
Peachtree program path. The default location for
Peachtree is c:\Program Files\Peachtree.
©The McGraw-Hill Companies, Inc.
4 of 21
Software Objectives, p. 628
Work with two Windows programs at the
same time: Peachtree Complete
Accounting 2004 and Microsoft Excel
for Windows.
Use macros to create spreadsheets
from Bellwether Garden Supply data.
Display and save bar graphs.
Save Excel files.
©The McGraw-Hill Companies, Inc.
5 of 21
Web Objectives, p. 628
Use your Internet browser to go to the book’s website at
www.mhhe.com/yacht2004
Unzip the DDE-EXCEL-ZIP.EXE files to Peachtree’s
program path. (If your instructor has already copied
these files, you do not need to copy them again.)
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.
©The McGraw-Hill Companies, Inc.
6 of 21
Dynamic Data Exchange
flowchart, p. 628
DDE is a method that allows Windows programs to share data.
Spreadsheet, Database, or other software
Dynamic Data Exchange
Peachtree Complete Accounting 2004 data
©The McGraw-Hill Companies, Inc.
7 of 21
Peachtree Tips
Before completing the work in Chapter 18, you must
copy the four files from Peachtree’s website at
www.peachtree.com/support/dde. (See textbook pages
625-627.)
You restore Bellwether data from the Exercise 6-2.ptb
file to complete Chapter 18.
If you do not have Exercise 6-2 data, install
Bellwether’s starting data. Installing Bellwether’s
starting data is shown in Appendix A, pp. 678-679,
Appendix A.
Whenever you use DDE, you must start Peachtree first,
then Excel.
©The McGraw-Hill Companies, Inc.
8 of 21
Backing up Chapter 18
To complete work in Chapters 16, 17, 18 and Project 4, you need two
blank formatted disks.
Disk
1 of 2
Backup Name
A:\bgsbar2.xls
A:\bgsbar1.xls
A:\balsht.bgs.xls
A:\Exercise 18-1
A:\Exercise 18-2
©The McGraw-Hill Companies, Inc.
KB
Page Nos.
14 KB
634
14 KB
634
18 KB
17 KB
17 KB
635
639
639
9 of 21
Chapter 18 topics
1.
2.
3.
4.
5.
Downloading Files from the Internet to Peachtree, pp. 625627
Software objectives and web objectives, p. 628
Getting started, pp. 629-636
Internet Activity, p. 636
Summary and Review, p. 636
a. Going to the net, p. 637
b. True/make true questions, pp. 637-638
c. Exercise 18-1, p. 639
e. Exercise 18-2, p. 639
e. Chapter 18 index, p. 640
©The McGraw-Hill Companies, Inc.
10 of 21
Getting started, pp. 629- 630
Read page 629 and 630.
Complete steps 1 – 12 on pages 629 and
630.
©The McGraw-Hill Companies, Inc.
11 of 21
Select Company, 631
After step 12 on page 631 is completed, the Select
Company window appears.
Click on <OK>. Read the paragraph under step 13
on p. 631. Complete step 14, p. 632 to view the
spreadsheet.
©The McGraw-Hill Companies, Inc.
12 of 21
Microsoft Excel – p. 632
After completing step 14 a. and b. on page 632, the
spreadsheet appears. Read the Comment box on p. 632.
©The McGraw-Hill Companies, Inc.
13 of 21
Income vs. Expense Year-to-Date bar chart,
p. 633
Complete steps 15 a. – d. on pp. 632-633
©The McGraw-Hill Companies, Inc.
14 of 21
Year-to-Date Income by Account
pie chart, p. 634
Complete steps 16 a. – e. on pp. 633-634
Complete steps 17 – 20 on page 634.
©The McGraw-Hill Companies, Inc.
15 of 21
Payroll summary information,
p. 634-635
Complete steps 1-6 on pp. 634-635.
Complete steps 1–5 on p. 635.
©The McGraw-Hill Companies, Inc.
16 of 21
Glossary of Terms
Chapter 18
©The McGraw-Hill Companies, Inc.
17 of 21
Dynamic Data Exchange, p. 628
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.
©The McGraw-Hill Companies, Inc.
18 of 21
Macro, p. 629
A macro is a series of commands and
keystrokes that automate frequently
performed tasks.
©The McGraw-Hill Companies, Inc.
19 of 21
Internet Activity, p. 637
1 Go to the book’s web site at www.mhhe.com/yacht2004
2 In the Student Center list, link to Internet Activities.
3 Link to WEB EXERCISES PART 4.
4 Since this exercise was started in Chapter 17, continue to
explore the WEB DEVELOPMENT links.
6 Using a word processing program, write a brief summary
of what you find. Include all appropriate web site
addresses.
©The McGraw-Hill Companies, Inc.
20 of 21
Going to the Net, p. 648
Access the MSDN Online Library website at
http://msdn.microsoft.com/library/default.asp.
1. What is the MSDN library?
2. Type What is DDE? in the Search field. Then, select
GO. Define the term Dynamic Data Exchange.
©The McGraw-Hill Companies, Inc.
21 of 21