Discover Classes. Earn 10% Rewards.

Access Queries is unfortunately unavailable

Unlock the power of data manipulation with our Access Queries course. Gain proficiency in sorting, filtering, updating, and calculating data within Microsoft Access databases, equipping you with essential skills for efficient data extraction and analysis. Dive deeper into database management alongside our comprehensive curriculum.

  • Beginner
  • Small class sizes
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    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!

  • 6212 Ferris Square, San Diego, CA
  • 3 hours

Start Dates (0) $125/person

No upcoming dates are currently available.

Book a Private Group Event

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

Or see all Professional Group Events

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

Class Description

Description

This course is an excellent introduction for anyone who needs to extract data from a Microsoft Access database. Learn how to use a wide variety of different queries to sort, filter, update, delete, and calculate data. If you’d like to learn how to create a simple one-table database, check out our Beginning Access course which covers tables, forms, and reports in addition to queries.

Topics Covered:

  • Quick Sort by text, dates, or values
  • Filter by Selection (filter by contents of a specific field)
  • Create, rename, and delete queries
  • Multiple Criteria narrow a search
  • Wildcards to expand a search
  • Calculated Fields
  • Parameter Queries (request user input to filter search results)
  • Unmatched Records Queries locate records not found in related table
  • Duplicate Records Queries find duplicate records
  • Append Queries add records
  • Delete Queries remove records
  • Update Queries update records
  • Make Table Queries create new tables based on existing tables
  • Summary Queries summarize large amounts of data in rows
  • Cross Tab Queries summarize data in columns and rows

NOTE: Queries listed above are also covered in the Access Beginner class. 

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 (5)

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 1250 points. Earn 10% back in reward points!

Computers Etc Software Training Center

Computers Etc. Software Training Center, founded in 1992, specializes in software training for popular programs such as Access, Excel, Outlook, PowerPoint, Word, and QuickBooks. They differentiate themselves from other training companies by offering small classes, affordable prices, a convenient schedule, and a supportive atmosphere.

View school profile
Computers Etc Software Training Center
Vetted by CourseHorse

A verified San Diego educator.

Loading...