Books & Videos

Table of Contents

  1. Chapter 1 The Fundamentals

    1. Introduction to Databases

    2. What’s New in Access 2003

    3. Starting Access and Opening a Database

    4. Understanding the Access Program Screen

    5. Using Menus

    6. Using Toolbars

    7. Filling Out Dialog Boxes

    8. Keystroke and Right Mouse Button Shortcuts

    9. Opening and Modifying Database Objects

    10. Working with Multiple Windows

    11. Tour of a Table

    12. Adding, Editing, and Deleting Records

    13. Tour of a Form

    14. Tour of a Query

    15. Tour of a Report

    16. Previewing and Printing a Database Object

    17. Selecting Data

    18. Cutting, Copying, and Pasting Data

    19. Using Undo

    20. Checking Your Spelling

    21. Getting Help

    22. Changing the Office Assistant and Using the Quick ReferenceHelp Button

    23. Using the Zoom Box

    24. Closing a Database and Exiting Access

    25. Chapter One Review

  2. Chapter 2 Creating and Working with a Database

    1. Planning a Database

    2. Creating a Database Using the Database Wizard

    3. Creating a Blank Database

    4. Creating a Table Using the Table Wizard

    5. Modifying a Table and Understanding Data Types

    6. Creating a New Table from Scratch

    7. Creating a Query in Design View

    8. Modifying a Query

    9. Sorting a Query Using Multiple Fields

    10. Developing AND and OR Operators

    11. Creating a Form with the Form Wizard

    12. Creating a Report with the Report Wizard

    13. Creating Mailing Labels with the Label Wizard

    14. Database Object Management

    15. File Management

    16. Compacting and Repairing a Database

    17. Converting an Access Database

    18. Chapter Two Review

  3. Chapter 3 Finding, Filtering, and Formatting Data

    1. Finding and Replacing Information

    2. Sorting Records

    3. Filtering by Selection

    4. Filtering by Form

    5. Creating an Advanced Filter

    6. Adjusting Row Height and Column Width

    7. Rearranging Columns

    8. Changing Gridline and Cell Effects

    9. Freezing a Field

    10. Hiding a Column

    11. Changing the Datasheet Font

    12. Chapter Three Review

  4. Chapter 4 Working with Tables and Fields

    1. Understanding Field Properties

    2. Indexing a Field

    3. Adding a Primary Key to a Table

    4. Inserting, Deleting, and Reordering Fields

    5. Changing a Field’s Data Type

    6. Using Field Descriptions

    7. Adding a Caption

    8. Changing the Field Size

    9. Formatting Number, Currency, and Date/Time Fields

    10. Formatting Number, Currency, and Date/Time Fields by Hand

    11. Formatting Text Fields

    12. Setting a Default Value

    13. Requiring Data Entry

    14. Validating Data

    15. Creating an Input Mask

    16. Creating a Lookup Field

    17. Creating a Value List

    18. Modifying a Lookup List

    19. Chapter Four Review

  5. Chapter 5 Creating Relational Databases

    1. Understanding Table Relationships

    2. Creating Relationships Between Tables

    3. Enforcing Referential Integrity

    4. Testing Referential Integrity & Printing and Deleting Table Relationships

    5. Understanding Relationship Types

    6. Chapter Five Review

  6. Chapter 6 Working with Queries

    1. A Quick Review

    2. Understanding the Different Types of Queries

    3. Creating a Multiple-Table Query

    4. Creating a Calculated Field

    5. Working with Expressions and the Expression Builder

    6. Using an IIf Function

    7. Summarizing Groups of Records

    8. Display Top or Bottom Values

    9. Parameter Queries

    10. Finding Duplicate Records

    11. Finding Unmatched Records

    12. Crosstab Queries

    13. Delete Queries

    14. Append Queries

    15. Make-Table Queries

    16. Update Queries

    17. Chapter Six Review

  7. Chapter 7 Working with Forms

    1. Creating a Form with AutoForm

    2. Modifying a Form

    3. Adding and Deleting Fields

    4. Moving and Sizing Controls

    5. Changing the Tab Order

    6. Working with Control Properties

    7. Control Property Reference

    8. Working with Form Properties

    9. Form and Report Property Reference

    10. Working with Multiple Controls

    11. Adding, Cutting, Copying, and Pasting Controls

    12. Changing a Control’s Data Source

    13. Creating a Calculated Control

    14. Changing a Control’s Default Value

    15. Using the Control Wizard

    16. Creating a Subform

    17. Modifying and Working with Subforms

    18. Chapter Seven Review

  8. Chapter 8 Working with Reports

    1. Creating a Report with AutoReport

    2. Modifying a Report

    3. Adding and Deleting Fields

    4. Moving and Sizing Controls

    5. Adjusting Page Margins and Orientation

    6. Adding Page Numbers and Dates

    7. Understanding Report Sections

    8. Grouping and Sorting Records

    9. Creating Calculated Controls

    10. Working with Section Properties

    11. Creating Charts with the Chart Wizard

    12. Chapter Eight Review

  9. Chapter 9 Formatting Forms and Reports

    1. Formatting Fonts with the Formatting Toolbar

    2. Changing Text Alignment

    3. Using AutoFormat

    4. Changing Colors

    5. Applying Special Effects

    6. Using the Format Painter

    7. Adding Pictures and Lines

    8. Aligning Controls with One Another

    9. Changing a Control’s Formatting Properties

    10. Chapter Nine Review

  10. Chapter 10 Working with Macros

    1. Creating and Running a Macro

    2. Editing a Macro

    3. Working with Macro Groups

    4. Assigning a Macro to an Event

    5. Creating Conditional Expressions

    6. Assigning a Macro to a Keystroke Combination

    7. Macro Action Reference

    8. Chapter Ten Review

  11. Chapter 11 Advanced Topics

    1. Importing Information

    2. Exporting Information

    3. Importing Objects from Another Access Database

    4. Linking Information from an External Source

    5. Analyzing Records with Microsoft Excel

    6. Exporting Records to Microsoft Word

    7. Mail Merging Records to Microsoft Word

    8. Using Hyperlink Fields

    9. Using OLE Object Fields

    10. Displaying Database Object Dependencies

    11. Chapter Eleven Review

  1. Colophon