Access 2003 Bible -- About the Author -- Credits -- Preface -- Is This Book for You? -- Conventions Used in This Book -- Icons and Alerts -- How This Book Is Organized -- Guide to the Examples -- Acknowledgments -- Contents at a Glance -- Contents -- Part I: Creating Desktop Applications -- Section I: Working with Data Tables and Queries -- Chapter 1: Understanding Data -- The Database Terminology of Access -- Using More Than One Table -- Access Database Objects and Views -- The Seven-Step Design Method -- Chapter 2: Creating and Building Tables -- Creating Database Tables -- Creating a Database -- The Database Window -- Creating a New Table -- The Table Design Window -- Creating the tblContacts Table -- Changing a Table Design -- Understanding Field Properties -- Determining the Primary Key -- Printing a Table Design -- Saving the Completed Table -- Manipulating Tables in a Database Window -- Adding Records to a Database Table -- Chapter 3: Entering Data into Tables and Forms -- Understanding Datasheets -- 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 -- Adding, Changing, and Deleting Columns -- Displaying Records -- Sorting and Filtering Records in a Datasheet -- Printing Records -- Chapter 4: Creating and Understanding Relationships -- Tables Used in the Access Auto Auctions Database -- Understanding Keys -- Understanding Relations between Tables -- Understanding Referential Integrity -- Creating Relationships -- Using Subdatasheets -- Chapter 5: Displaying Selected Data with Queries -- Understanding Queries -- Creating a Query -- Selecting Fields -- Displaying the Dynaset -- Working with Fields -- Changing the Sort Order.

Displaying Only Selected Records -- Printing a Query Dynaset -- Saving a Query -- Adding More than One Table to a Query -- Working with the Table/Query Pane -- Adding Fields from More than One Table -- Understanding the Limitations of Multiple-Table Queries -- Creating and Working with Query Joins -- Understanding Types of Table Joins -- Chapter 6: Using Operators and Expressions in Multi-table Select Queries -- What Are Operators? -- Moving beyond Simple Queries -- Entering Single-Value Field Criteria -- Entering Multiple Criteria in One Field -- Entering Criteria in Multiple Fields -- Creating a New Calculated Field in a Query -- Chapter 7: Working with External Data -- Access and External Data -- Linking External Data -- Working with Linked Tables -- Importing External Data -- Exporting to External Formats -- Section II: Building Forms and Reports -- Chapter 8: Understanding the Many Uses of Forms and Controls -- Understanding Forms -- Understanding Form Controls -- What Is a Control? -- Standards for Using Controls -- Chapter 9: Building and Manipulating Forms and Controls -- Creating a Form with Form Wizards -- Changing the Design -- Using the Form Window -- Displaying Your Data with a Form -- Saving a Record and the Form -- Printing a Form -- Creating New Controls -- Selecting Controls -- Manipulating Controls -- Chapter 10: Creating Bound Forms and Placing Controls -- Creating a Data-Entry Form without a Wizard -- Placing Bound Fields on a Form -- Adding a Form Header or Footer -- Working with Label Controls and Text Box Controls -- Setting the Tab Order -- Using Multiple-Line Text Box Controls for Memo Fields -- Working with Bound Object Frames on a Form -- Creating a Calculated Field -- Fixing a Picture's Display -- Printing a Form -- Converting a Form to a Report -- Chapter 11: Adding Data-Validation Features to Forms.

Creating Data-Validation Expressions -- Creating Choices with Option Groups and Buttons -- Creating Yes/No Options -- Creating Visual Selections with Toggle Buttons -- Working with List Boxes and Combo Boxes -- Creating and Using Combo Boxes -- Chapter 12: Creating Professional-Looking Forms and Reports -- Making a Good Form Look Great -- Enhancing Text-Based Controls -- Displaying Images in Forms -- Working with Lines and Rectangles -- Emphasizing Areas of the Form -- Adding a Background Bitmap -- Using AutoFormat -- Chapter 13: Understanding and Creating Reports -- Understanding Reports -- Creating a Report with Report Wizards -- Printing a Report -- Saving the Report -- Starting with a Blank Form -- Banded Report Writer Concepts -- Creating a New Report -- Making the Report Presentation Quality -- Chapter 14: Working with Subforms -- What Is a Subform? -- Creating Subforms with the Form Wizard -- Creating the Sales Invoice Form -- Creating a Subform Without Wizards -- Chapter 15: Creating Calculations and Summaries in Reports -- Designing a Full-Page Report with Embedded Subforms and Totals -- Creating a Multilevel Grouping Report with Totals -- Chapter 16: Presenting Data with Special Report Types -- Creating Mailing Labels Using the Label Wizard -- Creating Snaked-Column Reports -- Creating Mail Merge Reports -- Using the Access Mail Merge Wizard for Microsoft Word -- Chapter 17: Using OLE Objects, Graphs, Pivot Tables/Charts, and ActiveX Controls -- Understanding Objects -- Embedding Objects -- Linking Objects -- Creating a Graph or Chart -- Embedding a Graph in a Form -- Customizing a Graph -- Integration with Microsoft Office -- Using the Calendar ActiveX Control -- Section III: Automating Your Applications -- Chapter 18: Understanding Visual Basic and the VBA Editor -- Migrating from Macros to Visual Basic.

