Wiley Access 2007 VBA Bible: For Data-Centric Microsoft Office Applications 978-0-470-04702-6 ユーザーズマニュアル
製品コード
978-0-470-04702-6
S
ince its earliest days — about 14 years ago — Access has been a rela-
tional database program, storing data in tables and using its own
queries, forms, and reports to sort, filter, display, and print data. With
tional database program, storing data in tables and using its own
queries, forms, and reports to sort, filter, display, and print data. With
successive Office versions, moving data among Office components (espe-
cially Word, Excel, and Outlook) has become so much easier that it is now
often more efficient to use another Office component rather than an Access
report for a task such as printing letters or analyzing numeric data.
cially Word, Excel, and Outlook) has become so much easier that it is now
often more efficient to use another Office component rather than an Access
report for a task such as printing letters or analyzing numeric data.
Additionally, using other Office components to display or print data from
Access makes the data stored in Access tables more widely accessible. Many
Office users have an edition of Office that doesn’t include Access — but they
all have Word and Excel, and many also have Outlook, so they can easily
work with Word documents, Outlook messages or appointments, and Excel
worksheets, filled with data from Access tables.
Access makes the data stored in Access tables more widely accessible. Many
Office users have an edition of Office that doesn’t include Access — but they
all have Word and Excel, and many also have Outlook, so they can easily
work with Word documents, Outlook messages or appointments, and Excel
worksheets, filled with data from Access tables.
Whether you plan to present your data as an Access report, PivotChart, or
PivotTable; or a Word document or Excel worksheet, the data is stored in
Access tables, and entered and edited in Access forms.
PivotTable; or a Word document or Excel worksheet, the data is stored in
Access tables, and entered and edited in Access forms.
A Brief History of Office
Data Exchange
Data Exchange
As the Windows operating system has progressed from Windows 3.0 to
Windows XP and Vista, data transfer techniques have improved, from simple
cut and paste using the Windows 3.0 clipboard, to Dynamic Data Exchange
(DDE) and Open Database Connectivity (ODBC), to Automation (originally
Windows XP and Vista, data transfer techniques have improved, from simple
cut and paste using the Windows 3.0 clipboard, to Dynamic Data Exchange
(DDE) and Open Database Connectivity (ODBC), to Automation (originally
3
IN THIS CHAPTER
A brief history of Office data
exchange
exchange
Storing data in Access
Displaying Access data in forms
and reports
and reports
Working with rich text in
Memo fields
Memo fields
New report interactivity
Using Access as a control
center for working with
Office documents
center for working with
Office documents
Storing and Displaying
Data in Access
05_047026 ch01.qxp 4/2/07 9:41 PM Page 3
COPYRIGHTED MATERIAL