Discover Classes. Earn Rewards.

Access Advanced: Formulas, Forms and Reports is unfortunately unavailable

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

Access Introduction

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Unlock the power of data management with this comprehensive course from ONLC Training Centers. Learn how to use Microsoft Office Access to organize and analyze large amounts of data, create reports, and design relational databases. Perfect for professionals in any industry who want to enhance their data management skills.

(7) Beginner 18 and older
$695

2 sessions

Gift it!

Access Advanced

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Expand your knowledge of relational database design, write advanced queries, and customize reports in this course designed for individuals with basic database management skills using Microsoft Access. Enhance your abilities to construct relational databases, perform database maintenance, and integrate Access with other programs.

(7) Advanced 18 and older
$695

2 sessions

Gift it!

Access Programming with VBA

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Master the art of automating Access with VBA scripts in this comprehensive course. Learn the Visual Basic for Applications language and Access objects needed to create powerful procedures and functions. From debugging to error handling, elevate your programming skills with ONLC Training Centers.

(7) Advanced 18 and older
$1,195

3 sessions

Gift it!
See all Access classes Los Angeles

Access Advanced: Formulas, Forms and Reports

  • Advanced
  • 16 and older
  • $349
  • 200 Pine Ave, Long Beach, CA
  • 7 hours

Start Dates (0)

  • $349
  • Accelerate Computer Training @ 200 Pine Ave Ste 280, Long Beach, CA 90802
  • 7 hours
Showing 10 of 0

Class Description

Description

What you'll learn in this access class:

In this one-day course, you will learn how to write formulas, creating calculated fields, doing math with dates, and writing expressions in queries and validation rules. You will also create sophisticated data entry forms, including navigation forms and subform containers. Finally, you will design reports and subreports, including using variables as report filters.

Prerequisites
This class is ideally suited for people who have taken Access Session 2 training or have a year or more of experience using Access.

Outline
Writing Formulas (Expressions)
  • calculated fields
  • math with dates
  • formulas in queries
  • formulas in validation rules
  • formulas that use relationships
Forms
  • create a simple data form
  • layout view
  • layout grids
  • design view
  • datasheet forms
  • navigation forms
  • subform containers
  • combo boxes as filters
Reports
  • reports and subreports
  • temporary variables
  • using temp variables as report filters

Refund Policy

  • You may cancel or reschedule a class registration at least 8 business days prior to the class without incurring any penalty.
  • After 8 business days, we may charge a penalty of up to 100% of the registration cost.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

Reviews of Classes at Accelerate Computer Training (33)

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 3490 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Accelerate Computer Training

Accelerate Computer Training, based in Long Beach, California, provides hands-on computer training classes to Southern California, Los Angeles County, Orange County and the Inland Empire in accelerated small group, instructor-led classes. Through progressive, hands-on training exercises, you learn skills...

Read more about Accelerate Computer Training

CourseHorse Approved

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

Accelerate Computer Training

Accelerate Computer Training

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.

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