Discover Classes. Earn 10% Rewards.

Access 2016 - Level 1 & 2 is unfortunately unavailable

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

All Day Private Digital Photography for 1-6 People (Seattle)

Digital Photo Academy @ Cross Streets TBA, Seattle, WA

Unlock the secrets to stunning photography with a personalized, full-day session in Seattle. Capture breathtaking shots, master your camera settings, and elevate your post-capture skills with expert guidance from Digital Photo Academy instructors. Discover your unique photographic style and create portfolio-worthy images in this private, immersive experience.

(146) All levels 15 and older
$675
Attend
+6750 pts
Gift it!

Half Day Private Digital Photography for 1-6 People (Seattle)

Digital Photo Academy @ Cross Streets TBA, Seattle, WA

Unlock the full potential of your camera and capture stunning images with personalized instruction in Seattle. Discover the best settings for your camera, explore different photography genres, and enhance your post-capture workflow. Join us for a private session tailored to your needs and take your photography to the next level.

(146) All levels 15 and older
$375
Attend
+3750 pts
Gift it!
See all Access classes Seattle

Access 2016 - Level 1 & 2

  • Intermediate
  • 18 and older
  • $530
  • Earn 5,300 reward points
  • Price Lock Guarantee
  • 12822 SE 32nd St, Bellevue, WA
  • 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

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)

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

TLG Learning

TLG Learning

All classes at this location

Google Map

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