Microsoft® Access® 2010 Bible -- About the Author -- About the Technical Editor -- Credits -- Contents at a Glance -- Contents -- Acknowledgments -- Introduction -- Part I: Access Building Blocks -- Chapter 1: An Introduction to Database Development -- The Database Terminology of Access -- Relational Databases -- Access Database Objects -- A Five-Step Design Method -- Summary -- Chapter 2: Creating Access Tables -- Getting Started with Access -- Creating a Database -- The Access 2010 Environment -- Creating a New Table -- Creating tblCustomers -- Changing a Table Design -- Understanding tblCustomers Field Properties -- Setting the Primary Key -- Indexing Access Tables -- Printing a Table Design -- Saving the Completed Table -- Manipulating Tables -- Adding Records to a Database Table -- Understanding Attachment Fields -- Summary -- Chapter 3: Designing Bulletproof Databases -- Building Bulletproof Databases -- Data Normalization -- Table Relationships -- Integrity Rules -- Keys -- Summary -- Chapter 4: Selecting Data with Queries -- Introducing Queries -- Creating a Query -- Adding Fields -- Displaying the Recordset -- Working with Fields -- Changing the Sort Order -- Displaying Only Selected Records -- Printing a Query's Recordset -- Saving a Query -- Creating Multi-Table Queries -- Working with the Table Pane -- Creating and Working with Query Joins -- Understanding Table Join Types -- Summary -- Chapter 5: Using Operators and Expressions in Access -- Introducing Operators -- Using Operators and Expressions in Queries -- Entering Single-Value Field Criteria -- Using Multiple Criteria in a Query -- Entering Criteria in Multiple Fields -- Summary -- Chapter 6: Working with Datasheet View -- Understanding Datasheets -- Looking at the Datasheet Window -- Opening a Datasheet -- Entering New Data -- Navigating Records in a Datasheet.

Changing Values in a Datasheet -- Using the Undo Feature -- Copying and Pasting Values -- Replacing Values -- Adding New Records -- Deleting Records -- Displaying Records -- Sorting and Filtering Records in a Datasheet -- Focusing on Special Features of Datasheets -- Printing Records -- Summary -- Chapter 7: Creating Basic Access Forms -- Formulating Forms -- Working with Controls -- Introducing Properties -- Summary -- Chapter 8: Working with Data on Access Forms -- Using Form View -- Changing Values in a Form -- Printing a Form -- Working with Form Properties -- Adding a Form Header or Footer -- Changing the Layout -- Creating a Calculated Control -- Converting a Form to a Report -- Summary -- Chapter 9: Presenting Data with Access Reports -- Introducing Reports -- Creating a Report, from Beginning to End -- Banded Report Design Concepts -- Creating a Report from Scratch -- Improving the Report's Appearance -- Summary -- Part II: Programming Microsoft Access -- Chapter 10: VBA Programming Fundamentals -- Introducing Visual Basic for Applications -- Understanding VBA Terminology -- Starting with VBA Code Basics -- Migrating from Macros to VBA -- Creating VBA Programs -- Understanding VBA Branching Constructs -- Working with Objects and Collections -- Looking at Access Options for Developers -- Summary -- Chapter 11: Mastering VBA Data Types and Procedures -- Introducing the Access VBA Editor -- Using Variables -- Working with Data Types -- Understanding Subs and Functions -- Creating Functions -- Simplifying Code with Named Arguments -- Summary -- Chapter 12: The Access Event Model -- Programming Events -- Identifying Common Events -- Paying Attention to Event Sequence -- Summary -- Chapter 13: Accessing Data with VBA Code -- Understanding SQL -- Working with Data -- Understanding ADO Objects -- Understanding DAO Objects.

Writing VBA Code to Update a Table -- Summary -- Chapter 14: Debugging Your Access Applications -- Testing Your Applications -- Using the Module Options -- Organizing VBA Code -- Compiling VBA Code -- Traditional Debugging Techniques -- Using the Access Debugging Tools -- Summary -- Chapter 15: Using Access Data Macros -- Introducing Data Macros -- Looking at How Data Macros Are Created -- Discovering Table Events -- Building Macros -- Recognizing the Limitations of Data Macros -- Summary -- Part III: More-Advanced Access Techniques -- Chapter 16: Working with External Data -- Looking at How Access Works with External Data -- Linking External Data -- Working with Linked Tables -- Using Code to Link Tables in Access -- Summary -- Chapter 17: Importing and Exporting Data -- Looking at Your Options for Importing and Exporting -- Importing External Data -- Exporting to External Formats -- Summary -- Chapter 18: Advanced Access Query Techniques -- Using Calculated Fields -- Calculated Fields and the Expression Builder -- Counting Records in a Table or Query -- Finding the Top (n) Records in a Query -- How Queries Save Field Selections -- Query Design Options -- Setting Query Properties -- Creating Queries That Calculate Totals -- Creating Crosstab Queries -- Understanding Action Queries -- Summary -- Chapter 19: Advanced Access Form Techniques -- Setting Control Properties -- Working with Subforms -- Designing Forms -- Tackling Advanced Forms Techniques -- Using the Tab Control -- Using Dialog Boxes to Collect Information -- Summary -- Chapter 20: Advanced Access Report Techniques -- Grouping and Sorting Data -- Formatting Data -- Adding Data -- Trying More Techniques -- Summary -- Chapter 21: Building Multiuser Applications -- Working on a Network -- Considering the Options for Opening a Database -- Splitting a Database for Network Access.

