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