Course Outline

Microsoft Access 2007 - 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

  • Identifying Field Size
  • Formatting Fields
  • Setting an Input Mask for Data Input Consistency
  • Inserting Field Captions
  • Setting Up Default Values
  • Using Validation Rules and Text
  • Identifying Required Fields
  • Using the Description Field
  • Setting Datasheet Options
  • Using the Name AutoCorrect Feature

Indexing and Lookups

  • Using Multiple Table Design
  • Identifying and Assigning Primary Keys
  • Indexing Fields
  • Indexing on Multiple Fields
  • Creating Lookups

Expressions in Queries

  • Introduction to the Expression Builder
  • Building Numerical Expressions
  • Building Formatting Expressions
  • Creating Date and Time Expressions
  • Creating Text Expressions
  • Sorting and Creating Criteria in Expressions

Functions in Queries

  • Creating IIF Function
  • Using Date and Time Functions
  • Inserting Text Functions

Parameters in a Query

  • What is a Parameter?
  • Creating Multiple Parameters
  • Data Typing Parameters
  • Creating a Criteria Expression with Parameters
  • Reordering Parameters
  • Identifying a Parameter as a Field (Optional)
  • Using Parameters in Expressions Fields (Optional)

Exporting and Importing Data

  • Importing an Access Table from a Database
  • Import and Linking an Excel Spreadsheets into an Access Database
  • Export data from an Access database into a Word Documents
  • Export an Access Database to
    ASCII
Prerequisites:  Access Level One 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