Enhanced descriptions from Syndetics:

Easy Microsoft Access 97, Second Edition, takes you from having no prior experience to successfully building and manipulating databases in a very short amount of time. The step-by-step, hands on examples walk you through the major tasks associated with database work. You learn the basics from installing the program and walking through the common features and tasks to designing and creating an Access database. Youll build a database and table to store information. Learn to enter and edit data. Youll quickly and easily add, delete, and change information in the database, use database forms, query your database to find specific detailed information, create and use reports, and more.

Table of contents provided by Syndetics

• Part 1 Learning the Basics
• 1 Installing Microsoft Access 97
• 2 Starting Access from the Start Button
• 3 Opening an Existing Database
• 4 Using Menu Commands
• 5 Using Toolbar Buttons
• 6 Using Tab Buttons
• 7 Getting Help
• 8 Using the Index
• 9 Choosing an Office Assistant
• 10 Asking a Question
• 11 Using Context-Sensitive Help
• 12 Exiting Access
• Part 2 Designing and Creating an Access Database
• 1 Adding a Folder for the Database
• 2 Creating a New Database
• 3 Using the Table Wizard
• 4 Adding a New Field in Design View
• 5 Working with Number Fields
• 6 Adding a Yes/No Field
• 7 Saving a New Table Definition
• 8 Opening a Table
• 9 Changing a Field Name
• 10 Moving a Field Within a Table
• 11 Inserting a Field
• 12 Adding a New Field in Datasheet View
• 13 Deleting a Field
• 14 Building a Table from Scratch
• Part 3 Entering and Editing Data
• 1 Entering New Information in a Table
• 2 Copying Information from Another Record
• 3 Editing Data in a Field
• 4 Undoing an Edit
• 5 Searching for Information
• 6 Replacing Selected Information
• 7 Sorting Records
• 8 Using Filters
• 9 Filtering by Form
• 10 Deleting a Selected Record
• 11 Completing the Supplier Table
• 12 Resizing Rows and Columns
• 13 Freezing and Unfreezing Columns
• 14 Hiding and Unhiding Columns
• Part 4 Using Database Forms
• 1 Using an AutoForm
• 2 Building a Form with a Wizard
• 3 Opening the Form Design View Window
• 4 Adding Fields to a Form
• 5 Moving Fields in Form Design
• 6 Headers and Footers
• 7 Creating Labels
• 8 Using a Combo Box
• 9 Adding a List Box
• 10 Moving Objects
• 11 Editing a Label
• 12 Using an Option Button
• 13 Adding a Calculated Field
• 14 Adding Pop-Up Tip Text to Fields
• 15 Saving Your New Form
• 16 Opening a Form
• 17 Entering and Editing Information with a Form
• 18 Changing the Field Order
• Part 5 Getting Information from the Database
• 1 Opening Query Design View
• 2 Running and Saving a Query
• 3 Using the Crosstab Query
• 4 Selecting Records with Wildcards
• 5 Selecting Records with an OR Criteria
• 6 Selecting Records with More than One Criterion
• 7 Using Arithmetic Operators
• 8 Adding a New Field
• 9 Calculating a Value with a Query
• 10 Deleting Records with a Query
• 11 Creating a Query That Prompts for a Criteria Variable
• Part 6 Creating and Using Reports
• 1 Building a Report with a Wizard
• 2 Opening the Report Design View
• 3 Adding Fields to the Report
• 4 Using Titles
• 5 Automatic Page Numbers and Dates
• 6 Grouping Records
• 7 Sorting Records
• 8 Moving Field Labels on the Report
• 9 Moving Fields on the Report
• 10 Calculated Fields in a Report
• 11 Adding Special Effects to a Report
• 12 Viewing a Report
• 13 Saving a Report
• 14 Printing a Report

Author notes provided by Syndetics