Microsoft Office Access 2003 Inside Out

Table of Contents

Acknowledgments; We’d Like to Hear from You!; About the CD; What’s On the CD; Sample Applications; Using the CD; System Requirements; Support Information; Conventions and Features Used in This Book; Text Conventions; Design Conventions; Syntax Conventions; Introduction; Microsoft Access Today; About This Book; Part 1: Understanding Microsoft Access; Chapter 1: What Is Microsoft Access?; What Is a Database?; Microsoft Access as an RDBMS; Microsoft Access as an Application Development System; Deciding to Move to Database Software; Chapter 2: The Many Faces of Microsoft Access; The Architecture of Microsoft Access; Exploring a Desktop Database—Housing Reservations; Exploring a Project File—LawTrack Contacts; The Many Faces of Microsoft Access; Chapter 3: Designing Your Database Application; Application Design Fundamentals; An Application Design Strategy; Data Analysis; Database Design Concepts; When to Break the Rules; Part 2: Building a Microsoft Access Desktop Application; Chapter 4: Creating Your Database and Tables; Creating a New Database; Creating Your First Simple Table by Entering Data; Creating a Table Using the Table Wizard; Creating a Table in Design View; Defining Fields; Defining a Primary Key; Defining a Table Validation Rule; Understanding Other Table Properties; Defining Relationships; Adding Indexes; Setting Table Design Options; Printing a Table Definition; Database Limitations; Chapter 5: Modifying Your Table Design; Before You Get Started; Deleting Tables; Renaming Tables; Changing Field Names; Moving Fields; Inserting Fields; Copying Fields; Deleting Fields; Changing Data Attributes; Reversing Changes; Using the Table Analyzer Wizard; Taking a Look at Lookup Properties; Changing the Primary Key; Compacting Your Database; Chapter 6: Importing and Linking Data; A Word About Open Database Connectivity (ODBC); Importing vs. Linking Database Files; Importing Data and Databases; Importing Spreadsheet Data; Importing Text Files; Modifying Imported Tables; Linking Files; Chapter 7: Creating and Working with Simple Queries; Selecting Data from a Single Table; Testing Validation Rule Changes; Working in Query Datasheet View; Chapter 8: Building Complex Queries; Selecting Data from Multiple Tables; Using a Query Wizard; Summarizing Information with Totals Queries; Using Query Parameters; Customizing Query Properties; Editing and Creating Queries in SQL View; Limitations on Using Select Queries to Update Data; Creating PivotTables and PivotCharts from Queries; Chapter 9: Modifying Data with Action Queries; Updating Groups of Rows; Creating a New Table with a Make-Table Query; Inserting Data from Another Table; Deleting Groups of Rows; Troubleshooting Action Queries; Part 3: Creating Forms and Reports in a Desktop Application; Chapter 10: Using Forms; Uses of Forms; A Tour of Forms; Moving Around on Forms and Working with Data; Searching for and Sorting Data; Printing Forms; Chapter 11: Building a Form; Forms and Object-Oriented Programming; Starting from Scratch—A Simple Input Form; Working with Form Wizards; Simplifying Data Input with a Form; Chapter 12: Customizing a Form; Aligning and Sizing Controls; Enhancing the Look of a Form; Setting Control Properties; Setting Form Properties; Setting Form and Control Defaults; Chapter 13: Advanced Form Design; Basing a Form on a Multiple-Table Query; Creating and Embedding Subforms; Displaying Values in an Option Group; Using Conditional Formatting; Working with the Tab Control; Creating Multiple-Page Forms; Introducing ActiveX Controls—The Calendar Control; Working with PivotChart Forms; Chapter 14: Using Reports; Uses of Reports; A Tour of Reports; Printing Reports; Chapter 15: Constructing a Report; Starting from Scratch—A Simple Report; Using a Report Wizard; Chapter 16: Advanced Report Design; Building a Query for a Complex Report; Creating the Basic Facility Occupancy by Date Report; Defining the Sorting and Grouping Criteria; Setting Section and Report Properties; Using Calculated Values; Creating and Embedding a Subreport; Adding a PivotChart to a Report; Part 4: Designing an Access Project; Chapter 17: Building Tables in an Access Project; Creating a New Project File; Creating a Table in Design View; Defining Columns; Defining a Primary Key; Adding Indexes; Creating Additional Tables in Contact Tracking; Defining Check Constraints; Defining Relationships; Setting Taaaaaable Design Options; Chapter 18: Building Queries in an Access Project; Building Queries Using the Query Designer; Building Queries Using a Text Editor; Chapter 19: Designing Forms in an Access Project; Understanding Form Differences in an Access Project; Setting Recordset Type; Understanding Max Records; Working with Server Filters; Setting Input Parameters; Chapter 20: Building Reports in an Access Project; Understanding Report Differences in an Access Project; Working with Server Filters; Working with Input Parameters; Part 5: Automating an Access Application; Chapter 21: Understanding Event Processing; Access as a Windows Event-Driven Application; Summary of Form and Report Events; Understanding Event Sequence and Form Editing; Summary of Macro Actions; The Macro Design Facility—An Overview; Chapter 22: Understanding Visual Basic Fundamentals; The Visual Basic Development Environment; Variables and Constants; Declaring Constants and Variables; Collections, Objects, Properties, and Methods; Functions and Subroutines; Understanding Class Modules; Controlling the Flow of Statements; Running Macro Actions and Menu Commands; Trapping Errors; Some Complex Visual Basic Examples; Chapter 23: Automating Your Application with Visual Basic; Why Aren’t We Using Macros?; Assisting Data Entry; Validating Complex Data; Controlling Tabbing on a Multiple-Page Form; Automating Data Selection; Linking to Related Data in Another Form or Report; Automating Complex Tasks; Automating Reports; Chapter 24: The Finishing Touches; Creating Custom Menus and Toolbars; Fine-Tuning with the Performance Analyzer Wizard; Disabling Form Design View; Defining Switchboard Forms; Controlling How Your Application Starts and Runs; Performing a Final Visual Basic Compile; Part 6: Linking Access and the Web; Chapter 25: Publishing Data on the Web; Working with the Web; Maintaining Static Web Pages; Creating Dynamic Web Pages; Sharing Your Data with SharePoint; Discovering the Possibilities; Chapter 26: Creating Static and Dynamic Web Pages; Creating a Static HTML Document; Creating a Dynamic Active Server Page; Chapter 27: Building Data Access Pages; Introducing Data Access Pages; Designing Data Access Pages; Automating Data Access Pages; Updating Data Access Page Links and Connections; Uploading Your Pages to a Web Server; Chapter 28: Working with XML and SharePoint; Exploring XML; Using XML in Microsoft Access; Working with SharePoint; Part 7: After Completing Your Application; Chapter 29: Upsizing a Desktop Application to a Project; Benefits of the Client/Server Architecture; Deciding When to Upsize; Deciding on a Strategy; Preparing Your Desktop Database; Using the Upsizing Wizard; Correcting the Upsize Result; Chapter 30: Securing Your Database; Securing a Desktop Database; Security Considerations in a Project File; Understanding Macro Security; Chapter 31: Distributing Your Application; Using Linked Tables in a Desktop Database; Verifying Server Connection in a Project File; Understanding Runtime Mode; Creating an Execute-Only Database; Creating an Application Shortcut; Understanding the Visual Studio Tools for the Microsoft Office System; Part 8: Appendix; Appendix : Installing Microsoft Office; Installing Microsoft Office; Installing the Microsoft SQL Server Data Engine (MSDE); Managing ODBC Connections; Converting from a Previous Release of Microsoft Access; Creating an Office Toolbar in Windows XP; Appendix : Index to Troubleshooting Topics; Appendix : About the Author;

John L. Viescas is a database expert who provides consulting and training services to companies around the globe. He is the author of numerous books, including Running Microsoft Access 97, Running Microsoft Access 2000, Microsoft Office Access 2003 Inside Out, Building Microsoft Access Applications, and Microsoft Office Access 2007 Inside Out. John has been recognized as a Microsoft MVP since 1993.

Home Page: Viescas Consulting, Inc.