Creating Programs in Visual Basic for Applications -- Chapter 19: Introduction to Programming and Events -- Programming Events -- Form Event Procedures -- Control Event Procedures -- Report Event Procedures -- Report Section Event Procedures -- Using Variables -- Working with Data Types -- Understanding Visual Basic Logical Constructs -- Chapter 20: Working with Expressions and Functions -- What Are Expressions? -- What Are Functions? -- Chapter 21: Working with SQL, Recordsets, and ADO -- Understanding SQL -- Creating Programs to Update a Table -- Chapter 22: Automating, Searches, Filters, and Query Parameters -- Adding an Unbound Combo Box to Select One or More Records -- Using the FindRecord Command to Locate a Record -- Using the Bookmark to Locate a Record -- Filtering a Form Using Code -- Using a Query to Filter a Form Interactively -- Chapter 23: Calling Subprocedures and Functions -- Understanding the Difference Between a Subprocedure and a Function -- Creating Functions -- Creating a Function to Calculate Taxes -- Chapter 24: Effective Debugging and Error Handling in VBA -- Testing and Debugging Your Applications -- VBA Assistance: Auto Quick Info and Auto List Members -- Compiling Procedures -- Handling Runtime Errors -- Using the Immediate, Locals, and Watches Windows -- Creating a Breakpoint -- Errors -- Logging Errors -- Chapter 25: Creating Switchboards, Command Bars, Menus, Toolbars, and Dialog Boxes -- Switchboards and Command Buttons -- Working with the Switchboard Manager -- Creating Custom Menu Bars, Toolbars, and Shortcut Menus -- Creating a Print Report Dialog Box Form in Visual Basic -- Chapter 26: Programming Continuous Forms, Tab Dialogs, and Command Buttons -- Working with Tab Controls -- Programming Continuous Forms -- Common Code for Common Functions -- Part II: Creating Enterprise Applications.

Section IV: Upsizing to SQL Server and MSDE 2000 -- Chapter 27: Upsizing Data to a SQL Server Database -- Understanding MSDE 2000 -- Installing MSDE 2000 -- Starting the SQL Server 2000 Desktop Engine -- Using the Upsizing Wizard -- Chapter 28: Working with Access Projects -- Upsizing to an Access Project -- Using Unbound Forms -- Chapter 29: Working with Access Projects and SQL Server Tables and Queries -- Determining a Project's Database Name -- Working with Tables -- Understanding Project Queries -- Part III: Creating Web Applications -- Section V: Creating Data Access Pages and Using XML and InfoPath -- Chapter 30: Using and Creating Access Objects for Intranets and the Internet -- Types of Web Pages That Access Can Create -- Exporting Tables, Queries, Forms, and Reports to Web Pages -- Importing and Linking ( Read-Only) HTML Tables and Lists -- Using Hyperlinks to Connect Your Application to the Internet -- Chapter 31: Building and Working with Data Access Pages -- Working with the Data Access Pages -- Chapter 32: XML, Access, and InfoPath -- XML Data and Access -- Understanding XML -- Creating Your Own XML Documents -- Displaying XML Documents in Internet Explorer -- Exporting to XML -- Importing XML Data -- InfoPath and Access -- Part IV: Advanced Access Database Topics -- Chapter 33: Exchanging Data with Office Applications -- Using Automation to Integrate with Office -- An Automation Example Using Word -- Chapter 34: Adding Security to Applications -- Understanding Jet Security -- Choosing a Security Level to Implement -- Creating a Database Password -- Using the /runtime Option -- Using a Database's Startup Options -- Using the Jet User-Level Security Model -- Using the Access Security Wizard -- Encrypting a Database -- Decrypting a Database -- Protecting Visual Basic Code -- Preventing Virus Infections -- Chapter 35: Creating Help Systems.

Understanding the Windows Help Structure.