This class covers basic concepts in Microsoft Access and teaching the foundational skills for designing and building a database. Students will come from this class feeling confident in designing a simple Access database or making changes to an existing one.


Intermediate computer skills and experience with Microsoft Excel and other Microsoft Office programs.


Database Concepts

  • Design vs. Datasheet View
  • Database wizard
  • Creating blank databases
  • Creating tables

Working with Fields

  • Adding fields
  • Identifying primary key fields
  • Adding records
  • Changing table designs
  • Modifying field names
  • Deleting and inserting fields


  • Finding and editing records
  • Sorting and filtering records
  • Setting field properties
  • Input Masks
  • Validation Rules
  • Indexes


  • Creating Queries
  • Filtering Queries
  • Modifying query results
  • Operations in Queries
  • Using Calculators
  • Average and Count functions
  • Creating forms to enter data
  • formatting and customizing forms
  • Using forms to find, sort, and filter records
  • Creating reports through the report wizard
  • Field properties



0.70 Continuing Education Units
Course ID #TECH248

Class Details

Location:Mission Critical Systems - Tech Center, 7384 S Alton Way Ste 201, Centennial, CO 80112-2369
Time:8:00 am to 4:00 pm
List Price:$450.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Time:8:00 am to 4:00 pm
List Price:$450.00

Don't see what you are looking for?

Contact Us