• 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