Discover Classes. Earn Rewards.

Access Beginning

Learn the essential skills for data entry and filtering in Microsoft Access. Develop your ability to create and edit queries, as well as generate reports to extract valuable information. Join our hands-on training program and enhance your data management expertise.

  • Beginner
  • 18 and older
  • $250
  • 6212 Ferris Square, San Diego, CA
  • 7 hours
Access Beginning
Book Now

No Booking Fees. Lowest Price Guaranteed. Earn Rewards.

Give as a Gift Save to WishList

1 person wishlisted

Start Dates (2)

  • $250
  • AGC San Diego Chapter @ 6212 Ferris Square, San Diego, CA 92121
  • 7 hours
14 seats left
Book
14 seats left
Book
Showing 12 of 2

Class Description

Description

What you'll learn in this access class:

Since 1992 we have provided affordable, hands-on computer training classes to over 25,000 San Diego residents and businesses. Our classes are small, reasonably-priced, and to the point - a winning combination that has proved popular with our students. Instructor is a Certified Microsoft Office Specialist (Master level) and QuickBooks ProAdvisor with over 25 years full-time teaching experience.

This class is intended for:

  • PC/Windows Users: Access 2010-2013-2016-2019-365
  • Version Used in Class: Access 365
  • Course Materials: FREE
  • Certificate of Completion (optional): $5
  • Course Length: 1 Day
  • This class focuses on Data Entry (using forms) and Data Filtering (using queries and reports).

ACCESS BASICS:

Learn how to create, edit, and save a wide variety of queries and reports. This course is an excellent introduction or refresher for anyone who will be entering data and/or extracting data.

DATA ENTRY:

Enter, edit, and delete data in forms and tables.

SORT AND FILTER DATA:

Use Find & Replace to edit data in table, use Quick Sort to sort data, use Filter by Selection to locate specific data in tables and forms.

CREATE QUERIES:

  • Create a number of different Queries that will sort and filter data using different criteria such as name, amount, and date. 
  • Use multiple criteria (text, numbers, dates) to narrow a search, use wildcards, use parameters, filter data by text, a range of dates or amounts, etc. 
  • Create queries based on existing queries/tables, rename queries, and delete queries. 
  • Add calculated fields that don't exist in table (i.e. a field that will calculate sales tax).

QUERY TYPES:

  • Select Queries (basic queries)
  • Parameter Queries (ask for user input to narrow results)
  • Unmatched Records Queries (records not found in related table)
  • Duplicate Records Queries (find duplicate records)
  • CrossTab Queries (summarize data in columns and rows)
  • Append Queries (add data to a table)
  • Delete Queries (remove data from a table)
  • Update Queries (update a large number of records)
  • Make Table Queries (new table based on another table)
  • Summary Queries

Refund Policy

Transfer Policy:

  • You can transfer free-of-charge to another class provided that you give us at least 2 business days advance notice by phone or e-mail.
  • You can also send someone else in your place. Please inform us who will attend the class.

Refund Policy:

  • If you feel a class isn't right for you, just let the instructor know during the first break. We will issue a full-refund, transfer you to another class, or issue a full credit for the class - Your choice. You must inform the instructor during the first break!

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 Computers Etc Software Training Center (4)

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

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

Computers Etc Software Training Center

Computers Etc. was founded in 1992 in Poway, California and originally focused on computer sales and service. Two years later we started offering computer classes and began to phase out computer sales and services. By 1996 the company was specializing in software training and the name was changed to...

Read more about Computers Etc Software Training Center

CourseHorse Approved

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

Computers Etc Software Training Center

Computers Etc Software Training Center

All classes at this location

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