Details

Subject(s)

• Microsoft Access [Browse]
• Microsoft Visual Basic for applications [Browse]
• Microsoft Office [Browse]
• Database management [Browse]

Series

Bible [More in this series]

Summary note

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.

Notes

Includes index.

Language note

English

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

Show 3 more Contents items

ISBN

• 1-280-85568-1
• 9786610855681
• 0-470-17097-2

OCLC

• 166866357
• 608489614

Statement on language in description

Princeton University Library aims to describe library materials in a manner that is respectful to the individuals and communities who create, use, and are represented in the collections we manage. Read more...