• Main Page
  • Table of content
  • Copyright
  • Acknowledgements
    • Perspection, Inc.
    • Acknowledgements
  • About The Author
    • We Want To Hear From You!
  • Introduction
    • Find the Best Place to Start
    • What's New
    • How This Book Works
    • Step-by-Step Instructions
    • Real World Examples
    • Troubleshooting Guide
    • Show Me Live Software
    • Microsoft Office Specialist
  • Chapter 1. Getting Started with Access
    • Introduction
    • What Is a Database?
    • Understanding How Databases Store Data
    • Starting Access
    • Using Task Panes
    • Opening a Database
    • Finding a File or Contents in a File
    • Viewing the Access Window
    • Arranging Windows
    • Choosing Menu Commands
    • Choosing Dialog Box Options
    • Working with Toolbars
    • Viewing Database Objects
    • Getting Help While You Work
    • Getting Help from the Office Assistant
    • Getting Access Updates on the Web
    • Saving Your Work
    • Recovering an Office Program
    • Detecting and Repairing Problems
    • Closing a Database and Quitting Access
  • Chapter 2. Touring Access Databases
    • Introduction
    • Opening a Sample Database
    • Using a Switchboard
    • Working with Database Objects
    • Grouping Database Objects
    • Hiding Windows
    • Touring a Table
    • Touring a Form
    • Entering Data
    • Touring a Query
    • Touring a Report
    • Creating a Database Using a Wizard
    • Stepping Through a Database Wizard
    • Creating a Database Using a Template
    • Warnings About Templates and Add-Ins
  • Chapter 3. Planning and Creating a Custom Database
    • Introduction
    • Creating a New Database
    • Planning Tables
    • Creating Tables in a Database
    • Creating a Table Using a Wizard
    • Setting a Primary Key Using the Table Wizard
    • Assigning Table Relationships Using the Table Wizard
    • Creating a Table by Entering Data
    • Importing Data into Tables
    • Working with a Table in Design View
    • Specifying a Primary Key in Design View
    • Planning Table Relationships
    • Defining Table Relationships
    • Ensuring Referential Integrity
    • Identifying Object Dependencies
    • Modifying Object Dependencies
  • Chapter 4. Working with Fields
    • Introduction
    • Inserting, Deleting, and Reordering Fields
    • Specifying Data Types and Field Properties
    • Viewing Field Properties
    • Changing Field Properties
    • Updating Field Properties
    • Setting Field Size
    • Formatting Text Values
    • Formatting Number and Currency Values
    • Formatting Date and Time Values
    • Creating Input Masks
    • Specifying Required Fields and Default Values
    • Adding a Caption to a Field
    • Creating Indexed Fields
    • Validating Field Values
    • Using Expression Builder
    • Creating a Lookup Field
    • Setting Lookup Properties
  • Chapter 5. Working with Tables
    • Introduction
    • Working with a Table
    • Moving to a Specific Record in a Table
    • Searching for and Replacing Text
    • Entering Data Accurately with AutoCorrect
    • Using Smart Tags
    • Editing Text
    • Working with the Clipboard
    • Checking Spelling
    • Arranging Columns
    • Changing the Size of Rows and Columns
    • Managing Columns in Datasheet View
    • Formatting a Datasheet
    • Repairing Renaming Errors
    • Sorting Records
    • Copying and Pasting Records
    • Viewing a Subdatasheet
    • Filtering Out Records
    • Creating Complex Filters Using Forms
  • Chapter 6. Locating Specific Information Using a Query
    • Introduction
    • Understanding Types of Queries
    • Creating a Query in Design View
    • Getting Information with a Query
    • Modifying a Query in Design View
    • Creating a Query Using a Wizard
    • Changing the Query Fields
    • Specifying Criteria for a Single Field
    • Specifying Criteria for Multiple Fields
    • Creating Queries with Comparison and Logical Operators
    • Performing Calculations in Queries
    • Creating a Parameter Query
    • Finding Duplicate Fields
    • Finding Unmatched Records
    • Creating New Tables with a Query
    • Adding Records with a Query
    • Deleting Records with a Query
    • Updating Records with a Query
    • Summarizing Values with a Crosstab Query
    • Creating SQL-Specific Queries
  • Chapter 7. Simplifying Data Entry with Forms
    • Introduction
    • Creating Forms
    • Working with Form Controls
    • Creating a Form Using AutoForm
    • Creating a Form Using a Wizard
    • Creating a Form in Design View
    • Editing an Existing Form
    • Adding and Modifying Controls
    • Using the Control Wizards
    • Creating a Subform
    • Editing in Form View
    • Entering and Editing Data in a Form
    • Using Windows XP Themes in Forms
  • Chapter 8. Creating Reports to Convey Information
    • Introduction
    • Exploring Different Ways to Create a Report
    • Creating a Report Using a Wizard
    • Using Sections in Design View
    • Working with Controls
    • Creating a Report in Design View
    • Using Toolbox Buttons and Controls
    • Arranging Information
    • Creating Mailing Labels
    • Setting Properties
    • Performing Calculations in Reports
    • Grouping Records
    • Inserting a Header or Footer
    • Assigning a Shortcut Key to a Control
    • Checking for Errors in Reports and Forms
    • Changing the Page Setup
    • Previewing Information
    • Printing Information
  • Chapter 9. Improving the Appearance of Forms and Reports
    • Introduction
    • Formatting a Form or Report
    • Adding Lines and Rectangles
    • Changing Line or Border Thickness
    • Changing Colors
    • Applying Special Effects to Controls
    • Applying Conditional Formatting
    • Aligning and Grouping Controls
    • Sharing Information Among Documents
    • Copying and Pasting Objects
    • Inserting a New Object
    • Inserting an Object from a File
    • Inserting a Picture
    • Inserting Excel Charts and Worksheets
    • Inserting a Graph Chart
    • Formatting Chart Objects
    • Moving and Resizing an Object
  • Chapter 10. Working on the Web
    • Introduction
    • Integrating Access and the Internet
    • Creating a Hyperlink Field
    • Inserting a Hyperlink to a File or Web Page
    • Linking to an Object in a Database
    • Linking to a New Document
    • Navigating Hyperlinks
    • Working with the Web Toolbar
    • Exporting Database Objects to HTML
    • Exporting Database Objects to ASP Files
    • Holding an Online Meeting
    • Creating a Data Access Page Using a Wizard
    • Working with a Data Access Page in Design View
    • Adding a Theme to a Page
    • Grouping a Data Access Page
    • Viewing a Data Access Page
    • Analyze Pivot Data from the Web
  • Chapter 11. Importing and Exporting Information
    • Introduction
    • Importing and Linking Data
    • Importing or Linking Data from an Access Database
    • Importing or Linking Data from an Excel Spreadsheet
    • Importing or Linking Data from a Mail Program
    • Getting Data from Other Programs
    • Importing and Exporting XML Data
    • Exporting Data to Other Programs
    • Merging Data with Word
    • Analyzing Data in Excel
  • Chapter 12. Managing a Database
    • Introduction
    • Securing a Database
    • Creating a Workgroup Information File
    • Joining a Workgroup
    • Creating User and Group Accounts
    • Activating User Logons
    • Setting User and Group Permissions
    • Setting Object Ownership
    • Setting a Database Password
    • Encoding a Database
    • Locking Database Records
    • Replicating a Database
    • Backing Up a Database
    • Compacting and Repairing a Database
    • Splitting a Database
    • Documenting a Database
    • Analyzing a Database
    • Converting Access Databases
    • Using Add-Ins
    • Creating a Database Switchboard
    • Managing a Switchboard
    • Creating a Splash Screen
    • Setting Access Startup Options
  • Chapter 13. Customizing Access
    • Introduction
    • Adding and Removing Toolbar Buttons
    • Customizing a Toolbar
    • Customizing the Menu Bar
    • Editing Toolbar Buttons and Menu Entries
    • Learning About Macros
    • Creating a Macro
    • Running and Testing a Macro
    • Creating Macro Groups
    • Creating Conditional Macros
    • Assigning a Macro to a Button
    • Assigning a Macro to an Event
    • Creating a Message Box
    • Controlling Access with your Voice
    • Executing Voice Commands
    • Dictating Text
    • Recognizing Handwriting
    • Using Multiple Languages
  • Chapter 14. Enhancing a Database with Programming
    • Introduction
    • Enhancing a Database with VBA
    • Creating a Standard Module
    • Understanding Parts of the Visual Basic Editor
    • Creating a Sub Procedure
    • Writing VBA Commands
    • Running a Sub Procedure
    • Copying Commands from the Object Browser
    • Creating a Custom Function
    • Running a Custom Function
    • Creating a Class Module for a Form or Report
    • Setting Project Properties
    • Debugging a Procedure
    • Identifying VBA Debugging Tools
    • Optimizing Performance with an MDE File
  • Chapter 15. Working Together on Office Documents
    • Introduction
    • Viewing SharePoint Team Services
    • Administering SharePoint Team Services
    • Storing Documents in the Library
    • Viewing Team Members
    • Setting Up Alerts
    • Assigning Project Tasks
    • Creating an Event
    • Creating Contacts
    • Holding Web Discussions
    • Importing and Exporting Access Data with SharePoint
    • Installing Windows 2003 and SharePoint Server 2003
  • Microsoft Office Specialist
    • About the Microsoft Office Specialist Program
    • What Does This Logo Mean?
    • Preparing for a Microsoft Office Specialist Exam
    • Taking a Microsoft Office Specialist Exam
    • Getting More Information
  • New! Features
    • Microsoft Office Access 2003
  • Troubleshooting
    • Clip art and objects
    • Columns
    • Database
    • Entering and editing data
    • Fields
    • Formatting
    • Forms
    • Help
    • Importing and exporting
    • Language, voice and handwriting options
    • Macros
    • Managing
    • Menus, toolbars, and task panes
    • Microsoft Office Specialist
    • Printing
    • Queries and reports
    • Records
    • Reports
    • Searching
    • SharePoint
    • Spelling
    • Tables
    • Visual Basic (VBA)
    • Views
    • Web