Table of content

	Table of Contents

Show Me Microsoft Office Access 2003
By Steve  Johnson  Perspection, Inc.
Publisher	: Que
Pub Date	: October 15, 2003
ISBN	: 0-7897-3004-9
Pages	: 384
	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