Course Outline

Microsoft Access 2003 Level 2
If you would like to work more effectively in Access, then this course is for you! Get down to the details with crucial information on properties to define your fields. Learn about parameters and functions in queries. Focus on how to use commands, filters and queries more efficiently in order to accurately retrieve the information you need. 6 hours

Table and Query Properties

  • Creating charts
  • Field size
  • Format and decimal places
  • Input mask
  • Caption
  • Default value
  • Validation rule and text
  • Required
  • Description
  • Top values

Indexing and Lookups

  • Multiple table design
  • Primary key
  • Indexed property
  • Multiple field index
  • Looking up key descriptions

Expressions in Queries

  • Expression builder
  • Numerical expressions
  • Formatting expressions
  • Date and time expressions
  • Text expressions
  • Sorting and criteria in expressions

Functions in Queries

  • Getting help with functions
  • If function
  • Date and time functions
  • Text functions

Parameters in a Query

  • What is a parameter?
  • Multiple parameters
  • Data typing parameters
  • Criteria expressions with parameters
  • Recording parameters
  • Parameter as a field
  • Parameters in expressions field

Exporting and Importing Data

  • Access databases
  • Excel spreadsheets
  • Word documents
  • Delimited ASCII
  • Fixed ASCII
Prerequisites:  Access Level 1 or equivalent experience.

Revised 8/16/2011
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600