Microsoft Office® Access 2007 Inside Out

Microsoft Office® Access 2007 Inside Out

by John Viescas and Jeff Conrad
Released April 2007
Publisher(s): Microsoft Press
ISBN: 9780735623255

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

You’re beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle Access 2007—and challenge yourself to new levels of mastery!

  • Create tables that support your database design strategy

  • Import and link to data from spreadsheets, text files, databases, and other ODBC data sources

  • Build simple to complex queries to manipulate data

  • Learn advanced techniques for building and customizing user interface forms

  • Design attractive reports to calculate and analyze large sets of data

  • Automate your application with Microsoft Visual Basic(R) for Applications

  • Customize the Office Fluent Ribbon

  • Explore using XML and Windows(R) SharePoint(R) Services to create Web-based applications



    • CD includes:

  • Fully searchable eBook—plus bonus chapters

  • Sample database applications—including query, form, and report examples

  • Articles from the experts: designing databases, understanding SQL, exporting data, and more

  • Links to demos, blogs, and user communities

  • References for finding Access 2003 commands in Access 2007

  • Windows Vista(R) Product Guide eReference and other eBooks



    • For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

    Table of contents

    1. Microsoft Office® Access 2007 Inside Out
    2. A Note Regarding Supplemental Files
    3. Acknowledgments
    4. About the CD
      1. What’s on the CD
      2. Sample Applications
      3. System Requirements
      4. Errata & Book Support
      5. We Want to Hear from You
      6. Stay in Touch
    5. Conventions and Features Used in This Book
      1. Text Conventions
      2. Design Conventions
      3. Syntax Conventions
    6. Introduction
      1. Getting Familiar with Access 2007
      2. About This Book
    7. 1. Understanding Microsoft Access
      1. 1. What Is Microsoft Access?
        1. What Is a Database?
          1. Relational Databases
          2. Database Capabilities
        2. Access as an RDBMS
          1. Data Definition and Storage
          2. Data Manipulation
          3. Data Control
        3. Access as an Application Development System
        4. Deciding to Move to Database Software
      2. 2. Exploring the New Look of Access 2007
        1. Opening Access for the First Time
        2. Getting Started—A New Look for Access
          1. Opening an Existing Database
          2. Exploring the Microsoft Office Button
          3. Taking Advantage of the Quick Access Toolbar
        3. Understanding Content Security
          1. Temporarily Enabling a Database That Is Not Trusted
          2. Understanding the Trust Center
          3. Enabling Content by Defining Trusted Locations
        4. Understanding the New Ribbon Feature
          1. Home Tab
          2. Create Tab
          3. External Data Tab
          4. Database Tools Tab
        5. Understanding the New Navigation Pane
          1. Exploring Navigation Pane Object Views
          2. Working with Custom Categories and Groups
            1. Exploring the Navigation Options Dialog Box
            2. Creating and Modifying a Custom Category
            3. Creating and Modifying Groups in a Custom Category
            4. Creating Object Shortcuts in Custom Groups
            5. Hiding Custom Groups in a Category
            6. Hiding and Renaming Object Shortcuts
            7. Revealing Hidden Shortcuts
          3. Sorting and Selecting Views in the Navigation Pane
          4. Manually Sorting Objects in the Navigation Pane
          5. Searching for Database Objects
        6. Using the Single-Document vs. Multiple-Document Interface
        7. Modifying Global Settings via the Access Options Dialog Box
      3. 3. Microsoft Office Access 2007 Overview
        1. The Architecture of Access
        2. Exploring a Desktop Database—Housing Reservations
          1. Tables
            1. Table Window in Design View
            2. Table Window in Datasheet View
          2. Queries
            1. Query Window in Design View
            2. Query Window in Datasheet View
          3. Forms
            1. Form Window in Design View
            2. Form Window in Layout View
            3. Form Window in Form View
          4. Reports
            1. Report Window in Design View
            2. Report Window in Print Preview
            3. Report Window in Layout View
            4. Report Window in Report View
          5. Macros
          6. Modules
        3. Exploring a Project File—Conrad Systems Contacts
          1. Tables
          2. Views, Functions, and Stored Procedures
        4. The Many Faces of Access
    8. 2. Building an Access 2007 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 a Table Template
        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. Creating a Default Template for New Databases
        13. Printing a Table Definition
        14. 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. Working with Multi-Value Lookup Fields
        14. Changing the Primary Key
        15. Compacting Your Database
      3. 6. Importing and Linking Data
        1. A Word About Open Database Connectivity (ODBC)
        2. Creating a Data Source to Link to an ODBC Database
        3. Importing vs. Linking Database Files
        4. Importing Data and Databases
          1. Importing dBASE Files
          2. Importing Paradox Files
          3. Importing SQL Tables
          4. Importing Access Objects
        5. Importing Spreadsheet Data
          1. Preparing a Spreadsheet
          2. Importing a Spreadsheet
          3. Fixing Errors
        6. 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
        7. Modifying Imported Tables
        8. 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
        9. Collecting Data via E-Mail
          1. Collecting Data via HTML Forms
            1. Filling Out the HTML Form
            2. Having Outlook Automatically Process the Replies
          2. Collecting Data Using InfoPath Forms
            1. Filling Out the InfoPath Form
            2. Manually Processing the Replies
            3. Managing and Resending Data Collection Messages from Access
      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
              1. Using Find
              2. Filtering by Selection
              3. Using the Filter Window
              4. Using Filter By Form
      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
            2. 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
          5. 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
    9. 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. Split Forms
          5. Subforms
          6. Pop-Up Forms
          7. Modal Forms
          8. Special Controls
            1. Option Buttons, Check Boxes, Toggle Buttons, and Option Groups
            2. List Boxes and Combo Boxes
            3. Tab Controls
            4. Attachment Controls
            5. ActiveX Objects
            6. Command Buttons
          9. PivotTables and PivotCharts
        3. Moving Around on Forms and Working with Data
          1. Viewing Data
            1. Moving Around
            2. Keyboard Shortcuts
        4. Adding Records and Changing Data
          1. Adding a New Record
          2. Changing and Deleting Data
        5. Searching for and Sorting Data
          1. Performing a Simple Search
          2. Using the Search Box
          3. Performing a Quick Sort on a Form Field
          4. Adding a Filter to a Form
        6. 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 Form Design Tools Contextual Ribbon Tabs
            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 Font Group
            3. Setting Border Color, Type, Line Thickness, and Special Effect
            4. Setting Text Box Properties
            5. Setting Label Properties
            6. Setting Form Properties
          3. Customizing Colors and Checking Your Design Results
        3. Working with Quick Create Commands and the Form Wizard
          1. Creating a Form with the Quick Create Commands
          2. Creating the Basic Products Form with the Form Wizard
          3. 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 in Design View
          1. Sizing Controls to Fit Content
          2. Adjusting the Layout of Controls
          3. “Snapping” Controls to the Grid
          4. Lining Up Controls
        2. Working in Layout View
          1. Understanding Control Layouts and Control Anchoring
          2. Lining Up Controls
          3. Moving Controls Within a Control Layout
          4. Formatting a Column of Controls
          5. Resizing Controls
          6. Removing a Control Layout
          7. Placing Controls into a Control Layout
          8. Adding Some Space with Control Padding
          9. Completing the Form
        3. Enhancing the Look of a Form
          1. Lines and Rectangles
          2. Colors and Special Effects
          3. Fonts
        4. 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
        5. 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
        6. 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
          5. Report View—A First Look
        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. Grouping, Sorting, and Totaling Information
          4. Completing the Report
        2. Using the Report Command
        3. Using the Report Wizard
          1. Specifying Report Wizard Options
          2. Viewing the Result
          3. Modifying a Wizard-Created Report in Layout View
        4. Building a Report in Layout View
          1. Starting with a Blank Report
          2. Adding Grouping and Sorting
          3. Working with Control Layouts
          4. Adding Totals to Records
          5. Applying an AutoFormat
      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 Grouping and Sorting 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
    10. 4. Automating an Access Application
      1. 17. 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
        3. Understanding Event Sequence and Form Editing
      2. 18. Automating Your Application with Macros
        1. Uses of Macros
        2. The Macro Design Facility—An Overview
          1. Working with the Macro Design Window
          2. Saving Your Macro
          3. Testing Your Macro
        3. Defining Multiple Actions
        4. Grouping Macros
        5. Understanding Conditional Expressions
        6. Using Embedded Macros
          1. Editing an Embedded Macro
          2. Creating an Embedded Macro
          3. Deleting an Embedded Macro
        7. Using Temporary Variables
        8. Trapping Errors in Macros
        9. Understanding Macro Actions That Are Not Trusted
        10. Making Your Application Come Alive with Macros
          1. Referencing Form and Report Objects
            1. Rules for Referencing Forms and Reports
            2. Rules for Referencing Form and Report Properties
            3. Rules for Referencing Form and Report Controls and Their Properties
            4. Rules for Referencing Subforms and Subreports
          2. Opening a Secondary Form
            1. Creating the SeeCityInformation Macro
          3. Synchronizing Two Related Forms
            1. Creating the SyncWeddingAndCity Macro
          4. Validating Data and Presetting Values
            1. Validating Data
            2. Understanding the ValidateCitySetStateAndZip Macro Group
            3. Passing Status Information Between Linked Forms
            4. Presetting Values
        11. Converting Your Macros to Visual Basic
      3. 19. 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
              1. Executing Visual Basic Commands in the Immediate Window
              2. Using Breakpoints
            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. Manipulating Complex Data Types Using DAO
            3. Working with ADO Recordsets
            4. 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 Statement
            1. Syntax
            2. Example
        8. Running Macro Actions and Menu Commands
          1. DoCmd Object
            1. Syntax
            2. Notes
            3. Examples
          2. Executing an Access 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
      4. 20. 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. 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
    11. 5. Linking Access and the Web
      1. 21. 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. Understanding Static Web Pages
        3. Viewing Static HTML Pages
        4. 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
        5. Creating Dynamic Web Pages
          1. Delivering Dynamic Query Results
          2. Processing Live Data with HTML Forms
          3. Using Visual Studio .NET and ASP.NET
        6. Sharing Your Data with SharePoint
          1. Introducing Windows SharePoint Services
          2. Office and Windows SharePoint Services
      2. 22. Working with Windows SharePoint Services
        1. Working Within the Windows SharePoint Services User Interface
          1. Editing Data in Lists
          2. Creating New Views
          3. Adding Columns to Lists
          4. Recycle Bin
        2. Using Windows SharePoint Services from Access
          1. Exporting Data to Windows SharePoint Services
          2. Importing a List from Windows SharePoint Services
          3. Linking a Windows SharePoint Services List into Access
          4. Using SharePoint List Options with Linked Lists
          5. Creating a New Windows SharePoint Services List from Within Access
            1. Using an Existing List Template
            2. Creating a Custom List
        3. Migrating an Access Database to a Windows SharePoint Services Site
          1. Publishing Your Database to a Windows SharePoint Services Site
          2. Moving Your Database to a Windows SharePoint Services Site
          3. Republish a Database to a Windows SharePoint Services Site
          4. Opening the Database from Windows SharePoint Services
          5. Working Offline
          6. Synchronizing Changes After Working Offline
      3. 23. Using XML
        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 Presentation Layout Extension Package (.xsx)
            5. 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. Modifying Table Templates
          1. Adding a New Field to a Table Template
          2. Modifying a Field in a Table Template
        4. Customizing the Ribbon with XML
          1. Creating a USysRibbons Table
          2. Creating a Test Form
          3. Building the Ribbon XML
            1. Hiding Existing Ribbon Elements
            2. Testing Your XML
            3. Creating Tabs
            4. Adding Built-In Groups to Tabs
    12. 6. After Completing Your Application
      1. 24. The Finishing Touches
        1. Creating Custom Ribbons
          1. Loading Ribbon XML
            1. Syntax
            2. Notes
          2. Using Ribbon Attributes
          3. Creating VBA Callbacks
          4. Dynamically Updating Ribbon Elements
          5. Loading Images into Custom Controls
          6. Hiding Options on the Microsoft Office Button
          7. Setting Focus to a Tab
        2. Fine-Tuning with Performance Analyzer
        3. Disabling Layout 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
      2. 25. Distributing Your Application
        1. Using Linked Tables in a Desktop Database
          1. Taking Advantage of the Database Splitter Wizard
          2. Creating Startup Code to Verify and Correct Linked Table Connections
        2. Understanding Runtime Mode
        3. Creating an Execute-Only Database
        4. Creating an Application Shortcut
        5. Encrypting Your Database
        6. Packaging and Signing Your Database
        7. Understanding the Access 2007 Developer Extensions and Runtime
    13. A. Installing Your Software
      1. Installing the Microsoft Office System
        1. Choosing Options When You Have No Previous Version of Microsoft Office
        2. Choosing Options to Upgrade a Previous Version of Microsoft Office
      2. Installing SQL Server 2005 Express Edition
      3. Converting from a Previous Release of Access
        1. Conversion Issues
    14. B. Index to Troubleshooting Topics
    15. C. About the Authors
    16. D. Choose the Right Book for You
      1. Published and Upcoming Titles
        1. Plain & Simple
        2. Step by Step
        3. Inside Out
        4. Other Titles
    17. Index
    18. About the Authors
    19. Copyright

    Product information

    • Title: Microsoft Office® Access 2007 Inside Out
    • Author(s): John Viescas and Jeff Conrad
    • Release date: April 2007
    • Publisher(s): Microsoft Press
    • ISBN: 9780735623255