Discover Classes. Earn Rewards.

Access Introduction

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.

  • Beginner
  • 18 and older
  • $695
  • 10940 Wilshire Blvd, Santa Monica, CA
  • 13 hours & 30 minutes over 2 sessions
Book Now

No Booking Fees. Lowest Price Guaranteed. Earn Rewards.

Give as a Gift Save to WishList

2 people wishlisted

Start Dates (2)

  • $695
  • ONLC Training Center - LA (West) @ 10940 Wilshire Blvd Ste 600, Santa Monica, CA 90024
  • 13 hours & 30 minutes over 2 sessions
2 seats left
Book
Show all 2 sessions
  • Mon, Apr 08 at 7:00am - 1:45pm
  • Tue, Apr 09 at 7:00am - 1:45pm
2 seats left
Book
Show all 2 sessions
  • Mon, May 06 at 7:00am - 1:45pm
  • Tue, May 07 at 7:00am - 1:45pm
Showing 12 of 2

Class Description

Description

What you'll learn in this access class:

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.

Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft® Office Access® can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone) or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 

Target Student

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

*** Version Note *** 
This course is for individuals using Access 2016, 2013 or 2010 and is taught using Access 2016 software. However, there are very few differences between the 2016 and the 2013 and 2010 versions from an end-user's perspective. Our instructors have used all 3 versions and will be able to quickly highlight the several small changes to the user interface. Users of any of the 3 versions of Access will have no problem learning in the 2016 software environment.

Prerequisites

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. 

For example, you can obtain this level of skills and knowledge by taking either of the following Logical Operations courses, or any similar courses in general Microsoft Windows skills.

Course Outline

Lesson 1: Getting Started with Access
  • Topic A: Orientation to Microsoft Access
  • Topic B: Create a Simple Access Database
  • Topic C: Get Help and Configure Options in Microsoft Access
Lesson 2: Working with Table Data
  • Topic A: Modify Table Data
  • Topic B: Sort and Filter Records
Lesson 3: Querying a Database
  • Topic A: Create Basic Queries
  • Topic B: Sort and Filter Data in a Query
  • Topic C: Perform Calculations in a Query
Lesson 4: Using Forms
  • Topic A: Create Basic Access Forms
  • Topic B: Work with Data on Access Forms
Lesson 5: Generating Reports
  • Topic A: Create a Report
  • Topic B: Add Controls to a Report
  • Topic C: Enhance the Appearance of a Report
  • Topic D: Prepare a Report for Print
  • Topic E: Organize Report Information
  • Topic F: Format Reports
Lesson 6 Designing a Relational Database
  • Topic A: Relational Database Design
  • Topic B: Create a Table
  • Topic C: Create Table Relationships
Lesson 7: Sharing Data Across Applications
  • Topic A: Import Data into Access
  • Topic B: Export Data to Text File Formats
  • Topic C: Export Access Data to Excel
  • Topic D: Create a Mail Merge

Refund Policy

Cancellation / Reschedule by Student

Because we must schedule rooms, ship course materials, assign instructors and provision computer resources well in advance, it is important students alert us ASAP with any cancel/reschedule requests.

Please note the following policies:

  • If requested 16 or more calendar days before the class
    • Cancellation requests made in this timeframe are eligible for refund less 5% cancellation fee.
    • Reschedule requests made in this timeframe will be accommodated if availability exists and will be processed at no additional charge.
  • If requested 15 calendar days or less before the class
    • Cancellation or Reschedule requests made by the student 15 calendar days or less before the class starts will be charged 100% the course fee and are not entitled to a refund.

Substitutions

  • If you are unable to attend your class, a substitute who meets the course prerequisites may attend in your place at no additional charge for the original class title, date and location. If you cannot find a substitute, you will be subject to the class cancellation policy.

Make-up Policy

Students are permitted one (1) Make-Up opportunity to attend an instructor-led class that was paid for but not previously attended for no additional charge.

  • Make-Up class registrations are subject to availability and are not entitled to refund.
  • Students may not reschedule a Make-up class registration.
  • Any no shows or cancellations forfeit their one Make-up opportunity.

Additionally, ONLC reserves the right to retire courses due to lack of demand. Retired classes are not available for Make-Up.

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.

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.

Reviews of Classes at ONLC Training Centers (7)

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

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

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

ONLC Training Centers

ONLC Training Centers

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