Microsoft Access 2010 Programmer’s Reference

WroxBooks
	Microsoft® Access® 2010 Programmer's Reference
		CONTENTS
		INTRODUCTION
		Chapter 1: Introduction to Microsoft Access 2010
			A BRIEF HISTORY OF ACCESS
			WHEN TO USE ACCESS
			ACCESS DATABASE BASICS
			ACCESS DATABASE OBJECTS
			SUMMARY
		Chapter 2: New Features
			NEW LOOK
			DEVELOPMENT ENVIRONMENT
			FORMS
			MACROS
			INTEGRATION WITH SHAREPOINT
			BROWSER INTERFACE/APPLICATIONS
			WHAT’S GONE OR DEPRECATED
			SUMMARY
		Chapter 3: Upgrading and Converting to Access 2010
			TO CONVERT OR TO ENABLE
			INSTALLING MULTIPLE VERSIONS OF ACCESS ON ONE PC
			CHANGING FILE FORMATS
			CONVERTING A SECURED DATABASE
			CONVERTING A REPLICATED DATABASE
			ENABLING A DATABASE
			ACCESS 2010: 64-BIT CONSIDERATIONS
			SUMMARY
		Chapter 4: Macros in Access 2010
			VBA VERSUS MACROS IN ACCESS
			TYPES OF MACROS
			CREATING MACROS IN ACCESS 2010
			MACRO OBJECTS AND EMBEDDED MACROS
			DATA MACROS
			SUMMARY
		Chapter 5: Using the VBA Editor
			ANATOMY OF THE VBA EDITOR
			USING THE OBJECT BROWSER
			TESTING AND DEBUGGING VBA CODE
			USING OPTION STATEMENTS
			SUMMARY
		Chapter 6: VBA Basics
			THE MINDSET OF A PROGRAMMER
			ANATOMY OF VBA PROCEDURES
			VBA KEYWORDS
			VBA OPERATORS
			VARIABLES AND VBA SYNTAX
			OTHER VBA COMPONENTS
			VBA OBJECTS
			USING CODE BEHIND FORMS AND REPORTS
			USING VBA CODE TO CALL MACROS
			WRITING CODE IN MODULES
			EXAMPLE: USER-DEFINED FUNCTION
			SUMMARY
		Chapter 7: Using VBA in Access
			WHEN EVENTS FIRE
			VBA PROCEDURES
			EVALUATING EXPRESSIONS IN VBA
			USING RECORDSETS
			USING MULTIPLE RECORDSETS
			USING VBA IN FORMS AND REPORTS
			DEBUGGING VBA
			INVESTIGATING VARIABLES
			COMMON VBA TECHNIQUES
			STRING CONCATENATION TECHNIQUES
			VBA ERROR HANDLING
			SUMMARY
		Chapter 8: Creating Classes in VBA
			WHY USE CLASSES?
			A TOUCH OF CLASS
			CREATING A CLASS MODULE
			NAMING AND IDENTIFYING OBJECTS
			USING CLASS EVENTS
			FORMS AND REPORTS AS OBJECTS
			VARIABLE SCOPE AND LIFETIME
			THE ME PROPERTY
			CREATING A CLONE METHOD
			CREATING AND USING COLLECTION CLASSES
			THE THREE PILLARS
			SUMMARY
		Chapter 9: Extending VBA with APIs
			INTRODUCING THE WINDOWS API
			INTRODUCING LINKING
			DECLARING APIS
			UNDERSTANDING C PARAMETERS
			ERR. LASTDLLERROR
			DISTRIBUTING APPLICATIONS THAT REFERENCE TYPE LIBRARIES AND CUSTOM DLLS
			USEFUL API FUNCTIONS
			SUMMARY
		Chapter 10: Working with the Windows Registry
			ABOUT THE REGISTRY
			USING THE BUILT-IN VBA REGISTRY FUNCTIONS
			USING THE WINDOWS REGISTRY APIS
			SUMMARY
		Chapter 11: Using DAO to Access Data
			DATA ACCESS OBJECTS
			WHY USE DAO?
			NEW FEATURES IN DAO
			REFERRING TO DAO OBJECTS
			THE DBENGINE OBJECT
			THE DATABASE OBJECT
			DAO OBJECT PROPERTIES
			CREATING SCHEMA OBJECTS WITH DAO
			DATA ACCESS WITH DAO
			APPEND-ONLY FIELDS
			SUMMARY
		Chapter 12: Using ADO to Access Data
			INTRODUCTION TO ADO IN ACCESS
			ADDING ADO REFERENCES
			CONNECTING TO ADO DATA SOURCES
			DATA ACCESS WITH ADO
			USING ADO EVENTS
			SCHEMA RECORDSETS WITH ADO
			CREATING SCHEMA WITH ADOX
			SUMMARY
		Chapter 13: Using SQL with VBA
			WORKING WITH SQL STRINGS IN VBA
			USING SQL WHEN OPENING FORMS AND REPORTS
			USING SQL TO ENHANCE FORMS
			THE REPLACEORDERBYCLAUSE AND REPLACEWHERECLAUSE FUNCTIONS
			SUMMARY
		Chapter 14: Using VBA to Enhance Forms
			VBA BASICS
			CREATING FORMS THE 2010 WAY
			SUMMARY
		Chapter 15: Enhancing Reports with VBA
			INTRODUCTION TO REPORTS
			CREATING A REPORT
			WORKING WITH VBA IN REPORTS
			IMPORTANT REPORT EVENTS AND PROPERTIES
			REPORT PROPERTIES
			WORKING WITH CHARTS
			COMMON REPORT REQUESTS
			LAYOUT VIEW
			REPORT VIEW
			SUMMARY
		Chapter 16: Customizing the Ribbon
			RIBBON OVERVIEW
			CUSTOM MENU BARS AND TOOLBARS
			RIBBON CUSTOMIZATION USING THE OPTIONS DIALOG BOX
			RIBBON CUSTOMIZATION
			SAVING A CUSTOM RIBBON
			SPECIFYING THE CUSTOM RIBBON
			CREATING AN INTEGRATED RIBBON
			CREATING A RIBBON FROM SCRATCH
			MORE RIBBON TIPS
			SUMMARY
		Chapter 17: Customizing the Office Backstage
			INTRODUCING THE OFFICE BACKSTAGE
			WRITING A BACKSTAGE CUSTOMIZATION
			CONTROLS IN THE BACKSTAGE
			DESIGNING THE LAYOUT OF COMPONENTS
			EXTENDING THE EXISTING BACKSTAGE
			BACKSTAGE-SPECIFIC CALLBACKS
			BACKSTAGE SCENARIOS
			SUMMARY
		Chapter 18: Working with Office 2010
			WORKING WITH OUTLOOK 2010
			WORKING WITH EXCEL 2010
			WORKING WITH WORD 2010
			SUMMARY
		Chapter 19: Working with SharePoint
			SHAREPOINT 2010
			ACCESS FEATURES OVERVIEW
			SHAREPOINT FEATURES IN ACCESS
			ACCESS FEATURES ON SHAREPOINT
			SUMMARY
		Chapter 20: Working with .NET
			OVERVIEW
			VISUAL STUDIO .NET 2010
			USING ACCESS DATABASES IN .NET
			AUTOMATING ACCESS WITH .NET
			CREATING COM ADD-INS FOR ACCESS
			USING .NET CODE IN ACCESS
			SUMMARY
		Chapter 21: Building Client-Server Applications with Access
			DATABASE APPLICATION EVOLUTION
			CLIENT-SERVER APPLICATIONS
			THE ACCDB/MDB FILE FORMAT
			THE ADP FILE FORMAT
			ACCDB/MDB VERSUS ADP
			CONTROLLING THE LOGON PROCESS
			BINDING ADO RECORDSETS
			WORKING WITH UNBOUND FORMS
			SUMMARY
		Chapter 22: The Access 2010 Templates
			ACCESS 2010 TEMPLATE FEATURES
			ACCESS 2010 TEMPLATES TYPES
			APPLICATION PARTS
			TABLE FIELD TEMPLATES
			SAVE AS TEMPLATE
			THE ACCDT FILE FORMAT
			SUMMARY
		Chapter 23: Access Runtime Deployment
			THE ACCESS 2010 RUNTIME
			DEPLOYING THE ACCESS RUNTIME
			SUMMARY
		Chapter 24: Database Security
			ACCDB FILE SECURITY
			MDB FILE SECURITY
			SUMMARY
		Chapter 25: Access 2010 Security Features
			THE OFFICE TRUST CENTER
			DISABLED MODE
			DIGITAL SIGNATURES AND CERTIFICATES
			ACCESS DATABASE ENGINE EXPRESSION SERVICE
			SUMMARY
		Appendix A: The Access Object Model
			THE APPLICATION OBJECT
			THE CURRENTDATA OBJECT
			THE CURRENTPROJECT OBJECT
			ACCESSOBJECT
			THE DOCMD OBJECT
			THE FORM OBJECT
			THE CONTROL OBJECT
			CONTROLS ON FORMS AND REPORTS
			OTHER COMMON CONTROL MEMBERS
			THE IMPORTEXPORTSPECIFICATION OBJECT
			THE MODULE OBJECT
			THE PRINTER OBJECT
			THE REFERENCES COLLECTION AND REFERENCE OBJECT
			THE REPORTS COLLECTION AND REPORT OBJECT
			THE SCREEN OBJECT
			THE SECTION OBJECT
			OTHER HELPFUL INFORMATION
		Appendix B: DAO Object Method and Property Descriptions
			DAO-SUPPORTED OBJECTS
			UNDOCUMENTED TOOLS AND RESOURCES
			DAO FIELD TYPES
			OPENRECORDSET CONSTANTS
		Appendix C: ADO Object Model Reference
			THE CONNECTION OBJECT
			THE ERROR OBJECT
			THE COMMAND OBJECT
			THE PARAMETER OBJECT
			THE RECORDSET OBJECT
			THE RECORD OBJECT
			THE FIELDS COLLECTION
			THE FIELD OBJECT
			THE STREAM OBJECT
			THE PROPERTIES COLLECTIONS
			THE PROPERTY OBJECT
			THE ADO ENUMERATIONS
		Appendix D: 64-Bit Access
			INTRODUCING THE 64-BIT VERSION OF MICROSOFT OFFICE 2010
			32-BIT TO 64-BIT ACCESS 2010 COMPARISON
			THE VBA 7 CODE BASE
			ACTIVEX CONTROL AND COM ADD-IN COMPATIBILITY
			API COMPATIBILITY
			DEALING WITH LEGACY CODE
			PERFORMANCE AND THE 64-BIT ENVIRONMENT
		Appendix E: References for Projects
			TYPES OF REFERENCES
			ADDING REFERENCES TO YOUR PROJECTS
			BUILDING CODE LIBRARIES
			RESOURCES
		Appendix F: Words and Special Characters
			WHAT ARE THE SOURCES OF RESERVED WORDS?
			RESERVED WORDS WITH ERROR MESSAGES
			RESERVED WORD LIST
			WHAT ARE SPECIAL CHARACTERS?
		Appendix G: Naming Conventions
			THE BENEFITS OF USING A NAMING CONVENTION
			A BRIEF HISTORY
			THE FUNDAMENTALS OF THE HUNGARIAN CONVENTION
			RULES FOR CREATING NAMES—ADDING THE PERSONAL TOUCH
			MORE DOS AND DON’TS
			TABLES OF TAGS
			STANDARDS
		Appendix H: Access Source Code Control
			GETTING THE ACCESS SCC
			INSTALLING THE ACCESS SCC
			USING THE ACCESS SCC
			THE ACCESS SCC OPTIONS
			SUMMARY
		Appendix I: Tips and Tricks
			VISUAL INTERFACE STANDARDS
			DAISY CHAIN YOUR FORMS
			FIND RECORDS
			SPLIT YOUR APPLICATION
			DISPLAY INFORMATIVE FORM CAPTIONS
			PRELOAD RECORDS
			USE A SPLASH SCREEN
			POP-UP MEMO WORKSPACE FORM WITH SPELL CHECK
			DETERMINE THE USER NAME
			CONTRIBUTOR TIPS
		INDEX