Discover Classes. Earn 10% Rewards.

Access 2016 - Level 1 & 2 is unfortunately unavailable

Thankfully we have 10 other Access Classes for you to choose from. Check our top choices below or see all classes for more options.

Access – Part 1

TLG Learning

Discover the power of Microsoft Access as you learn to create and manage a database, organize and analyze data, and design custom forms and reports. Take your data management skills to the next level with this foundational course.

(1) All levels 18 and older
$590

2 sessions

Attend
+5900 pts
Gift it!

Access – Part 2

TLG Learning

Expand your knowledge of Microsoft Access and become an expert in database design, efficiency, and data integrity. Improve tables, queries, forms, and reports to create a robust, functional database. Prepare for the Access Expert certification with this course.

(1) All levels 18 and older
$590

2 sessions

Attend
+5900 pts
Gift it!

Access Advanced

ONLC Training Centers @ Online Classroom

Your training and experience using Microsoft® Access® has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database...

(7) Advanced 18 and older
$695

2 sessions

Attend
+6950 pts
Gift it!

Microsoft Access Fundamentals

Training Connection @ Online

Learn how to design and build efficient relational databases, run queries, and create forms and reports in Microsoft Access with this hands-on course from Training Connection. Suitable for beginners, this class will provide you with a solid working knowledge of Access 2016, 2019, and 365.

(158) Beginner 14 and older
$995

2 sessions

Attend
+9950 pts
Gift it!

Access Programming with VBA

ONLC Training Centers @ Online Classroom

Learn how to program in Access and enhance your database management skills with this comprehensive course in Access Programming with VBA. Discover how to create modules, navigate the Access object hierarchy, work with expressions and variables, control program execution, debug code, and handle errors effectively. Gain the knowledge and skills necessary to take your Access programming abilities to the next level.

(7) Advanced 18 and older
$1,195

3 sessions

Attend
+11950 pts
Gift it!
See all Access classes Online

Access 2016 - Level 1 & 2

  • Intermediate
  • 18 and older
  • $530
  • Earn 5,300 reward points
  • Price Lock Guarantee
  • Interactive Online Classroom
  • 16 hours over 2 sessions
Access 2016 - Level 1 & 2
Sold Out

Start Dates (0)

  • $530
  • 16 hours over 2 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this access class:

Learn essential skills to design, create, and use an Access database in Microsoft Office 2016, including relational database concepts, planning and creating a database, data entry guidelines, and working with forms, queries, and reports. Access 2016 is also Access for Office 365.

Pre-requisite(s): At least one year experience using Windows 10, 8, or 7

Outline:

Lesson 1 : Getting Started
  • Database concepts 
  • Exploring the Access environment 
  • Getting help
Lesson 2 : Databases and tables
  • Planning and designing databases 
  • Exploring tables 
  • Creating tables
Lesson 3 : Fields and records
  • Changing the design of a table 
  • Finding and editing records 
  • Organizing records
Lesson 4 : Data entry rules
  • Setting field properties 
  • Working with input masks 
  • Setting validation rules
Lesson 5 : Basic queries
  • Creating and using queries 
  • Modifying query results and queries 
  • Performing operations in queries
Lesson 6 : Using forms
  • Creating forms 
  • Using Design view 
  • Sorting and filtering records
Lesson 7 : Working with reports
  • Creating reports 
  • Modifying and printing reports
Lesson 8 : Relational databases
  • Database normalization 
  • Table relationships 
  • Referential integrity
Lesson 9 : Related tables
  • Creating lookup fields 
  • Modifying lookup fields 
  • Subdatasheets
Lesson 10 : Complex queries
  • Joining tables in queries 
  • Using calculated fields 
  • Summarizing and grouping values
Lesson 11 : Advanced form design
  • Adding unbound controls 
  • Graphics 
  • Adding calculated values 
  • Adding combo boxes 
  • Advanced form types
Lesson 12 : Reports and printing
  • Customized headers and footers 
  • Calculated values 
  • Printing 
  • Labels
Lesson 13 : Charts
  • Charts in forms 
  • Charts in reports
Lesson 14 : PivotTables and PivotCharts
  • PivotTables 
  • Modifying PivotTables 
  • PivotCharts 
  • PivotTable forms

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Refund Policy

Open Enrollment Desktop Applications Classes -- You may reschedule or cancel your enrollment in a Desktop Applications class at no charge with at least five (5) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel your registration you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.

Open Enrollment Technical Training Classes with Level TT1, TT2 or TT3 Tech Pricing -- You may reschedule or cancel your enrollment in a Technical Training Class with Level TT1, TT2 or TT3 Tech Pricing at no charge with at least ten (10) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.

Reviews of Classes at TLG Learning (1)

Similar Classes

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 5300 points. Earn 10% back in reward points!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

TLG Learning

For over 20 years, TLG Learning has been trusted by premier companies and government agencies.

We provide complete learning solutions on Microsoft, F5 Networks, ITIL, Cisco, Citrix, CompTIA, VM Ware, Adobe, Project Management, Business Skills, and more.

During the past 3 years, 99% of over 10,000 TLG...

Read more about TLG Learning

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online educator.

TLG Learning

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

  • Price Lock Guarantee

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • Earn 10% Reward Points

    Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!

  • No Added Fees

    Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!

  • Curated Courses

    Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...