Access 2003 VBA programmer's reference / / Patricia Cardoza ... [et al.]

• Pubblicazione: Hoboken, NJ, : Wiley, c2004
• Edizione: 1st edition
• Descrizione fisica: 1 online resource (982 p.)
• Disciplina: 005.75/65
• Soggetto topico: Database management
• Altri autori: CardozaPatricia
• Note generali: Description based upon print version of record.
• Nota di bibliografia: Includes bibliographical references and index.
• Nota di contenuto: About 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 ; VBA 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 ; Changes 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 ; Chapter 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 ; The 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 ; Specifying a Cursor Location
• Sommario/riassunto: What 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
• Titolo autorizzato: Access 2003 VBA programmer's reference
• ISBN: 1-280-28681-4; 9786610286812; 0-7645-7166-4
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910814853903321
• Lo trovi qui: Univ. Federico II