Computer Training

Course Objectives: Intermediate Microsoft Access 2007

Compare your skills and experiences to these objectives to see if this course would be appropriate for you to take.

  • Finding and Replacing Data
  • Sorting Records Using Common Filters
  • Filtering by Selection
  • Filtering by Form
  • Creating an Advanced Filter
  • Adjusting and Rearranging Rows and Columns
  • Changing Gridline and Cell Effects
  • Changing the Datasheet Font
  • Freezing a Column
  • Hiding a Column
  • Understanding Field Properties
  • Indexing a Field
  • Adding a Primary Key to a Table
  • Inserting, Deleting and Reordering Fields
  • Adding Field Descriptions and Captions
  • Changing the Field Size
  • Formatting Number, Currency and Date/Time fields
  • Formatting Number, Currency and Date/Time Fields by Hand
  • Formatting Text fields
  • Setting a Default Value
  • Requiring Data Entry
  • Validating Data
  • Creating an Input Mask
  • Creating a Lookup Field
  • Creating a Value List
  • Modifying a Lookup List
  • Understanding Different Types of Queries
  • Creating a Multiple Table Query
  • Creating a Calculated Field
  • Working with Expressions and the Expression Builder
  • Using an IIf Function
  • Summarizing Groups of Records
  • Display Top or Bottom Values
  • Parameter Queries
  • Finding Duplicate Records
  • Finding Unmatched Records
  • Crosstab Queries
  • Delete Queries
  • Make-Table Queries
  • Update Queries
  • Creating and Using a Form
  • Understanding Form Views
  • Modifying a Form in Layout View
  • Form Design View Basics
  • Changing Tab Order
  • Working with Control Properties
  • Control Property Reference
  • Working with Form Properties
  • Form Property Reference
  • Changing a Control’s Data Source
  • Creating a Calculated Control
  • Changing a Control’s Default Value
  • Creating a Subform
  • Modifying and Working with Subforms
  • Creating a Report
  • Working in Layout View
  • Adding a Logo
  • Working in Design View
  • Adjusting Page Margins and Orientation
  • Adding Page Numbers and Dates
  • Grouping and Sorting
  • Summarize Data using Totals
  • Understanding Report Sections
The Baker College System