Finding the Key to Locking Issues -- Reducing Multiuser Errors with Unbound Forms -- Summary -- Chapter 22: Integrating Access with Other Applications -- Using Automation in Access -- Looking at an Automation Example Using Word -- Collecting Data with Microsoft Outlook -- Summary -- Chapter 23: Handling Errors and Exceptions -- Dealing with Errors -- Identifying Which Errors Can Be Detected -- Trapping Errors with VBA -- Summary -- Part IV: Professional Database Development -- Chapter 24: Optimizing Access Applications -- Understanding Module Load on Demand -- Using the .accdb Database File Format -- Distributing .accde Files -- Understanding the Compiled State -- Improving Absolute Speed -- Improving Perceived Speed -- Working with Large Access Databases -- Summary -- Chapter 25: Advanced Data Access with VBA -- Adding an Unbound Combo Box to a Form to Find Data -- Filtering a Form -- Summary -- Chapter 26: Bulletproofing Access Applications -- Introducing Bulletproofing -- Looking at the Characteristics of Bulletproofed Applications -- Identifying the Principles of Bulletproofing -- Summary -- Chapter 27: Using the Windows Application Programming Interface -- What the Windows API Is -- Reasons to Use the Windows API -- DLL Documentation -- How to Use the Windows API -- API Examples -- Summary -- Chapter 28: Object-Oriented Programming with VBA -- Introducing Object-Oriented Programming -- Recognizing the Benefits of Object-Oriented Programming -- Using Property Procedures -- Modifying the Product Class -- Learning about Class Events -- Adding Events to Class Modules -- Summary -- Chapter 29: Customizing Access Ribbons -- Why Replace Toolbars and Menus? -- Working with the Access Ribbon -- Working with the Quick Access Toolbar -- Editing the Default Access Ribbon -- Developing Custom Access Ribbons -- The Ribbon Hierarchy.

Getting Started with Access Ribbons -- The Basic Ribbon XML -- Adding Ribbon Controls -- Using Visual Web Developer -- Managing Ribbons -- Completely Removing the Access Ribbon -- Summary -- Chapter 30: Using Access Macros -- An Introduction to Macros -- Multi-Action Macros -- Submacros -- Conditions -- Temporary Variables -- Error Handling and Macro Debugging -- Embedded Macros -- Macros versus VBA Statements -- Summary -- Chapter 31: Distributing Access Applications -- Defining the Current Database Options -- Testing the Application before Distribution -- Polishing Your Application -- Bulletproofing an Application -- Summary -- Part V: Access and Windows SharePoint Services -- Chapter 32: Understanding Windows SharePoint Services -- Introducing SharePoint -- Reviewing Various Types of SharePoint Sites -- Working with SharePoint Lists -- Looking at a SharePoint Web Site -- Summary -- Chapter 33: Integrating Access with SharePoint -- Introducing SharePoint as a Data Source -- Sharing Access Data with SharePoint -- Using SharePoint Templates -- Summary -- Chapter 34: Understanding Access Services -- Explaining Managed Applications -- Looking at Web Publishing in Access -- Understanding Access Services -- Examining Access Web Application Limits -- Summary -- Chapter 35: Deploying Access Applications to SharePoint -- Looking at SharePoint Deployment Options -- Dealing with Compatibility Checker Problems -- Summary -- Part VI: Access as an Enterprise Platform -- Chapter 36: Client/Server Concepts -- Looking at the Parts of Client/Server Architecture -- Making Sense of Multi-Tier Architecture -- Putting It All Together: Access, Client-Server, and Multiple Tiers -- Summary -- Chapter 37: SQL Server as an Access Companion -- Connecting to SQL Server -- Working with SQL Server Objects -- Summary -- Chapter 38: Upsizing Access Databases to SQL Server.

Introducing SQL Server Express.