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., 2004
2 of 21
Downloading Files from the Internet
to Peachtree, p. 631
In order to complete Chapter 18, you
need to download the files shown on p.
631 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., 2004
3 of 21
Downloading Files from the Internet to
Peachtree (concluded), pp. 631-633
Complete steps 1-14 on pages 631-633 to download
Peachtree’s DDE files.
In order to complete the activities in Chapter 18, you
must download the four files shown on page 631 to
Peachtree program path. The default location for
Peachtree is c:\peachw.
©The McGraw-Hill Companies, Inc., 2004
4 of 21
Software Objectives, p. 633
Work with two Windows programs at the
same time: Peachtree Complete
Accounting 2003 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., 2004
5 of 21
Web Objectives, p. 634
Use your Internet browser to go to the book’s website at
www.mhhe.com/yacht2003
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., 2004
6 of 21
Dynamic Data Exchange
flowchart, p. 634
Spreadsheet, Database, or other software
Dynamic Data Exchange
Peachtree Complete Accounting 2003 data
©The McGraw-Hill Companies, Inc., 2004
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
631-633.)
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. 684-685,
Appendix A.
Whenever you use DDE, you must start Peachtree first,
then Excel.
©The McGraw-Hill Companies, Inc., 2004
8 of 21
Backing up Chapter 18
Disk
18 of 18
Backup Name
KB
Page Nos.
A:\bgsbar2.xls
14 KB
639
A:\bgsbar1.xls
14 KB
639
A:\balsht.bgs.xls
18 KB
640
A:\Exercise 18-1
17 KB
644
A:\Exercise 18-2
17 KB
644
TOTAL KB
80 KB
©The McGraw-Hill Companies, Inc., 2004
9 of 21
Chapter 18 topics
1.
2.
3.
4.
5.
Downloading Files from the Internet to Peachtree, pp. 631633
Software objectives and web objectives, pp. 633-634
Getting started, pp. 635-637
a. Microsoft Excel’s spreadsheet window, p. 637
b. Income vs. Expense Year-to-Date bar chart, p. 638
c. Actual vs. Budget (Income) Year-to-Date bar
chart, p. 639
Internet Activity, p. 641
Summary and Review, p. 641
a. Going to the net, p. 642
b. True/make true questions, pp. 642-644
c. Exercise 18-1, p. 644
e. Exercise 18-2, p. 644
e. Chapter 18 index, p. 645
©The McGraw-Hill Companies, Inc., 2004
10 of 21
Getting started, pp. 635- 637
Read page 635 and 636.
Complete steps 1 – 12 on pages 635 and
636.
©The McGraw-Hill Companies, Inc., 2004
11 of 21
Select Company, 637
After step 12 on page 636 is completed, the “Select
Company” window appears.
Click on <OK>. Read the paragraph under step 13
on p. 637. Complete step 14 to view the
spreadsheet.
©The McGraw-Hill Companies, Inc., 2004
12 of 21
Microsoft Excel – Datasht.xls, p. 637
After completing step 14 a. and b. on page 637, the
spreadsheet appears. Read the “Comment” box on p. 637.
©The McGraw-Hill Companies, Inc., 2004
13 of 21
Microsoft Excel–Income vs. Expense Yearto-Date bar chart, p. 638
Complete steps 15 a. – d. on p. 638
©The McGraw-Hill Companies, Inc., 2004
14 of 21
Microsoft Excel–Actual vs. Budget (Income)
Year-to-Date bar chart, pp. 638-39
Complete steps 16 a. – e. on pp. 638-639
Complete steps 17 – 20 on page 639.
©The McGraw-Hill Companies, Inc., 2004
15 of 21
Payroll summary information,
p. 639-640
Complete steps 1-6 on pp. 639-640.
Complete steps 1–5 on p. 641.
©The McGraw-Hill Companies, Inc., 2004
16 of 21
Glossary of Terms
Chapter 18
©The McGraw-Hill Companies, Inc., 2004
17 of 21
Dynamic Data Exchange, p. 634
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., 2004
18 of 21
Macro, p. 635
A macro is a series of commands and
keystrokes that automate frequently
performed tasks.
©The McGraw-Hill Companies, Inc., 2004
19 of 21
Internet Activity, p. 641
1 Go to the book’s web site at www.mhhe.com/yacht2003
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., 2004
20 of 21
Going to the Net, p. 642
Access the MSDN Online Library website at
http://msdn.microsoft.com/library
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., 2004
21 of 21