Yes, Office has extensive data sharing capabilities. Data can be shared amongst Access, Word, Excel, PowerPoint, Outlook, etc. and Office really doesn't care which data are stored where. Defining the data relationships and how/when they are to be shared is the real challenge. You probably don't want to share most of the data amongst applications, or even between files within a given application.
Access is a specialised data storage application (a database), though for many people, Excel (with its table structure) serves perfectly well.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|