You are previewing Microsoft® Office Access 2003 Inside Out.
O'Reilly logo
Microsoft® Office Access 2003 Inside Out

Book Description

Take your database expertise to the next level! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds for Microsoft Office Access 2003 in concise, fast-answer format.

Table of Contents

  1. Microsoft® Office Access 2003 Inside Out
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. A Note Regarding Supplemental Files
    3. Acknowledgments
    4. We’d Like to Hear from You!
    5. About the CD
      1. What’s On the CD
      2. Sample Applications
      3. Using the CD
      4. System Requirements
      5. Support Information
    6. Conventions and Features Used in This Book
      1. Text Conventions
      2. Design Conventions
      3. Syntax Conventions
    7. Introduction
      1. Microsoft Access Today
      2. About This Book
    8. 1. Understanding Microsoft Access
      1. 1. What Is Microsoft Access?
        1. What Is a Database?
          1. Relational Databases
          2. Database Capabilities
        2. Microsoft Access as an RDBMS
          1. Data Definition and Storage
          2. Data Manipulation
          3. Data Control
        3. Microsoft Access as an Application Development System
        4. Deciding to Move to Database Software
      2. 2. The Many Faces of Microsoft Access
        1. The Architecture of Microsoft Access
        2. Exploring a Desktop Database—Housing Reservations
          1. Tables
            1. The Table Window in Design View
            2. The Table Window in Datasheet View
          2. Queries
            1. The Query Window in Design View
            2. The Query Window in Datasheet View
          3. Forms
            1. The Form Window in Design View
            2. The Form Window in Form View
          4. Reports
            1. The Report Window in Design View
            2. The Report Window in Print Preview
          5. Data Access Pages
            1. The Data Access Page Window in Design View
            2. The Data Access Page Window in Page View
          6. Macros
          7. Modules
          8. Organizing Your Objects
        3. Exploring a Project File—LawTrack Contacts
          1. Tables
          2. Views, Functions, and Stored Procedures
        4. The Many Faces of Microsoft Access
      3. 3. Designing Your Database Application
        1. Application Design Fundamentals
          1. Step 1: Identifying Tasks
          2. Step 2: Charting Task Flow
          3. Step 3: Identifying Data Elements
          4. Step 4: Organizing the Data
          5. Step 5: Designing a Prototype and a User Interface
          6. Step 6: Constructing the Application
          7. Step 7: Testing, Reviewing, and Refining
        2. An Application Design Strategy
          1. Analyzing the Tasks
          2. Selecting the Data
          3. Organizing Tasks
        3. Data Analysis
          1. Choosing the Database Subjects
          2. Mapping Subjects to Your Database
        4. Database Design Concepts
          1. Waste Is the Problem
          2. Normalization Is the Solution
            1. Field Uniqueness
            2. Primary Keys
            3. Functional Dependence
            4. Field Independence
          3. Efficient Relationships Are the Result
            1. Foreign Keys
            2. One-to-Many and One-to-One Relationships
            3. Creating Table Links
        5. When to Break the Rules
          1. Improving Performance of Critical Tasks
          2. Capturing Point-In-Time Data
          3. Creating Report Snapshot Data
    9. 2. Building a Microsoft Access Desktop Application
      1. 4. Creating Your Database and Tables
        1. Creating a New Database
          1. Using a Database Template to Create a Database
          2. Creating a New Empty Database
        2. Creating Your First Simple Table by Entering Data
        3. Creating a Table Using the Table Wizard
        4. Creating a Table in Design View
        5. Defining Fields
          1. Understanding Field Data Types
          2. Setting Field Properties
          3. Completing the Fields in the Companies Table
          4. Defining Simple Field Validation Rules
          5. Defining Input Masks
        6. Defining a Primary Key
        7. Defining a Table Validation Rule
        8. Understanding Other Table Properties
        9. Defining Relationships
          1. Defining Your First Relationship
          2. Creating a Relationship on Multiple Fields
        10. Adding Indexes
          1. Single Field Indexes
          2. Multiple-Field Indexes
        11. Setting Table Design Options
        12. Printing a Table Definition
        13. Database Limitations
      2. 5. Modifying Your Table Design
        1. Before You Get Started
          1. Making a Backup Copy
          2. Checking Object Dependencies
        2. Deleting Tables
        3. Renaming Tables
        4. Changing Field Names
        5. Moving Fields
        6. Inserting Fields
        7. Copying Fields
        8. Deleting Fields
        9. Changing Data Attributes
          1. Changing Data Types
          2. Changing Data Lengths
          3. Dealing with Conversion Errors
          4. Changing Other Field Properties
        10. Reversing Changes
        11. Using the Table Analyzer Wizard
        12. Taking a Look at Lookup Properties
        13. Changing the Primary Key
        14. Compacting Your Database
      3. 6. Importing and Linking Data
        1. A Word About Open Database Connectivity (ODBC)
        2. Importing vs. Linking Database Files
        3. Importing Data and Databases
          1. Importing dBASE Files
          2. Importing Paradox Files
          3. Importing SQL Tables
          4. Importing Access Objects
        4. Importing Spreadsheet Data
          1. Preparing a Spreadsheet
          2. Importing a Spreadsheet
          3. Fixing Errors
        5. Importing Text Files
          1. Preparing a Text File
            1. Setting Up Delimited Data
            2. Setting Up Fixed-Width Data
          2. Importing a Text File
          3. Fixing Errors
        6. Modifying Imported Tables
        7. Linking Files
          1. Security Considerations
          2. Performance Considerations
          3. Linking Access Tables
          4. Linking dBASE and Paradox Files
          5. Linking Text and Spreadsheet Files
          6. Linking SQL Tables
          7. Modifying Linked Tables
          8. Unlinking Linked Tables
          9. Using the Linked Table Manager
      4. 7. Creating and Working with Simple Queries
        1. Selecting Data from a Single Table
          1. Specifying Fields
          2. Setting Field Properties
          3. Entering Selection Criteria
            1. Working with Dates and Times in Criteria
            2. AND vs. OR
            3. Between, In, and Like
          4. Using Expressions
            1. Creating Text Expressions
            2. Defining Arithmetic Expressions
          5. Using the Expression Builder
          6. Specifying Field Names
          7. Sorting Data
        2. Testing Validation Rule Changes
          1. Checking a New Field Validation Rule
          2. Checking a New Table Validation Rule
        3. Working in Query Datasheet View
          1. Moving Around and Using Keyboard Shortcuts
          2. Working with Subdatasheets
          3. Changing Data
            1. Understanding Record Indicators
            2. Adding a New Record
            3. Selecting and Changing Data
            4. Replacing Data
            5. Copying and Pasting Data
            6. Deleting Rows
          4. Working with Hyperlinks
            1. Activating a Hyperlink
            2. Inserting a New Hyperlink
            3. Editing an Existing Hyperlink
          5. Sorting and Searching for Data
            1. Sorting Data
            2. Searching for and Filtering Data
      5. 8. Building Complex Queries
        1. Selecting Data from Multiple Tables
          1. Creating Inner Joins
          2. Building a Query on a Query
          3. Using Outer Joins
            1. Building a Simple Outer Join
            2. Solving a Complex "Unmatched" Problem
        2. Using a Query Wizard
        3. Summarizing Information with Totals Queries
          1. Totals Within Groups
          2. Selecting Records to Form Groups
          3. Selecting Specific Groups
          4. Building Crosstab Queries
            1. Creating a Simple Crosstab Query
          5. Partitioning Data in a Crosstab Query
        4. Using Query Parameters
        5. Customizing Query Properties
          1. Controlling Query Output
          2. Working with Unique Records and Values
          3. Defining a Subdatasheet
          4. Other Query Properties
        6. Editing and Creating Queries in SQL View
        7. Limitations on Using Select Queries to Update Data
        8. Creating PivotTables and PivotCharts from Queries
          1. Building a Query for a PivotTable
          2. Designing a PivotTable
          3. Designing a PivotChart
      6. 9. Modifying Data with Action Queries
        1. Updating Groups of Rows
          1. Testing with a Select Query
          2. Converting a Select Query to an Update Query
          3. Running an Update Query
          4. Updating Multiple Fields
            1. Creating an Update Query Using Multiple Tables or Queries
        2. Creating a New Table with a Make-Table Query
          1. Creating a Make-Table Query
          2. Running a Make-Table Query
        3. Inserting Data from Another Table
          1. Creating an Append Query
          2. Running an Append Query
        4. Deleting Groups of Rows
          1. Testing with a Select Query
          2. Using a Delete Query
          3. Deleting Inactive Data
        5. Troubleshooting Action Queries
          1. Solving Common Action Query Errors and Problems
          2. Looking at an Error Example
    10. 3. Creating Forms and Reports in a Desktop Application
      1. 10. Using Forms
        1. Uses of Forms
        2. A Tour of Forms
          1. Headers, Detail Sections, and Footers
          2. Multiple-Page Forms
          3. Continuous Forms
          4. Subforms
          5. Pop-Up Forms
          6. Modal Forms
          7. Special Controls
            1. Option Buttons, Check Boxes, Toggle Buttons, and Option Groups
            2. List Boxes and Combo Boxes
            3. Tab Controls
            4. ActiveX Objects
            5. Command Buttons
          8. PivotTables and PivotCharts
        3. Moving Around on Forms and Working with Data
          1. Viewing Data
            1. Moving Around
            2. Keyboard Shortcuts
          2. Adding Records and Changing Data
            1. Adding a New Record
            2. Changing and Deleting Data
        4. Searching for and Sorting Data
          1. Performing a Simple Search
          2. Performing a Quick Sort on a Form Field
          3. Adding a Filter to a Form
        5. Printing Forms
      2. 11. Building a Form
        1. Forms and Object-Oriented Programming
        2. Starting from Scratch—A Simple Input Form
          1. Building a New Form with Design Tools
            1. The Toolbox
            2. The Field List
            3. The Property Sheet
          2. Building a Simple Input Form for the tblCompanies Table
            1. Moving and Sizing Controls
            2. The Formatting Toolbar
            3. Setting Text Box Properties
            4. Setting Label Properties
            5. Setting Form Properties
          3. Customizing Colors and Checking Your Design Results
        3. Working with Form Wizards
          1. Creating the Basic Products Form with a Form Wizard
          2. Modifying the Products Form
        4. Simplifying Data Input with a Form
          1. Taking Advantage of Combo Boxes and List Boxes
          2. Using Toggle Buttons, Check Boxes, and Option Buttons
      3. 12. Customizing a Form
        1. Aligning and Sizing Controls
          1. Sizing Controls to Fit Content
          2. Adjusting Control Layout
          3. "Snapping" Controls to the Grid
          4. Lining Up Controls
        2. Enhancing the Look of a Form
          1. Lines and Rectangles
          2. Colors and Special Effects
          3. Fonts
        3. Setting Control Properties
          1. Formatting Properties
            1. Specifying a Format for Numbers and Currency
            2. Specifying a Format for Text
            3. Specifying a Format for Date/Time
            4. Specifying a Format for Yes/No Fields
          2. Adding a Scroll Bar
          3. Enabling and Locking Controls
          4. Setting the Tab Order
          5. Adding a Smart Tag
          6. Understanding Other Control Properties
        4. Setting Form Properties
          1. Allowing Different Views
          2. Setting Navigation Options
          3. Defining a Pop-Up and/or Modal Form
          4. Controlling Edits, Deletions, Additions, and Filtering
          5. Defining Window Controls
          6. Setting the Border Style
          7. Understanding Other Form Properties
        5. Setting Form and Control Defaults
          1. Changing Control Defaults
          2. Working with AutoFormat
          3. Defining a Template Form
      4. 13. Advanced Form Design
        1. Basing a Form on a Multiple-Table Query
          1. Creating a Many-to-One Form
            1. Designing a Many-to-One Query
            2. Designing a Many-to-One Form
        2. Creating and Embedding Subforms
          1. Specifying the Subform Source
          2. Designing the Innermost Subform
          3. Designing the First Level Subform
          4. Embedding a Subform
          5. Specifying the Main Form Source
          6. Creating the Main Form
          7. Creating a Subdatasheet Subform
        3. Displaying Values in an Option Group
        4. Using Conditional Formatting
        5. Working with the Tab Control
        6. Creating Multiple-Page Forms
        7. Introducing ActiveX Controls—The Calendar Control
        8. Working with PivotChart Forms
          1. Building a PivotChart Form
          2. Embedding a Linked PivotChart
      5. 14. Using Reports
        1. Uses of Reports
        2. A Tour of Reports
          1. Print Preview—A First Look
          2. Headers, Detail Sections, Footers, and Groups
          3. Subreports
          4. Objects in Reports
        3. Printing Reports
          1. Print Setup
      6. 15. Constructing a Report
        1. Starting from Scratch—A Simple Report
          1. Building the Report Query
          2. Designing the Report
          3. Sorting and Grouping Information
          4. Completing the Report
        2. Using a Report Wizard
          1. Selecting a Report Type
          2. Specifying Wizard Options
          3. Viewing the Result
      7. 16. Advanced Report Design
        1. Building a Query for a Complex Report
        2. Creating the Basic Facility Occupancy by Date Report
        3. Defining the Sorting and Grouping Criteria
        4. Setting Section and Report Properties
          1. Section Properties
          2. Report Properties
        5. Using Calculated Values
          1. Adding the Print Date and Page Numbers
          2. Performing Calculations
            1. Performing a Calculation on a Detail Line
            2. Adding Values Across a Group
            3. Creating a Grand Total
          3. Hiding Redundant Values and Concatenating Text Strings
          4. Calculating Percentages
          5. Using Running Sum
          6. Taking Advantage of Conditional Formatting
        6. Creating and Embedding a Subreport
          1. Understanding Subreport Challenges
          2. Building a Report with a Subreport
            1. Building the Subreport Query
            2. Designing the Subreport
            3. Embedding a Subreport
        7. Adding a PivotChart to a Report
          1. Designing the PivotChart Form
          2. Embedding a PivotChart in a Report
    11. 4. Designing an Access Project
      1. 17. Building Tables in an Access Project
        1. Creating a New Project File
          1. Building a New SQL Server Database
          2. Connecting to an Existing SQL Server Database
        2. Creating a Table in Design View
        3. Defining Columns
          1. Column Data Types
          2. Completing the Columns in the Companies Table
          3. Understanding Column Properties
        4. Defining a Primary Key
        5. Adding Indexes
        6. Creating Additional Tables in Contact Tracking
        7. Defining Check Constraints
          1. Creating Additional Constraint Expressions
        8. Defining Relationships
          1. Defining Relationships in Table Design View
          2. Defining Relationships Using Database Diagrams
        9. Setting Table Design Options
      2. 18. Building Queries in an Access Project
        1. Building Queries Using the Query Designer
          1. Understanding the Query Designer
            1. Adding Tables, Views, and Functions
            2. The Panes in the Query Designer
            3. Selecting Columns
            4. Working in the Diagram Pane
            5. Working in the Grid Pane
            6. Viewing Other Properties
          2. Working with Views
          3. Working with In-Line Functions
          4. Working with Stored Procedures
        2. Building Queries Using a Text Editor
          1. Building a Text Stored Procedure
            1. Beginning a New Stored Procedure in the Text Editor
            2. Re-creating the Stored Procedure from the Query Designer Example
            3. Adding Control-of-Flow Statements to Your Stored Procedure
            4. Grouping Multiple Statements with Transactions
          2. Building a Text Scalar Function
          3. Building a Text Table-Valued Function
      3. 19. Designing Forms in an Access Project
        1. Understanding Form Differences in an Access Project
          1. Choosing Option Settings
          2. Setting Project Form Properties
        2. Setting Recordset Type
        3. Understanding Max Records
        4. Working with Server Filters
        5. Setting Input Parameters
      4. 20. Building Reports in an Access Project
        1. Understanding Report Differences in an Access Project
          1. Setting Project Report Properties
        2. Working with Server Filters
        3. Working with Input Parameters
    12. 5. Automating an Access Application
      1. 21. Understanding Event Processing
        1. Access as a Windows Event-Driven Application
          1. Understanding Events in Windows
          2. Leveraging Access Events to Build an Application
        2. Summary of Form and Report Events
          1. Opening and Closing Forms and Reports
          2. Changing Data
          3. Detecting Focus Changes
          4. Detecting Filters Applied to Forms
          5. Trapping Keyboard and Mouse Events
          6. Detecting Changes in PivotTables and PivotCharts
          7. Printing
          8. Trapping Errors
          9. Detecting Timer Expiration
        3. Understanding Event Sequence and Form Editing
        4. Summary of Macro Actions
          1. Opening and Closing Access Objects
          2. Printing Data
          3. Executing a Query
          4. Testing Conditions and Controlling Action Flow
          5. Setting Values
          6. Searching for Data
          7. Building a Custom Menu and Executing Menu Commands
          8. Controlling Display and Focus
          9. Informing the User of Actions
          10. Renaming, Copying, Deleting, Saving, Importing, and Exporting Objects
          11. Running Another Application
        5. The Macro Design Facility—An Overview
          1. Working with the Macro Design Window
            1. Saving Your Macro
            2. Testing Your Macro
          2. Defining Multiple Actions
          3. Grouping Macros
          4. Conditional Expressions
          5. Converting Your Macros to Visual Basic
      2. 22. Understanding Visual Basic Fundamentals
        1. The Visual Basic Development Environment
          1. Modules
            1. Module Objects
            2. Form and Report Modules
          2. The Visual Basic Editor Window
          3. Working with Visual Basic Debugging Tools
            1. Setting Breakpoints
            2. Using the Immediate Window
            3. Working with the Watch Window
            4. Examining the Procedure Call Sequence (Call Stack)
        2. Variables and Constants
          1. Data Types
          2. Variable and Constant Scope
        3. Declaring Constants and Variables
          1. Const Statement
            1. Syntax
            2. Notes
            3. Example
          2. Dim Statement
            1. Syntax
            2. Notes
            3. Examples
          3. Enum Statement
            1. Syntax
            2. Notes
            3. Example
          4. Event Statement
            1. Syntax
            2. Notes
            3. Example
          5. Private Statement
            1. Syntax
            2. Notes
            3. Example
          6. Public Statement
            1. Syntax
            2. Notes
            3. Example
          7. ReDim Statement
            1. Syntax
            2. Notes
            3. Example
          8. Static Statement
            1. Syntax
            2. Notes
            3. Examples
          9. Type Statement
            1. Syntax
            2. Notes
            3. Example
        4. Collections, Objects, Properties, and Methods
          1. The Access Application Architecture
          2. The Data Access Objects (DAO) Architecture
          3. The ActiveX Data Objects (ADO) Architecture
          4. Referencing Collections, Objects, and Properties
            1. When to Use "!" and "."
          5. Assigning an Object Variable—Set Statement
            1. Syntax
            2. Notes
            3. Examples
          6. Object Methods
            1. Working with DAO Recordsets
            2. Working with ADO Recordsets
            3. Other Uses for Object Methods
        5. Functions and Subroutines
          1. Function Statement
            1. Syntax
            2. Notes
            3. Example
          2. Sub Statement
            1. Syntax
            2. Notes
            3. Example
        6. Understanding Class Modules
          1. Property Get
            1. Syntax
            2. Notes
            3. Examples
          2. Property Let
            1. Syntax
            2. Notes
            3. Examples
          3. Property Set
            1. Syntax
            2. Notes
            3. Examples
        7. Controlling the Flow of Statements
          1. Call Statement
            1. Syntax
            2. Notes
            3. Examples
          2. Do…Loop Statement
            1. Syntax
            2. Notes
            3. Example
          3. For…Next Statement
            1. Syntax
            2. Notes
            3. Example
          4. For Each…Next Statement
            1. Syntax
            2. Notes
            3. Example
          5. GoTo Statement
            1. Syntax
            2. Notes
            3. Example
          6. If…Then…Else Statement
            1. Syntax
            2. Notes
            3. Example
          7. RaiseEvent Statement
            1. Syntax
            2. Notes
            3. Example
          8. Select Case Statement
            1. Syntax
            2. Notes
            3. Example
          9. Stop Statement
            1. Syntax
            2. Notes
          10. While…Wend Statement
            1. Syntax
            2. Notes
            3. Example
          11. With…End With Statement
            1. Syntax
            2. Example
        8. Running Macro Actions and Menu Commands
          1. DoCmd Object
            1. Syntax
            2. Notes
            3. Examples
          2. Executing a Menu Command
            1. Syntax
            2. Notes
            3. Examples
          3. Actions with Visual Basic Equivalents
        9. Trapping Errors
          1. On Error Statement
            1. Syntax
            2. Notes
            3. Examples
        10. Some Complex Visual Basic Examples
          1. A Procedure to Randomly Load Data
          2. A Procedure to Examine All Error Codes
      3. 23. Automating Your Application with Visual Basic
        1. Why Aren’t We Using Macros?
          1. When to Use Macros
          2. When to Use Visual Basic
        2. Assisting Data Entry
          1. Filling In Related Data
          2. Handling the NotInList Event
          3. Fixing an E-Mail Hyperlink
          4. Providing a Graphical Calendar
          5. Working with Linked Photos
            1. Displaying a Linked Photo
            2. Deleting and Updating an Image Path
        3. Validating Complex Data
          1. Checking for Possible Duplicate Names
          2. Testing for Related Records When Deleting a Record
          3. Verifying a Prerequisite
          4. Maintaining a Special Unique Value
          5. Checking for Overlapping Data
        4. Controlling Tabbing on a Multiple-Page Form
        5. Automating Data Selection
          1. Working with a Multiple-Selection List Box
          2. Providing a Custom Query By Form
          3. Selecting from a Summary List
          4. Filtering One List with Another
        6. Linking to Related Data in Another Form or Report
          1. Linking Forms Using a Filter
          2. Linking to a Report Using a Filter
          3. Synchronizing Two Forms Using a Class Event
        7. Automating Complex Tasks
          1. Triggering a Data Task from a Related Form
          2. Linking to a Related Task
          3. Calculating a Stored Value
        8. Automating Reports
          1. Allowing for Used Mailing Labels
          2. Drawing on a Report
          3. Dynamically Filtering a Report When It Opens
      4. 24. The Finishing Touches
        1. Creating Custom Menus and Toolbars
          1. Understanding the Customize Toolbar Facility
          2. Creating a Custom Form Toolbar
            1. Defining a New Toolbar
            2. Customizing Your New Toolbar
          3. Creating a Custom Form Menu Bar
          4. Creating Custom Shortcut Menus
          5. Setting Form, Form Control, and Report Menu and Toolbar Properties
        2. Fine-Tuning with the Performance Analyzer Wizard
        3. Disabling Form Design View
        4. Defining Switchboard Forms
          1. Designing a Switchboard Form from Scratch
          2. Using the Switchboard Manager to Design Switchboard Forms
        5. Controlling How Your Application Starts and Runs
          1. Setting Startup Properties for Your Database
          2. Starting and Stopping Your Application
          3. Creating an AutoKeys Macro
        6. Performing a Final Visual Basic Compile
    13. 6. Linking Access and the Web
      1. 25. Publishing Data on the Web
        1. Working with the Web
          1. Understanding HTML
            1. Introducing HTML Coding
            2. Tag Members
            3. Editing HTML
          2. Introducing XML
        2. Maintaining Static Web Pages
        3. Creating Dynamic Web Pages
          1. Delivering Dynamic Query Results
          2. Processing Live Data with HTML Forms
            1. Microsoft Office FrontPage 2003
            2. Visual Studio.NET and ASP.NET
            3. Data Access Pages in Access 2003
        4. Sharing Your Data with SharePoint
          1. Introducing SharePoint
          2. Office and SharePoint
        5. Discovering the Possibilities
          1. Viewing Static HTML Pages
          2. Exploring Active Server Pages
          3. Looking at Data Access Pages
      2. 26. Creating Static and Dynamic Web Pages
        1. Creating a Static HTML Document
          1. Improving the Look of Exported Data in HTML
            1. Customizing Datasheet View
            2. Designing and Using HTML Output Templates
          2. Generating an HTML Page from an Access Report
            1. Creating a Template for a Report
            2. Exporting a Report with a Template
          3. Writing HTML from Visual Basic
        2. Creating a Dynamic Active Server Page
          1. Defining a System Data Source
          2. Exporting Access Data to an Active Server Page
          3. Programming Active Server Pages
            1. Programming an Active Server Page to Use Parameters
            2. Creating a Page to Filter an Active Server Page
      3. 27. Building Data Access Pages
        1. Introducing Data Access Pages
          1. Underlying Structure of a Data Access Page
          2. Usefulness and Limitations
          3. Types of Pages You Can Create
        2. Designing Data Access Pages
          1. Setting Options for Data Access Pages
          2. Creating Pages Using the Wizards
          3. Understanding the Data Access Page Design Facility
            1. Elements You Can Add to a Data Access Page
            2. Moving, Sizing, and Aligning Data Access Page Elements
          4. Modifying a Wizard-Generated Data Access Page
            1. Adding a Heading to the Page
            2. Changing the Group Filter Control
            3. Modifying Record Navigation Controls
            4. Rearranging Controls
            5. Making Read-Only Sections Updatable
            6. Displaying a Bound Image
          5. Generating Data Access Pages from Forms and Reports
          6. Creating a Data Access Page in Design View
            1. Selecting a Data Source
            2. Adding Fields to Display
            3. Creating a Grouping Level
            4. Designing a Data Access Page with a PivotChart
        3. Automating Data Access Pages
          1. Using the Microsoft Script Editor with Data Access Pages
          2. Creating Scripts for Data Access Pages
            1. Understanding the Data Source Control Events
            2. Checking for Valid Data
            3. Creating a Primary Key Value for a New Record
            4. Setting a Cookie and Opening a Related Web Page
        4. Updating Data Access Page Links and Connections
          1. Updating Links from Access to Data Access Pages
          2. Updating Connections
            1. Specifying a ConnectionString Property
            2. Specifying a ConnectionFile Property
          3. Updating Links and Connections from Within Visual Basic
        5. Uploading Your Pages to a Web Server
          1. Copying Pages Using the Windows XP My Web Sites
          2. Publishing Pages Using FTP
      4. 28. Working with XML and SharePoint
        1. Exploring XML
          1. Well-Formed XML
          2. Understanding XML File Types
            1. The XML Data Document (.xml)
            2. The Schema File (.xsd)
            3. The Presentation (Layout) Document (.xsl)
            4. The Web Package (.htm)
        2. Using XML in Microsoft Access
          1. Exporting and Importing XML from the User Interface
            1. Exporting Access Tables and Queries
            2. Exporting Access Forms and Reports
            3. Importing XML Files
          2. Importing and Exporting XML in Visual Basic
        3. Working with SharePoint
          1. Using SharePoint from Access
            1. Exporting Data to SharePoint
            2. Importing a List from SharePoint
            3. Linking a SharePoint List into Access
          2. Using Access from SharePoint
            1. Exporting a List to an Access Database
            2. Link a List into an Access Database
            3. Create an Access Report on a SharePoint List
    14. 7. After Completing Your Application
      1. 29. Upsizing a Desktop Application to a Project
        1. Benefits of the Client/Server Architecture
        2. Deciding When to Upsize
        3. Deciding on a Strategy
          1. Upsizing Using the Import Facility
          2. Using the Upsizing Wizard
        4. Preparing Your Desktop Database
          1. General Upsizing Considerations
          2. Preparing Your Tables
          3. Modifying Queries
          4. Changing Forms and Reports
          5. Modifying Your Code
        5. Using the Upsizing Wizard
          1. Ensuring That Your Server Is Started
          2. Running the Wizard
          3. Starting Over If the Wizard Fails
        6. Correcting the Upsize Result
          1. Adding Relationships and Constraints and Fixing Indexes
          2. Correcting Query Problems
            1. Creating Missing Queries
            2. Changing Functions to Views
            3. Fixing Parameter Names in Functions and Stored Procedures
          3. Fixing Parameters in Forms and Reports
          4. Fixing Combo Boxes and List Boxes That Use a Large Row Source
      2. 30. Securing Your Database
        1. Securing a Desktop Database
          1. Access Security Architecture
          2. Users, Groups, and Permissions
            1. Built-In Users and Groups
            2. Object Permissions
            3. Explicit and Implicit Permissions
          3. Using the Security Wizard
            1. Preliminary Preparations
            2. Running the Wizard
          4. Setting Up Your Secured Database
        2. Security Considerations in a Project File
        3. Understanding Macro Security
      3. 31. Distributing Your Application
        1. Using Linked Tables in a Desktop Database
          1. Taking Advantage of the Database Splitter Utility
          2. Creating Startup Code to Verify and Correct Linked Table Connections
        2. Verifying Server Connection in a Project File
        3. Understanding Runtime Mode
        4. Creating an Execute-Only Database
        5. Creating an Application Shortcut
        6. Understanding the Visual Studio Tools for the Microsoft Office System
    15. 8. Appendix
      1. Installing Microsoft Office
        1. Installing Microsoft Office
          1. Choosing Options When You Have No Previous Version of Office
          2. Choosing Options to Upgrade a Previous Version of Office
        2. Installing the Microsoft SQL Server Data Engine (MSDE)
        3. Managing ODBC Connections
          1. Creating an ODBC System Data Source Name for Microsoft Access
          2. Using ODBC for Connecting to Microsoft SQL Server
        4. Converting from a Previous Release of Microsoft Access
          1. Conversion Issues
        5. Creating an Office Toolbar in Windows XP
      2. Index to Troubleshooting Topics
      3. About the Author
    16. Index
    17. SPECIAL OFFER: Upgrade this ebook with O’Reilly