TSC - Access 97: Module I


Prerequisites Basic knowledge of RDBMS encouraged not required
Duration 6-8 hours
Starting Please call for dates

Course Topics

The Fundamentals
  • Introduction to Databases
  • Starting Access & Opening a Database
  • Understanding the Access Program Screen
  • Using Menus & Toolbars
  • Filling Out Dialog Boxes
  • Keystroke & Right Mouse Button Shortcuts
  • Opening & Modifying Database Objects
  • Working with Multiple Windows
  • Tour of a Table
  • Adding, Editing, & Deleting Records
  • Tour of a Form
  • Tour of a Query
  • Tour of a Report
  • Previewing & Printing a Database Object
  • Selecting Data
  • Cutting, Copying, & Pasting Data
  • Using Undo
  • Checking Your Spelling
  • Using the Zoom Box
  • Closing a Database & Exiting Access

Getting Help from Access

  • Getting Help from the Office Assistant
  • Getting Help by Contents
  • Getting Help with the Help Index
  • Finding Help

Creating and Working with a Database

  • Planning a Database
  • Creating a Database Using the Database Wizard
  • Creating a Blank Database
  • Creating a Table Using the Table Wizard
  • Modifying a Table & Understanding Data Types
  • Creating a New Table from Scratch
  • Creating a Query in Design View
  • Modifying a Query
  • Sorting a Query using Multiple Fields
  • Developing AND and OR Operators
  • Creating a Form with the Form Wizard
  • Creating a Report with the Report Wizard
  • Creating Mailing Labels with the Label Wizard
  • Database Object Management
  • File Management
  • Compacting & Repairing a Database
Finding, Filtering, and Formatting Data
  • Finding & Replacing Information
  • Sorting Records
  • Filtering by Selection
  • Filtering by Form
  • Creating an Advanced Filter
  • Adjusting Row Height & Column Width
  • Rearranging Columns
  • Changing Gridline & Cell Effects
  • Freezing a Field
  • Hiding a Field
  • Changing the Datasheet Font

Working with Tables and Fields

  • Understanding Field Properties
  • Indexing a Field
  • Adding a Primary Key to a Table
  • Inserting, Deleting & Reordering Fields
  • Changing a Field’s Data Type
  • Using Field Descriptions
  • Adding a Caption
  • Change the Field Size
  • Formatting Number, Currency, & Date/Time Fields
  • Formatting Number, Currency, & Date/Time Fields by Hand
  • Formatting Text Fields
  • Setting a Default Value
  • Requiring Data Entry
  • Validating Data
  • Creating an Input Mask
  • Creating a Lookup Field
  • Creating a Value List
  • Modifying a Lookup List

Working with Relational Databases

  • Understanding Table Relationships
  • Creating Relationships between Tables
  • Enforcing Referential Integrity
  • Testing Referential Integrity & Deleting a Relationship
  • Understanding of Relationship Types

For more information call (248) 848-1484 x 100

© 2001 Technical Software Consulting, Inc.