INTRODUCTION TO ACCESS OUTLINE
The Fundamentals
Lesson 1 1: Introduction to Databases
Lesson 1 2: What’s New in Access 2002?
Lesson 1 3: Starting Access and Opening a Database
Lesson 1 4: Understanding the Access Program Screen
Lesson 1 5: Using Menus
Lesson 1 6: Using Toolbars
Lesson 1 7: Filling Out Dialog Boxes
Lesson 1 8: Keystroke and Right Mouse Button Shortcuts
Lesson 1 9: Opening and Modifying Database Objects
Lesson 1 10: Working with Multiple Windows
Lesson 1 11: Tour of a Table
Lesson 1 12: Adding, Editing, and Deleting Records
Lesson 1 13: Tour of a Form
Lesson 1 14: Tour of a Query
Lesson 1 15: Tour of a Report
Lesson 1 16: Previewing and Printing a Database Object
Lesson 1 17: Selecting Data
Lesson 1 18: Cutting, Copying, and Pasting Data
Lesson 1 19: Using Undo
Lesson 1 20: Checking Your Spelling
Lesson 1 21: Getting Help from the Office Assistant
Lesson 1 22: Changing the Office Assistant and Using the “What’s This” Button
Lesson 1 23: Using the Zoom Box
Lesson 1 24: Closing a Database and Exiting Access
Creating and Working with a Database
Lesson 2 1: Planning a Database
Lesson 2 2: Creating a Database Using the Database Wizard
Lesson 2 3: Creating a Blank Database
Lesson 2 4: Creating a Table Using the Table Wizard
Lesson 2 5: Modifying a Table and Understanding Data Types
Lesson 2 6: Creating a New Table from Scratch
Lesson 2 7: Creating a Query in Design View
Lesson 2 8: Modifying a Query
Lesson 2 9: Sorting a Query Using Multiple Fields
Lesson 2 10: Developing AND and OR Operators
Lesson 2 11: Creating a Form with the Form Wizard
Lesson 2 12: Creating a Report with the Report Wizard
Lesson 2 13: Creating Mailing Labels with the Label Wizard
Lesson 2 14: Database Object Management
Lesson 2 15: File Management
Lesson 2 16: Compacting and Repairing a Database
Lesson 2 17: Converting an Access Database
Finding, Filtering, and Formatting Data
Lesson 3 1: Finding and Replacing Information
Lesson 3 2: Sorting Records
Lesson 3 3: Filtering by Selection
Lesson 3 4: Filtering by Form
Lesson 3 5: Creating an Advanced Filter
Lesson 3 6: Adjusting Row Height and Column Width
Lesson 3 7: Rearranging Columns
Lesson 3 8: Changing Gridline and Cell Effects
Lesson 3 9: Freezing a Field
Lesson 3 10: Hiding a Column
Lesson 3 11: Changing the Datasheet Font
Working with Tables and Fields
Lesson 4 1: Understanding Field Properties
Lesson 4 2: Indexing a Field
Lesson 4 3: Adding a Primary Key to a Table
Lesson 4 4: Inserting, Deleting, and Reordering Fields
Lesson 4 5: Changing a Field’s Data Type
Lesson 4 6: Using Field Descriptions
Lesson 4 7: Adding a Caption
Lesson 4 8: Changing the Field Size
Lesson 4 9: Formatting Number, Currency, and Date/Time Fields
Lesson 4 10: Formatting Number, Currency, and Date/Time Fields by Hand
Lesson 4 11: Formatting Text Fields
Lesson 4 12: Setting a Default Value
Lesson 4 13: Requiring Data Entry
Lesson 4 14: Validating Data
Lesson 4 15: Creating an Input Mask
Lesson 4 16: Creating a Lookup Field
Lesson 4 17: Creating a Value List
Lesson 4 18: Modifying a Lookup List