LEADER 05297nam 22006374a 450 001 9910780447003321 005 20200520144314.0 010 $a1-280-28681-4 010 $a9786610286812 010 $a0-7645-7166-4 035 $a(CKB)111090529112850 035 $a(EBL)183878 035 $a(OCoLC)70720273 035 $a(SSID)ssj0000096413 035 $a(PQKBManifestationID)11515913 035 $a(PQKBTitleCode)TC0000096413 035 $a(PQKBWorkID)10076852 035 $a(PQKB)10437413 035 $a(Au-PeEL)EBL183878 035 $a(CaPaEBR)ebr10114256 035 $a(CaONFJC)MIL28681 035 $a(CaSebORM)9780764559037 035 $a(MiAaPQ)EBC183878 035 $a(EXLCZ)99111090529112850 100 $a20040122d2004 uy 0 101 0 $aeng 135 $aurunu||||| 181 $ctxt 182 $cc 183 $acr 200 00$aAccess 2003 VBA programmer's reference$b[electronic resource] /$fPatricia Cardoza ... [et al.] 205 $a1st edition 210 $aHoboken, NJ $cWiley$dc2004 215 $a1 online resource (982 p.) 225 0 $aProgrammer to programmer 300 $aDescription based upon print version of record. 311 $a0-7645-5903-6 320 $aIncludes bibliographical references and index. 327 $aAbout the Authors; Acknowledgments; Foreword; Introduction; Chapter 1: Introduction to Microsoft Access; Why Use Microsoft Access?; Is Access the Only Database I'll Ever Need?; Microsoft Access; MSDE; SQL Server; Automating Microsoft Access Without VBA Code; The Database Wizard; Creating a Switchboard for Your Database; Begin at the Beginning; Create a Switchboard through the Switchboard Manager; Add and Configure Controls Using Wizards; Building Automation into Your Project; Using Expression Builder; Using the Macro Builder; Using the Code Builder; Summary; Chapter 2: Access, VBA, and Macros 327 $aVBA within Access Writing Code within Modules; VBA versus Macros in Access; Macros in Access 2003; Advantages to Using VBA over Macros; Summary; Chapter 3: New Features in Access 2003; Easy Upgrading; Database Structure and Management; Find Object Dependencies; Form/Report Error Checking; Propagate Field Properties; Customize SQL Font; Get Context-Sensitive SQL Help; Backup Database/Project; Sorting Option on Lookup Wizard; Copy and Paste Linked Table as Local Table; Notable Mention; New Wizards and Builders and Managers; A Wizard for Every Occasion; Available Builders; Managers 327 $aChanges to Jet Service Pack 8; Security and Related Features; What Is Macro Security? And Why Are We Talking about Macros?; Digital Signatures; Expression Sandbox; End-User Enhancements; Pivot Charts; Windows XP Theming; Templates; Smart Tags; Auto Correct Options Buttons; Better Accessibility; XML and Access; Relating XML to HTML; The Advantages of XML; Using Access 2003 with SharePoint Services; Export Information to a SharePoint Server; Import Information From a SharePoint Server; Access Developer Extensions; The Property Scanner; The Custom Startup Wizard; The Package Wizard; Summary 327 $aChapter 4: VBA Basics VBA Objects; Objects; Methods; Events; Variables and VBA Syntax; Variables; Other VBA Structures; Comments; Line Continuation; Constants; Enums; Summary; Chapter 5: Using the VBA Editor; Anatomy of the VBA Editor; Your Access Database and VBA Project-Better Together; Using the Object Browser; Testing and Debugging VBA Code; Summary; Chapter 6: Using DAO to Access Data; Direct Access Objects; Why Use DAO?; Referring to DAO Objects; Default Collection Items; The DBEngine Object; The Workspaces Collection; The Errors Collection; The Databases Collection 327 $aThe Connections Collection DAO Object Properties; DAO Property Types; Creating Schema Objects with DAO; Managing Jet Security with DAO; Creating Security Objects; Managing Users and Groups; Managing Passwords; Managing Permissions; Data Access with DAO; Working with Query Defs; Working with Record sets; Filtering and Ordering Record sets; Navigating Record sets; Bookmarks and Record set Clones; Finding Records; Working with Record sets; Summary; Chapter 7: Using ADO to Access Data; Ambiguous References; Referring to ADO Objects; Default Collection Items; Connecting to a Data Source 327 $aSpecifying a Cursor Location 330 $aWhat is this book about? Its power and short learning curve have made Access Microsoft's leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more. In this book, a crack team of programmers, including two Microsoft MVPs, shows you how to take control of Access 2003 or 2002 using VBA. You'll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and 606 $aDatabase management 615 0$aDatabase management. 676 $a005.75/65 701 $aCardoza$b Patricia$01486796 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910780447003321 996 $aAccess 2003 VBA programmer's reference$93706406 997 $aUNINA