Microsoft Access Training: Access Part 1 (Introduction)

Price
$590.00 USD

Duration
2 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Course Overview

Professionals using advanced query design techniques complete complex data retrieval tasks up to 40% faster and with greater accuracy than those relying only on basic tools. The Microsoft Access Training – Access Part 2 course equips you with the advanced features, queries, reports, and relational design practices, that make this level of efficiency possible.

In this course, you will expand your knowledge of relational database design, promote quality input from users, and learn how to improve database efficiency while strengthening data integrity. You’ll also implement advanced features in tables, queries, forms, and reports, giving you the ability to build databases that are more reliable, usable, and scalable.

The training focuses on optimization of Access databases, including performance tuning, normalizing data, applying data validation rules, and improving usability.

What Is Included

  • Expert-led Microsoft Access training with real-world examples
  • Official courseware and supplemental materials
  • Certificate of completion
  • Hands-on labs and interactive exercises
  • Access to class recordings for 90 days
  • Guaranteed-to-run dates (where marked)
  • Flexible rescheduling options (see conditions)
  • Free retake options

Course Objectives

After completing this Microsoft Access training course, you will be able to:

  • Navigate within the Access environment, create a simple database, and customize options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data across multiple tables.
  • Design forms to simplify data entry and review.
  • Create and format custom reports for professional output.
  • Apply validation techniques to ensure data accuracy and integrity.

Who Should Attend?

This Microsoft Access training is designed for professionals who need to create and manage databases. Typical participants include administrative staff, office managers, business analysts, and anyone responsible for storing and reporting structured data. It’s also ideal for beginners who want a solid foundation in relational database concepts.

  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

What is the Microsoft Access training: Access – Part 1 course? Is it worth it?

This beginner-level Microsoft Access training is designed for professionals who want to create and manage databases using Access. The course covers database creation, table design, queries, and forms and reports—giving you practical skills in one of the most widely used relational database management systems (DBMS). Access courses like this one are highly valued in the workplace, where strong data management and data analysis skills are in demand. Many roles requiring Access skills earn $70,000–$90,000 annually, making this course a worthwhile investment in your career.

Will this course help me build and manage a company database?

Yes. This Microsoft Access course provides hands-on experience in database creation, setting table relationships, and enforcing data integrity. You’ll also learn to create queries, advanced queries, and build forms and reports that streamline information management. Whether you’re handling large amounts of data or smaller datasets, the learning objectives prepare you to work confidently across different data structures.

Will this Microsoft Access training help me create reports for business decision-making?

Yes. You’ll gain practical skills in report generation, complex queries, and data manipulation, allowing you to produce insights for better decision-making.

What version of Microsoft Access is taught?

New Horizons offers versionless Microsoft Access classes so you can apply your skills across multiple releases of the software. This approach increases schedule availability and ensures you focus on concepts that transfer to any version of Microsoft Access. If your organization requires a specific version such as Access 2016, we can provide that through a dedicated group training class request.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

Corporate Tech Pass: Our Corporate Tech Pass includes unlimited attendance for a single person, in the following Virtual Instructor Led course types: Microsoft Office, Microsoft Technical, CompTIA, Project Management, SharePoint, ITIL, Certified Ethical Hacker, Certified Hacking Forensics Investigator, Java, Professional Development Courses and more. The full list of eligible course titles can be found at https://www.newhorizons.com/eligible.

If you have questions about our Corporate Tech Pass, please contact your Account Manager.

Course Prerequisites

  • Basic computer literacy
  • Basic PC operating system navigation skills
  • Basic Internet usage skills
  • Basic IP address knowledge

Agenda

Getting Started with Access

  • Launch Access and open a database
  • Use tables to store data
  • Use queries to combine, find, filter, and sort data
  • Use forms to view, add, and update data
  • Use reports to present data
  • Get help and configure options in Microsoft Access

Creating Tables

  • Plan an Access database
  • Start a new Access database
  • Create a new table
  • Establish table relationships

Creating Queries

  • Create basic queries
  • Perform calculations in a query
  • Sort and filter data in a query

Creating Forms

  • Start a new form
  • Enhance a form

Creating Reports

  • Start a new report
  • Enhance report layout

Promoting Quality Data Input

  • Restrict data input through field validation
  • Restrict data input through forms and record validation

Improving Efficiency and Data Integrity

  • Data normalization
  • Associate unrelated tables
  • Enforce referential integrity
 

Upcoming Class Dates and Times

Oct 20, 21
8:00 AM - 4:00 PM
ENROLL $590.00 USD
Dec 4, 5
8:00 AM - 4:00 PM
ENROLL $590.00 USD
CourseID: 3601557E
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons