Chapter 4 People, Organizations, Addresses
Microsoft Access 2010 Programmer’s Reference
Guide to Online Files
When writing the book, the authors created numerous examples and code snippets to help you work through and understand the concepts that we are presenting. The database files, code snippets and other supporting files are available for download from the Wiley/Wrox website, at .
The files are organized and stored in separate folders designated for each chapter. We have listed the folders and contents below so that you can quickly navigate to the desired files. As you will see, some chapters do not have online material.
In order to get the full benefit of the book and to understand the code snippets and sample files, we strongly encourage you to use them in conjunction with their designated chapters. The book explains the concepts and how to use, modify, and incorporate the code and functions into your projects and solutions. The chapters also include recommendations and links to software downloads and other programs that will help you work with the files and examples.
We recommend unzipping this package either within your Documents folder under the folder Access Programmers Reference, or in whatever location you use for your project files.
File List and Folders are in the Folder AccessProgrammersReference
There are 23 folders in the download file. Each folder contains the databases, and other files that contain the code or were referenced in the chapter or appendix.
The following lists all the chapters and their associated folder and files along with a brief description topics and examples provided. We’ve also noted the chapters that do not have download files.
Chapter 1: Introduction to Microsoft Access 2010 - No download files.
Chapter 2: New Features in Access 2010
This chapter talks about some of the key new features and the benefits that they offer to developers and users. Since many people will be moving from Access 2003 directly to Access 2010, we wanted to provide a briefing on features added in Access 2007. So, as a bonus, we have provided the New Features chapter from the Access 2007 VBA Programmer’s Reference.
Ch02_NewFeatures_doc
▪ Access2007_NewFeatures.pdf - The new features chapter from the prior version of this book, Access 2007 VBA Programmer’s Reference.
Chapter 3: Upgrading and Converting to Access 2010 - No download files.
Chapter 4: Macros in Access 2010
Macros in Access provide an alternative to VBA for accomplishing certain tasks, so the chapter explains the differences as well as how and when to benefit from using macros. We provide guidance and examples for using Access 2010 new features such as the Macro Designer and data macros. Key topics include:
▪ When to use Macros and how they compliment and compare to VBA
▪ An in-depth review of the new Macro Designer
▪ How to leverage data macros
Ch04_Macros_samples
▪ DataMacroSamples.accdb
▪ MacroSamples.accdb
Chapter 5: Using the VBA Editor
Chapter 5 explains discusses the components of the VBA editor and shows you how to use them to write and test code. The topics covered include:
▪ Explanation of VBA Editor’s components
▪ How to use the Object Browser
▪ Techniques for testing and debugging code
Ch05_VBAEditor_samples
▪ ch5_VBAEditor_Code.txt - most of code illustrated in the chapter
Chapter 6: VBA Basics
This chapter helps lay the foundation for building solid, reusable VBA code. The discussion and examples explain the components of VBA, how to name and use variables, how to work with VBA objects, properties, and methods, and how to write code in modules. The download file provides code snippets for you to put in the VBA editor to try and test out. Unless otherwise noted, you can do so by creating a new standard module then copying and pasting in the sample. Be sure to note whether you are copying in a complete procedure, a code snippet, or a complete module, referring to the chapter for guidance. Topics include:
▪ Simple procedures
▪ Demonstration of VBA constructs
▪ Demonstration of Code behind the forms
▪ Demonstration of User-Defined Functions
Ch06_VBABasics_samples
▪ ch6_VBABasics_Code.txt - most of code illustrated in the chapter
Chapter 7: Using VBA In Access
This chapter covers the basics of getting the most out of the more common features of VBA as it relates to Access. It also briefly touches on accepted best practices for working with VBA procedures. Topics include:
▪ Using events
▪ Employing good practices with VBA procedures
▪ Evaluating expressions in VBA
▪ Using recordsets and multiple recordsets
▪ Coding behind forms and reports
▪ The VBA debugging environment
▪ Determining the value of variables
▪ Handling common VBA challenges
▪ Concatenating strings
▪ Handling VBA errors
Ch07_UsingVBA_samples
▪ ch07_CodeSnippets.txt - most of the code illustrated in the chapter
Chapter 8: Creating Classes in VBA
The chapter provides an introduction to using class modules by explaining how they are comprised, how to create them, and how to use them. The chapter contains numerous code snippets and examples; most are included in the chapter download files. Highlights include:
▪ An introduction to class modules
▪ Subclassing Access forms
▪ Writing collection classes to group objects
▪ Core principles of object-oriented programming
Ch08_CreatingClasses_samples
▪ ClassExamples.accdb
▪ InstancingExample.accdb
▪ InstancingTests.accdb
Chapter 9: Extending VBA with APIs
In this chapter, you learn how to use APIs (Application Programming Interface) to add functionality to Access applications. Because the API is geared toward C/C++ developers, this chapter helps explain the special considerations necessary to use API calls from VBA. Key topics include:
▪ Using static versus dynamic linking
▪ Converting API function declarations from C++ to VBA
▪ How to write code that can be used with 32-bit and 64-bit Office
▪ How to use some of the more common Windows API functions
Ch09_APIs_samples
▪ APISamples.accdb
Chapter 10: Working with the Win32 Registry
Being able to read and write information from the Registry empowers developers to not only control Access, but to work with and control other programs as well. The example files will help you follow the demonstrations as the chapter explains:
▪ How the Registry is organized and what it does
▪ Frequently used functions in the Registry API
▪ Advanced Registry functions to use on local or remote computers
Ch10_Win32Reg_samples
▪ RegistrySamples.accdb
Chapter 11: Using DAO to Access Data
This chapter provides an in-depth look at how to use Data Access Objects (DAO) to create and modify your database structure, including tables, fields, indexes, and relations. After covering the basics, it also gives you a detailed look at data access using QueryDefs and Recordsets. Key topics include:
▪ Review of the new features in DAO for Access 2007 and 2010
▪ In depth descriptions of objects used in DAO to create and work with data
Ch11_DAO_samples
▪ Chapter 11 - DAO Samples.accdb
▪ Chapter 11 - db1.accdb
Chapter 12: Using ADO to Access Data
ActiveX Data Objects (ADO) provide a standardized Object Model for connecting to external data sources. ADO is the API that works with the OLE DB (Object Linking and Embedding Databases), so it is essentially a code library for working with different types of data sources. The sample files help to demonstrate the key topics covered, which include:
▪ Using ADO in Access applications
▪ Adding a reference to ADO and creating connection strings
▪ Using ADO transactions
▪ Manipulating data in an ADO data source
▪ Creating and manipulating ADO Recordset objects
▪ Working with data source schema using ADOX
Ch12_ADO_samples
▪ SampleCode (folder)
- Ch12_Sample.accdb
- Connection.UDL
Chapter 13: Using SQL with VBA
This chapter discusses how to utilize SQL as part of VBA functions or routines. While the chapter is not a guide for SQL syntax, it does go into a detailed explanation of how to create SQL statements using VBA and working with SQL strings in VBA. Some of the key topics include:
▪ Working with SQL Strings in VBA
▪ Using SQL when opening Forms and Reports
▪ The ReplaceOrderByClause function
▪ The ReplaceWhereClause function
Ch13_UsingSQL_samples
▪ ch13_CodeSnippets.txt - most of the code illustrated in the chapter
Chapter 14: Enhancing Forms with VBA
This chapter covers how to extend the functionality of forms by enhancing them using VBA. It does so by discussing VBA fundamentals and how to get the most out of the way forms are created in Access 2010. It also explains how to give your forms that professional touch by using the TreeView and ListView controls that come with the 32 bit version of Access 2010. Topics include:
▪ Fundamental VBA Concepts
▪ Creating Forms the 2010 way
▪ Using the TreeView and ListView controls
Ch14_Forms_samples
▪ 51966_ch14_CodeSnippets.txt - contains most of the code illustrated in the chapter
▪ ActiveXControlSample.accdb - illustrates use of ActiveX controls
▪ AttachmentDemo.accdb - illustrates how to use the attachment control
▪ ComboBox.accdb - illustrates how to use comboboxes including cascading comboboxes
▪ EditValueList.accdb - illustrates how to dynamically add values to a listbox or combobox
▪ LateBinding.accdb - illustrates use of late binding for forms
▪ MultiFormInstance.accdb - illustrates opening multiple instances of same form
▪ Projects1ActiveXControls.accdb - illustrates how to use ActiveX controls
▪ SendEmail.accdb - illustrates how to use send emails from Access
Chapter 15: Enhancing Reports with VBA
Chapter 15 demonstrates how to create reports and leverage some of the powerful new features, as well as those that have been the mainstay for several versions. Topics include:
▪ Working with VBA in Reports
▪ Important Events and Properties
▪ Common Report Requests
▪ Interactivity
Ch15_Reports_samples
▪ ReportsChatper.accdb
Chapter 16: Customizing the Ribbon
The chapter explains how to customize the Ribbon using existing Menu Bars and Toolbars as well as creating custom controls. The companion file helps readers follow along and work through the examples from the chapter. Topics include:
▪ Creating custom Menu Bars and Toolbars
▪ Using the Options Dialog and using XML
▪ Specifying a Custom Ribbon
▪ Creating an Integrated Ribbon
▪ Creating a Ribbon from Scratch
▪ Customizing the Office Menu and much more
Ch16_Ribbon_samples
▪ RibbonSamples.accdb
▪ TravelAgencySample.accdb
▪ Images (folder)
Chapter 17: Customizing the Office Backstage
Office Backstage was introduced in Office 2010, and this chapter explains the features and how to use them. The example files allow readers to follow the discussion and experiment with some of the features.
Ch17_Backstage_samples
▪ BackstageSamples.accdb
Chapter 18: Working with Office Applications
Access is a powerful tool for managing and working with data from other Office applications. This chapter discusses scenarios for working with data in Outlook, Excel, Word, and PowerPoint.
Ch18_OfficeApps_samples
▪ Ch18_Sample.accdb
Chapter 19: Working with SharePoint
The features for integrating Access 2010 with SharePoint Server 2010 have opened up new opportunities to create Access Web Applications that leverage SharePoint features. The sample file contains some of the code samples discussed in the chapter.
▪ An overview of the new Access Web Application features
▪ A discussion of how to build a traditional Access database that can use SharePoint as a data source
▪ How to import and export to SharePoint lists
Ch19_SharePoint_samples
▪ Ch19_Sample.accdb
Chapter 20: Working with .NET
Access 2010 has enhanced abilities to integrate with .NET to expand Access’s reach and capabilities. Some of the topics covered in the chapter include:
▪ Using Access ACCDB and MDB files with .NET applications
▪ Automating Access with .NET
▪ Creating Com Add-ins for Access
▪ Using .NET code in Access by calling it from VBA within an Access application
Ch20_Net_samples
▪ AccessAddInExample (Folder)
- AccessAddInExample (subfolder) - with 2 subfolders and 8 files
- AccessAddInExampleSetup (subfolder) - with 2 subfolders and 1 file
▪ AdoClientExample
- ADOExample1 (subfolder) - with 3 sub folders and 8 files
- ADOExample1.sln
- ADOExample1.suo
▪ AdoWebExample
- AdoWebExample (subfolder) - with 7 sub folders and 17 files
- AdoWebExample.sln
- AdoWebExample1.suo
▪ AutomateAccessExample
- AutomateAccessExample (subfolder) - with 3 sub folders and 5 files
- AutomateAccessExample.sln
- AutomateAccessExample.suo
▪ ManagedCodeExample
- ManagedLibraryCode (subfolder) - with 1 sub folder and 2 files
- ManagedCodeExample.accdb
▪ WinApp1
- WinApp1 (subfolder) - with 3 sub folders and 5 files
- WinApp1.sln
- WinApp1.suo
Chapter 21: Building Client-Server Applications with Access
The chapter discuss how to plan and design client-server applications that will provide optimum performance. It discusses how and when to use file formats for ACCDB, MDB and ADP. Key topics discuss:
▪ Building client-server applications using Access 2010 and SQL Server
▪ Analyzing and optimizing Access applications connected to SQL Server
▪ Comparing use of ACCDB/MDB formats to ADP file formats
▪ Using bound and unbound forms and reports with a SQL Server data source
▪ Building forms and reports in ADPs
Ch21_Client-Server_samples
▪ Ch21_SampleACCDB.accdb
▪ Ch21_SampleADP.adp
▪ AlternativeServer.udl
▪ Invoices.xml
▪ Sample.SQL
Chapter 22: Access Templates - No download files.
Chapter 23: Access Runtime Deployment - No download files.
Chapter 24: Database Security
The chapter discusses the security features available to ACCDB and to MDB formats and how to use them. Key topics address:
▪ Discussing the database security features in Access 2010 specific to the ACCDB and to the MDB format.
▪ Step by step instructions for implementing the Access 2010 security features
▪ VBA code examples for programmatically manipulating security features
Ch24_DatabaseSecurity_samples
▪ SampleCode (Folder)
- ACCDB-SampleCode (subfolder)
- Ch24_AccdbSample.accdb
- MDB-SampleCode (subfolder)
- MDB-SampleCode.mdb
- SampleMDB.mdb
- SampleMDW.mdw
Chapter 25: Access 2010 Security Features
This chapter focuses on security features designed to protect your computer from malicious attacks. We explain the features that are built into Access and how to use them. Of course, there are times that it is helpful to temporarily override certain security settings, and we’ve explained a bit about how and when to do that and provided some code snippets. Key topics include:
▪ Managing security settings
▪ Using Disabled mode
▪ Understanding Macro security
▪ Creating and using digital signatures and certificates
▪ On overview of the Access Database Engine Expression Service
▪ And using Sandbox mode
Ch25_AccessSecurity_samples
▪ Ch25_CodeSnippets.txt
Two appendixes have companion files for download.
Appendix G Naming Conventions
The appendix discusses the benefits of implanting a naming convention, and explains some common practices for the structure of some of the more common naming conventions. For your convenience, we have also provided a document with several of common base words, prefixes, and suffixes.
AppG_NamingConventions_doc
▪ APR_appG_NamingConventions.pdf
Appendix I Tips and Tricks
This appendix discusses some good business practices that will provide consistency for users and help make your database applications look more professional. Most of the material is related to the Chambers Application. We have also included some valuable tips and examples that have been contributed by our esteemed colleagues.
AppI_Tips_samples
▪ Chamber Application.accdb
▪ Chamber Data.mdb
▪ IifQueries.accdb
▪ IifQueries.mdb
▪ Tutorials Local.accdb
▪ Handy Developer Tools (folder)
- Audit Trail DB - Tutorial.doc
- Handy Developer Tools.accdb
- Handy Developer Tools.mdb
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- workplace readiness skills worksheet
- sample hospital risk assessment recommendations
- chapter 7 managing change stress and innovation
- project management references
- chapter 4 people organizations addresses
- theories relevant to emergency management
- 16 organizational culture
- university of new mexico
- answers to chapters 1 2 3 4 5 6 7 8 9 end of chapter
Related searches
- chapter 4 culture quizlet
- chapter 4.2 overview of photosynthesis
- psychology chapter 4 review
- strategic management chapter 4 quizlet
- chapter 4 lifespan development
- chapter 4 psychology test
- tom sawyer chapter 4 summary
- chapter 4 worksheet answers
- chapter 4 2 overview of photosynthesis
- chapter 4 psychology quizlet
- chapter 4 quiz answers
- psychology chapter 4 quiz