Lesson 9

DDE - What is this technology and what is it used for?
DDE stands for Dynamic Data Exchange. It allows for two applications that are running at the same time to share the same data. For example, Word and Excel can be open at the same time and Word containing a link to a chart in Excel. When the data in Excel changes, the Word document changes to reflect the current data.

Office Assistant
The first thing I learned is that I didn't have the Office assistant installed. The assistant can be hidden until needed. The assistant can be changed to other things from the paper clip. After typing in a question, the assistant retrieves data from the help menu and/or office online help. There are also tips and options to further customize the office assistant.

Documentation
There are several reasons for documentation.
1) To identify the purpose of the database.
2) To document how to use the database.
3) Document how the ER diagram was created and why. This would be handy for any future database modifications that are to be made.
4) How to run a report
5) How to export or import data
I'm sure there are many more reasons.