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, offered in Denver and 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.
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 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
- 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.
Live & In-Person
All of the classes on this page are taught by live instructors who are present in the classroom.
Retake any public class up to 6 months after original class date....Read more
Interactive classes allow you to immediately try out new skills....Read more
Live instructors deliver our classes in an engaging and interactive way....Read more
Classes limited to 12 students for more individual attention....Read more