Access Basic Training

Class Duration: 7 hours

AccessDo 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 class 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.

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 a simple databases
  • Creating tables

Working with Table Data

  • Modify Table Data
  • Adding records
  • Sort and filter records
  • Modifying field names
  • Deleting and inserting fields

Queries

  • Creating basic queries
  • Sorting and Filtering Queries
  • Modifying query results
  • Operations in Queries
  • Using Calculators

Using Forms

  • Creating basic forms
  • Using forms to find, sort, and filter records

Generating Reports

  • Creating reports through the report wizard
  • Adding controls
  • Enhancing the appearance of a report
  • Printing a report
  • Organizing report information
  • Formatting reports

Our Basic Microsoft Access Training class will let you begin to build and manage databases, with a strong foundation upon which to build your skills. Our courses are designed specifically for companies and their employees. Our instructors are based in Denver and Phoenix but can travel anywhere in the country.