Microsoft Access 2003 Training – Level 1

This course is designed for the new or inexperienced user who has a need to use the programme on a regular basis, but who has had no formal or structured training and is likely to be self taught.

Delegates attending the course will be able to understand databases, create, manage and format data and use the various tools and shortcuts available within Access to do so in an efficient and timely manner. This will enable the delegate to interrogate the data and create informative reports.

Course Outline: 

The Access Environment

  • The Database Window
  • How Access Stores Data
  • Examine An Existing Database

Access Orientation

  • Opening An Existing Database
  • Working With Database Objects
  • Using Menu Commands
  • Using Keyboard Shortcuts
  • Exiting From Access

Create A Simple Database

  • Using The Wizard
  • Using Design View
  • Data Types
  • Name A Table

Managing Table Data

  • Navigating Around A Table
  • Edit A Record
  • Delete Records
  • Find And Replace Data
  • Print Tables

Formatting Table Data

  • Change Column Widths
  • Format The Datasheet
  • Move Columns
  • Freeze Columns
  • Hide And Unhide Columns

Sorting & Filtering Table Data

  • Sorting On One Column
  • Sorting On Several Fields
  • Create A Filter
  • Clear A Filter
  • Filter By Exception
  • Filter By Form

Select Queries

  • Creating A Select Query
  • Adding Selection Criteria
  • Clearing Criteria
  • Query Using Wildcards
  • Query With Logical Operators
  • Save And Reuse A Query

Forms

  • Creating A New Form Using The Form Wizard
  • Working With A Form
  • Understanding Form Objects
  • Modifying Fields In A Form
  • Moving Fields On A Form.
  • Creating A Form From A Query

Reports

  • Creating A Report Using The Report Wizard
  • Preview A Report
  • Print A Report
  • Create A Report From A Query

 

back to top ^