Access Basic

Course Description

This class covers basic concepts in Microsoft Access and teaches foundational skills for building a database.

Training Class Goal

Students will come from this class feeling confident in designing a simple Access database or making changes to an existing one.

PreRequisites

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

Topics Covered

  • 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

Records

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

Queries

  • 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

 

Upcoming Classes

Access Basic
Sep 27 8:00 am - 4:00 pm Access Basic Westminster Access Basic Access Basic Training in Denver & Phoenix Class Price: $410 What’s included – a $900 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 27-09-2018T08:00 27-09-2018T16:00 Active
Active 27-09-2018 Active 410.00 27-09-2018
Register Now
Access Basic
Nov 28 8:00 am - 4:00 pm Access Basic Phoenix Access Basic Access Basic Training in Denver & Phoenix Class Price: $410 What’s included – a $900 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 28-11-2018T08:00 28-11-2018T16:00 Active
Active 28-11-2018 Active 410.00 28-11-2018
Register Now
Access Basic
Nov 30 8:00 am - 4:00 pm Access Basic Tech Center Access Basic Access Basic Training in Denver & Phoenix Class Price: $410 What’s included – a $900 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 30-11-2018T08:00 30-11-2018T16:00 Active
Active 30-11-2018 Active 410.00 30-11-2018
Register Now
Access Basic
Jan 11 8:00 am - 4:00 pm Access Basic Tech Center Access Basic Access Basic Training in Denver & Phoenix Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 11-01-2019T08:00 11-01-2019T16:00 Active
Active 11-01-2019 Active 450.00 11-01-2019
Register Now
Access Basic
Feb 1 8:00 am - 4:00 pm Access Basic Phoenix Access Basic Access Basic Training in Denver & Phoenix Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 01-02-2019T08:00 01-02-2019T16:00 Active
Active 01-02-2019 Active 450.00 01-02-2019
Register Now
Access Basic
Apr 10 8:00 am - 4:00 pm Access Basic Westminster Access Basic Access Basic Training in Denver & Phoenix Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 10-04-2019T08:00 10-04-2019T16:00 Active
Active 10-04-2019 Active 450.00 10-04-2019
Register Now
Access Basic
Jun 17 8:00 am - 4:00 pm Access Basic Phoenix Access Basic Access Basic Training in Denver & Phoenix Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 17-06-2019T08:00 17-06-2019T16:00 Active
Active 17-06-2019 Active 450.00 17-06-2019
Register Now
Access Basic
Jul 9 8:00 am - 4:00 pm Access Basic Tech Center Access Basic Access Basic Training in Denver & Phoenix Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 09-07-2019T08:00 09-07-2019T16:00 Active
Active 09-07-2019 Active 450.00 09-07-2019
Register Now
Access Basic
Oct 14 8:00 am - 4:00 pm Access Basic Phoenix Access Basic Access Basic Training in Denver & Phoenix Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 14-10-2019T08:00 14-10-2019T16:00 Active
Active 14-10-2019 Active 450.00 14-10-2019
Register Now
Access Basic
Oct 23 8:00 am - 4:00 pm Access Basic Westminster Access Basic Access Basic Training in Denver & Phoenix Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire class... Mission Critical Systems 23-10-2019T08:00 23-10-2019T16:00 Active
Active 23-10-2019 Active 450.00 23-10-2019
Register Now

Bookings are closed for this class.

Live & In-Person

All of the classes on this page are taught by live instructors who are present in the classroom.