All Microsoft Access classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Microsoft Access Bootcamp
Access Bootcamp
Learn foundational through intermediate Microsoft Access skills in this Access Bootcamp training. This two-day course starts with the essentials of Access and relational databases then moves into intermediate skills such as joining tables, improving data structure, validating data, and conducting advanced queries, .
In this two-day Access Bootcamp start by learning to create a new database, design forms, build tables, and generate reports. Also learn to filter data, sort data, manage data sets and conduct advanced queries. Learn efficient use of Microsoft Access to create, store, and report on sets of data.
Why Microsoft Access classes at AGI are the best option for you
- Hands-on learning: Learn Microsoft Access quickly with our proven teaching methods.
- Exceptional curriculum: AGI has delivered Microsoft Access training to thousands over 25 years.
- Expert instructors: Our instructors are Microsoft Access experts and skilled educators.
- Small class sizes: Receive personalized attention with 10 or fewer participants per class.
- Repeat for Free: If you need a refresher or miss a class day, retake the Microsoft Access class at no cost.
Questions about this Microsoft Access Bootcamp? Interested in a private or customized training? Call to speak with a training consultant: 781-376-6044.
Ways to attend this Microsoft Access Course
- Live Online classes from your office or home as a regularly scheduled small group class.
- Live, in-person regularly scheduled Microsoft Access classes in Boston or Philadelphia with a live instructor in the same classroom.
- Private training customized to your specific needs delivered in-person or online. Call 781-376-6044 or complete the Private Microsoft Access Training form for more information.
Please call 800-851-9237 or 781-376-6044 to schedule a course.
Access Training Course - Introduction: Key Topics
- Access Fundamentals
- Working with Table Data
- Querying an Access Database
- Creating and Using Access Forms
- Generating Reports
- Designing a relational database
- Joining Tables
- Validating Data
- Using Advanced Queries
- Improving Data Organization
- Understanding Advanced Reporting Options
Access Training Course - Introduction: Complete Class Topics
Access Fundamentals
- Orientation to Microsoft Access
- Create a Simple Access Database
- Configuring Options in Microsoft Access
- Understanding the Help options
Working with Table Data in Access
- Modifying Table Data
- Sorting Records
- Filtering Records
Querying an Access Database
- Create Basic Queries in Access
- Sorting Data in a Query
- Filtering Data in Query
- Perform Calculations as part of a Query
Creating and Using Access Forms
- Creating Forms using Access
- Work with Data in Access Forms
Generating Reports
- Create a Report
- Add Controls to a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
- Organize Report Information
- Format Reports
Designing Relational Databases
- Fundamentals of Relational Database Design
- Creating Tables
- Creating Table Relationships
Joining Tables in Access
- Creating Query Joins
- Relating Data Within a Table
- Working with Subdata sheets
Using Access Data Validation
- Validating Fields
- Using options for Form and Record Validation
Creating Advanced Queries in Access
- Creating Parameter Queries
- Summarizing Data
- Creating Subqueries
- Creating Action Queries
- Creating Unmatched and Duplicate Queries
Organizing an Access Database for Efficiency
- Data Normalization
- Create Junction Tables
- Improving Table Structure
Using Advanced Reporting Techniques in Access
- Including Control Formatting in Reports
- Adding Calculated Fields to Reports
- Add a Subreport to Existing Reports
Custom and private Microsoft Access classes
This Microsoft Access course is available as a private class. Curriculum can be customized for your specific needs. Microsoft Access classes can be delivered at your location, online, or in our classrooms. For more information, call 781-376-6044 to speak with a training consultant or contact us.
We recommend that you have Access installed on your computer before starting this class.
You will receive a comprehensive course manual for this Access class developed by the instructors at AGI. AGI instructors have created many of the official training guides and books for Microsoft.