Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


Instructor-Led Microsoft Access 2002 / 2003 Level 1


 
Course Outline
Microsoft Access - Level 1
| | ID: SAMSA0 | Course Length: 2
|Module 0: Exploring Access|
  • Starting Access
  • Exiting Access
  • Opening An Existing Database
  • Using Menu Commands
  • Displaying and Hiding Toolbars
  • Changing Menu and Toolbar Options
  • Using Database Objects
  • Using the Database Window
  • Opening a Database Object
  • Using the Task Pane
  • |Module 1: Working With The Office Assistant|
  • Using the Office Assistant
  • Finding An Answer
  • Changing Office Assistant Options
  • Using Ask a Question
  • |Module 2: Creating Tables|
  • Creating a New Database
  • Using the Table Wizard
  • Designing Tables
  • Creating a Table in Design View
  • Using Design View
  • Adding Field Names
  • Assigning Data Types
  • Adding a Field Description
  • Setting a Primary Key
  • Saving a New Table
  • |Module 3: Working With Tables|
  • Using Datasheet View
  • Navigating Fields in Tables
  • Adding Records
  • Moving Through Records
  • Selecting Records
  • Editing Records
  • Saving Records
  • Deleting Records
  • |Module 4: Editing Tables|
  • Changing the Row Height
  • Changing the Column Width
  • Changing a Font Attribute
  • Changing a Cell Effect
  • Selecting a Column
  • Moving a Column
  • Hiding a Column
  • Unhiding a Column
  • Freezing a Column
  • |Module 5: Finding And Filtering Data|
  • Sorting Records
  • Finding Specific Records
  • Finding Records Using Wildcards
  • Using Replace
  • Using Filter By Selection
  • Applying/removing a Filter
  • Using Filter Excluding Selection
  • Using Filter For
  • Using Filter By Form
  • |Module 6: Printing Data|
  • Printing Table Data
  • Changing the Page Setup
  • Printing Selected Records
  • |Module 7: Creating Relationships|
  • Using Related Tables
  • Creating a Relationship Between Tables
  • Setting Referential Integrity
  • Viewing Subdatasheets
  • Deleting a Join Line
  • |Module 8: Using Simple Queries|
  • Using Queries and Recordsets
  • Using the Simple Query Wizard
  • Creating a Query in Design View
  • Opening a Query
  • Adding a Table To a Query
  • Joining Tables in a Query
  • Running a Query
  • |Module 9: Modifying Query Results|
  • Sorting a Query
  • Adding Criteria To a Query
  • Hiding a Field in a Query
  • Adding a Record Using a Query
  • Printing a Query
  • |Module 10: Analyzing Tables|
  • Analyzing a Table
  • Using Relationships in Splits
  • Using the Table Analyzer Wizard
  • |Module 11: Creating Basic Forms|
  • Using Forms
  • Using the Form Wizard
  • Viewing Records in a Form
  • Printing Records in a Form
  • Basing a Form On a Query
  • Using Autoform
  • Adding a Record Using a Form
  • |Module 12: Creating Basic Reports|
  • Using Reports
  • Using the Report Wizard
  • Using Print Preview - Reports
  • Printing Pages of a Report
  • Basing a Report On a Query
  • Using Autoreport
  • |Module 13: Using Online Help|
  • Working with Online Help
  • Viewing Screentips
  • Using Help Contents
  • Using Help Window Features
  • Using the Help Answer Wizard
  • Using the Help Index

  • Prerequisites & Certificates
    Pre-Requisites

    none

    Certificates offered

    certificates provided


    Cancellation Policy
    For courses bought at the regular price 10 Business days are required for cancellations.
    For courses bought at the 'last-minute' price - all Registration are final
    Map & Reviews
    CBIT Training Ottawa
    [ View Provider's Profile ]

    Reviews
     
    We were provided a cd with a pdf copy of the manual for future reference which is great but no printed manual was provided to refer to during the course - this would have been helpful for learning.
    Reviewed by 2011
    need-to-train-a-group-banner

    This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

    This page has been viewed 1099 times.