Discover Classes. Earn Rewards.
Access Fundamentals is unfortunately unavailable

Access Fundamentals

at AcademyX - FINANCIAL DISTRICT

(63)
Course Details
Price:
$695
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
FINANCIAL DISTRICT
601 Montgomery St #409
Btwn Merchant & Clay Streets
San Francisco, California 94111
(Map)
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 4

What you'll learn in this microsoft office class:

Businesses, organizations and individuals worldwide use the Microsoft Access database management system to track multiple, inter-related sets of data, organize the data in tables, and generate reports to analyze the data. 

This Access Fundamentals class will teach you to use the core data management features of Access in order to make faster and more effective business decisions. Access Fundamentals will prepare you to design an Access database which is best suited to your business needs, streamline the process of entering new information by creating user-friendly data entry forms, and query the data to derive meaningful answers to critical business questions. 

This course draws heavily on real-world examples which will give you exposure to the complex database management problems Access users face, and will equip you to make the best use of Access right away.

Getting Started with Access

  • Navigate using the Navigation Pane and the Access Ribbon toolbar.
  • Understand Access terminology for databases, tables, records, and fields.
  • Identify the uses of various objects in Access such as a Query or a Macro.

Designing the Database

  • Design tables best suited to the purpose of your database.
  • Implement consistent and logical naming conventions to make your database easier for others to use.
  • Harness existing templates to avoid unnecessary duplication of effort.

Entering Data and Managing Records

  • Use database table fields to quickly find and edit records.
  • Add captions to provide additional information useful for data entry.
  • Create validation rules and input masks for searchable and accurate records.
  • Employ "wildcards" to generate meaningful results on even the most difficult searches.

Using Queries Effectively

  • Retrieve and display a set of database records based on any number of criteria.
  • Use the Query Wizard for faster, easier query creation, or code powerful queries using Structured Query Language.
  • Refine the set of results by modifying, saving or restoring previous queries.
  • Perform global updates and calculations on query results.

Generating Meaningful Reports

  • Build custom reports which communicate the data and support business decision making.
  • Modify a report's design while viewing the data for optimal visual effect.
  • Preview a report and modify the page layout as needed for printing.

Prerequisites:

  • A solid understanding of Windows file management, the concepts of right-clicking and selecting object properties

Still have questions? Ask the community.

Refund Policy
If you need to reschedule or cancel a class, it's usually no problem. We will move you to a different session, or give you a full refund as long as you give us at least 7 days' notice. If, however, you notify us less than one week before the class (a "late-cancellation"), we do not offer a refund and you only qualify for a late-reschedule. We charge $25 for any reschedule, $50 for reschedules with fewer than 72 hours' notice, and $100 for reschedules with fewer than 24 hours' notice (or no-shows)
Students may withdraw from any course (except when they have late-rescheduled) after instruction has started within 2 hours and receive a full refund, provided the reason for their withdrawal is dissatisfaction with the course. In the case of multi-day and multi-evening courses, students may withdraw after any session before the course's half-way point and receive pro-rated refund for the unused portion of the tuition.

Map

Google Map

AcademyX

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

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 about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at AcademyX (63)

School: AcademyX

AcademyX

AcademyX offers hands-on, instructor-led training in MS Office, Adobe web and graphic design apps, web technologies, programming languages and servers.  In business since 2000, we have trained over 15,000 students. We use contract trainers that practice in the field when they're not teaching classes....

Read more about AcademyX

CourseHorse Approved

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

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here
Loading...