LEADER 05273nam 2200697 a 4500001 99125227170806421 005 20251214174520.0 006 m o d | 007 cr -n--------- 008 070216s2007 inua o 001 0 eng^^ 010 |z2007007061 015 GBA687779 |2bnb 016 7 |z013578248 |2Uk 020 9786610855681 020 9781280855689 020 1280855681 020 9780470170977 020 0470170972 035 (CKB)1000000000356867 035 (EBL)291473 035 (OCoLC)166866357 035 (SSID)ssj0000096416 035 (PQKBManifestationID)11120143 035 (PQKBTitleCode)TC0000096416 035 (PQKBWorkID)10081600 035 (PQKB)10670187 035 (MiAaPQ)EBC291473 035 (CaSebORM)9780470047026 035 (OCoLC)608489614 035 (OCoLC)ocm608489614 035 (EXLCZ)991000000000356867 040 MiAaPQ |cMiAaPQ |dMiAaPQ 041 eng 050 4 QA76.9.D3 |bF435 2007 082 00 005.7565 100 1 Feddema, Helen Bell. 245 10 Access 2007 VBA bible : |bfor data-centric Microsoft Office applications / |cHelen Feddema. 250 1st edition 260 Indianapolis, IN : |bWiley Pub., |cc2007. 300 1 online resource (721 p.) 336 text |btxt 337 computer |bc 338 online resource |bcr 347 text file 490 1 Bible 500 Includes index. 505 0 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 505 8 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 505 8 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 505 8 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 505 8 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 505 8 Things You Need to Know When Writing Add-ins 520 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. 546 English 630 00 Microsoft Access. 630 00 Microsoft Visual Basic for applications. 630 00 Microsoft Office. 650 0 Database management. 776 08 |z9780470047026 776 08 |z047004702X 830 0 Bible 906 BOOK