Access Basic

Course Description

Access Basic Training in Denver & Phoenix

icon_access

Do you need to build a database and you don’t know where to start?  Microsoft Access allows you to build and manage a database to help you gather information, and keep it organized, accessible, and at your fingertips. This Basic Access training in Denver & Phoenix introduces the application and its basic concepts, teaching the foundational skills for building a database.  Our Access training includes ample hands-on activities, to ensure you have mastered each lesson.  Our knowledgeable educators will be with you to lead you to a thorough understanding of the material, and answer all your questions.

Class Price: $410

Training Class Goal

Students will come from this Access training course feeling confident in designing a simple Access database, or making changes to an existing one. They will possess an understanding of the basic building blocks of a database, such as Fields, Records, and Queries.  They will also know how to generate simple reports to put their database information to work for them.

PreRequisites

Students who enter this course should possess intermediate computer skills, and  have experience with Microsoft Excel and other Microsoft Office programs.

Topics Covered

  • Design versus 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

Our Basic Microsoft Access Training class i Denver and Phoenix will let you begin to build and manage databases, with a strong foundation upon which to build your skills.

Upcoming Classes

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
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
23-10-2019 Active 450.00 23-10-2019
Register Now
Access Basic
Apr 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-04-2020T08:00 09-04-2020T16:00 Active
09-04-2020 Active 450.00 09-04-2020
Register Now
Access Basic
Oct 21 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 21-10-2020T08:00 21-10-2020T16:00 Active
21-10-2020 Active 450.00 21-10-2020
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.