Access 2007 VBA bible for data-centric Microsoft Office applications
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 Acce...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley Pub
c2007.
|
| Edición: | 1st edition |
| Colección: | Bible
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627184606719 |
Tabla de Contenidos:
- 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
