Welcome to the on-line home of The Computer Tutor Inc. .....

• Getting Started: Starting Access; Opening Databases; Using Database Objects; Navigating Pages; Opening & Closing Database Objects; Closing a Database; Exiting Access
• Using the Office Assistant: Finding an answer; Selecting an Assistant; Changing Assistant Options; Hiding the Assistant
• Creating Tables: Creating a Blank Database; Creating & Designing Tables; Adding Field Names; Assigning Data Types; Adding Field Descriptions; Setting a Primary Key; Saving a New Table   
• Working With Tables: Navigating Fields in Tables; Navigating Through Records; Adding, Selecting, Editing & Saving Records; Deleting Records
• Setting Field Properties:  Limiting Field Size; Setting Formats, Setting Values; Setting Validation Rules/Text 
  Editing Tables:  Changing Row Height & Column Width; Changing a Font Attribute; Changing a Cell Effect; Managing Columns
• Finding & Filtering Data: Sorting Records; Finding & Replacing Data; Using Filtering to Select Data 
  Printing Data: Creating a Relationship; Setting Referential Integrity; Adding a Table to the Window 
• Using & Modifying Queries: Using the Simple Query Wizard; Creating a Query; Adding & Joining Tables in a Query; Running, Sorting, Hiding and Printing a Query; Adding a Record Using a Query
• Creating Basic Forms: Using the Form Wizard; Viewing and Printing Records in a Form; Basing a Form on a Query; Using Auto Form; Adding a Record Using a Form
• Creating Basic Reports: Using the Reports Wizard; Printing & Print Preview; Using Auto Report
• Using Online Help.

• Modifying Tables: Inserting & Deleting Columns; Changing a Column Name; Inserting a Loopup or 
  Using Operators in Queries: Using Comparison Operators; Using And…Or & Between…And Conditions; Using Wildcards
• Designing Advanced Queries: Setting Top Values in a Query; Creating a Calculated Field; Creating Function & Parameter Queries  
• Creating Action Queries: Creating Make-table, Update, Append & Delete Queries  
• Using Advanced Query Wizards: Using the Crosstab Query, Find Duplicates, and Find Unmatched Wizards  
• Using Database Utilities:  Changing Database Properties; Linking Data to an Access Table; Importing Data; Setting a Database Password; Compacting a Database  
• Manipulating Controls: Using Controls; Selecting Adjacent &Non-adjacent Controls; Deleting Controls; Moving or Sizing a Control by Dragging; Sizing Controls Automatically  
• Using Design View: Hiding the Ruler; Disabling the Snap-to-Grid Feature; Displaying the Field List & Adding a Field; Moving Part of a Paired Control; Aligning & Spacing Controls; Using the Toolbox; Adding a Label, Image, Rectangle or Line; Editing an Unbound Control  
  Using Advanced Form Design: Using Forms in Design View; Creating Combo & List Boxes; Creating an Option Group; Setting Tab Order; Adding a Form Header/Footer 
  Using Advanced Report Design: Using Reports in Design View; Creating Calculated Controls, Group Headers, Running Summaries; Inserting a Date/Time Control or Page Break; Changing the Report Margins; Using the Label Wizard 
• Working with Indexes: Viewing Indexes; Creating Single & Multiple Field Indexes; Deleting an Index; Creating a Multiple Field Key   
• Creating Command Buttons