Access Basic Training

Class Duration: 7 hours

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

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.