Access 2007 VBA bible : for data-centric Microsoft Office applications / Helen Feddema.

Format:

Book

Author/Creator:

Feddema, Helen Bell.

Series:

Bible

Language:

English

Subjects (All):

Microsoft Access.

Microsoft Visual Basic for applications.

Microsoft Office.

Database management.

Physical Description:

1 online resource (721 p.)

Edition:

1st edition

Place of Publication:

Indianapolis, IN : Wiley Pub., c2007.

Language Note:

English

System Details:

text file

Summary:

Learn how to tap the full potential of Access 2007 Transfer Access data seamlessly between Microsoft Office applications-and that's just for starters. In this all-new, comprehensive guide by well-known Access expert Helen Feddema, you'll learn to write Visual Basic code that automates Access database tasks, creates standalone scripts, extracts and merges data, and allows you to put together powerful solutions. Whether you're a beginner or a power user, this is the book you need to succeed with Access 2007.

Contents:

Access 2007 VBA Bible; About the Author; Credits; Contents; Acknowledgments; Introduction; Who Should Read This Book; How This Book Is Organized; What's on the Companion Web Site; Minimum Requirements; Where to Go from Here; Part I: The Office Components and What They Do Best; A Brief History of Office Data Exchange; Chapter 1: Storing and Displaying Data in Access; Storing Data in Access; Displaying Data in Access Forms and Reports; Summary; Chapter 2: Creating Word Documents from Access; Filling Word Documents with Access Data Using the TypeText Method

Using Word Templates for Creating Formatted Word DocumentsForm Field Documents; Summary; Chapter 3: Analyzing Data with Excel; Exporting Access Data to an Unformatted Worksheet; Using Excel Templates to Create Formatted Worksheets Filled with Access Data; Formatting Excel Worksheets in VBA Code; Summary; Chapter 4: Organizing and Communicating with Outlook; Exporting Appointments and Tasks to Outlook; Exporting Journal Information to Outlook; Creating Emails from an Access Table; Summary; Part II: Writing VBA Code to Exchange Data between Office Components; Chapter 5: Working with Access Data

Working with Older Format Databases in Access 2007Converting DAO Code to ADO Code; Summary; Chapter 6: Working with Word Documents and Templates; Built-in Word Export in Office 2007; Exporting Access Data to Word Using Automation Code; Summary; Chapter 7: Working with Excel Worksheets; Simply Exporting Access Data to Excel; The Excel Object Model; Minimally Formatted Worksheets; Tabular Worksheets Formatted from Code; Timesheets; Summary; Chapter 8: Working with Outlook Items; Exporting Access Data to Outlook Items; The Outlook Object Model; Working with Outlook Appointments

Working with Outlook TasksWorking with Outlook Contacts; Summary; Chapter 9: Working with Files and Folders; Working with Windows Explorer Folders; Backing up Your Database; Working with Text Files; Working with Attachment Fields; Summary; Chapter 10: Working with External Data; Working with Text Files Using the TransferText Method; Working with Legacy Database and Spreadsheet Files; Working with XML and HTML Files; Emailing Exported Text Files; Summary; Chapter 11: Synchronizing Access and Outlook Contacts; Creating a Denormalized Table from a Set of Linked Tables

Comparing Outlook and Access ContactsWorking with Attachments; Summary; Chapter 12: Going Beyond the Basics; Creating Fancy Word Shipping Labels; Creating Excel PivotCharts from Access Queries; Emailing Shipping and Reordering Reports; Summary; Part III: Adding More Functionality to Office; Chapter 13: Creating COM Add-ins with Visual Basic 6; Creating a COM Add-in Using Visual Basic 6.0; Using a COM Add-in; Comparing COM Add-ins with Access Add-ins; Summary; Chapter 14: Creating Access Add-ins; The Purpose of Access Add-ins; Add-in Types; Creating a Library Database

Things You Need to Know When Writing Add-ins

Notes:

Includes index.

ISBN:

9786610855681

9781280855689

1280855681

9780470170977

0470170972

OCLC:

166866357