Online Class: Microsoft Access 2010

Microsoft Access 2010 is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amount

$70.00
no certificate
- OR -
$95.00
with CEU Certificate*
Start Right Now!
$95.00 (with CEU Certificate)
Taking multiple courses? Save with our platinum program.
 
  • 23
    Lessons
  • 35
    Exams &
    Assignments
  • 385
    Students
    have taken this course
  • 15
    Hours
    average time
  • 1.5
    CEUs
 
 

Course Description

Microsoft Access 2010 is an information management tool that allows you to store, report, and analyze information within a relational database.  If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you.   Access  makes it easy to keep track, organize, and sort your data.    It can be the back-end of a business, keeping your records for you.

It is this course's purpose to teach you the important features of Access 2010 and how to use them.   This course was designed for beginners so that even if you've never so much as opened the program before, you can learn how to use it.    Once we cover the basics, we'll move on to advanced features.  If you've used Access before, perhaps prior versions, the first few lessons will be a refresher and introduce you to some of the updates you'll encounter in the newest version of Microsoft Access.  

You'll learn:

·    All about databases and how they work

·    An understanding of how Access works to make even its complex inner workings seem simple

·    How to navigate Access

·    How to create tables, forms, reports, and queries

·    How to enter criteria into your data

·    How to form expressions and create functions

·    How to customize the appearance of forms and reports

·    How to use Access for home-record keeping or for a business

And much, much more

If you're not familiar with Access 2010, it can be overwhelming.   The program is large and navigating it without any help or experience can seem impossible.   This course takes its time and shows you around Access.   We'll break everything down into small chunks so that Access 2010 is just as easy for the beginner to use as it is someone who's been using it for years.   And if you've used Access before, don't worry.   We have plenty of updates to show you – and a few more things to teach you as well.

 
  • Completely Online
  • Self-Paced
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 

Course Lessons

Average Lesson Rating:
4.1 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(1,664 votes)

Lesson 1: Microsoft Access 2010 Introduction

Microsoft Access is an information management tool that allows you to store, report, and analyze information. Additional lesson topics: Microsoft Access ; What's New? 6 Total Points
  • Lesson discussions: Access 2010; Reasons for Taking this Course
  • Assessment: Lesson 1 Exam

Lesson 2: Access 2010 Requirements and Setup

This lesson discusses the limits and requirements for running and operating MS Access 2010. Additional lesson topics: Migrating from Access ; Installing Access ; Office 365 Home Premium Trial version 10 Total Points
  • Assessment: Lesson 2 Exam

Lesson 3: About Databases and Normalization

Creating a database in Access is very easy to do. However, creating a good relational database that performs well isn't so easy. Additional lesson topics: Creating a Database; Normalization 10 Total Points
  • Assessment: Lesson 3 Exam

Lesson 4: Access 2010 Database Objects

A database contains objects that are used to store and display large, relational data. Additional lesson topics: Database Objects; Managing Databases and Objects 35 Total Points
  • Complete: Lesson 1 - 4 Assignment
  • Assessment: Lesson 4 Exam

Lesson 5: Navigating MS Access 2010

Now that we've covered the basics of a database and learned some important definitions, we're going to start learning MS Access 2010. Additional lesson topics: Backstage View; Quick Access Toolbar 35 Total Points
  • Complete Assignment: Lesson 5 Navigating Access
  • Assessment: Lesson 5 Exam

Lesson 6: Creating a Database and Adding Tables

To add data, we must first create tables. Additional lesson topics: Creating a Database; Tables 33 Total Points
  • Complete: Lesson 6 Assignment
  • Assessment: Lesson 6 Exam

Lesson 7: Object Views

Object views are simply different ways of viewing the object that you're working on. Additional lesson topics: A Simple Crosstab Query 9 Total Points
  • Assessment: Lesson 7 Exam

Lesson 8: Creating Simple Forms

A form is an Access database object that's used to create an interface for a database application. Additional lesson topics: Create Simple Forms 34 Total Points
  • Lesson discussions: Using Access 2010
  • Complete: Lesson 8 Assignment
  • Assessment: Lesson 8 Exam

Lesson 9: Introduction to Controls and Formatting Forms

Controls simply let you view and work with the data that you have in your database. Additional lesson topics: Other Window Controls 35 Total Points
  • Complete: Lesson 9 Assignment
  • Assessment: Lesson 9 Exam

Lesson 10: Queries

If you want to review, add, or change data in your database, you can use a query. Additional lesson topics: Queries for a New Database; Setting Query Criteria 34 Total Points
  • Complete: Lesson 10 Assignment
  • Assessment: Lesson 10 Exam

Lesson 11: Using Criteria, Operators, and Wildcards

Query criteria are expressions that Access will compare to the values in your query fields to decide whether or not to include the records that contain values. Additional lesson topics: Examples of Query Criteria; Table of Operators 9 Total Points
  • Assessment: Lesson 11 Exam

Lesson 12: Parameter Queries

Whenever you want a query to ask for input each time you run the query, you create what's called a parameter query in Access 2010. Additional lesson topics: Using Parameters 35 Total Points
  • Complete: Lesson 12 Assignment
  • Assessment: Lesson 12 Exam

Lesson 13: Relationships and Joins

When you define a relationship in Access, you relate data from one table to another. Additional lesson topics: Building Relationships Among Databases; Joins 34 Total Points
  • Complete: Lesson 13 Assignment
  • Assessment: Lesson 13 Exam

Lesson 14: Creating Calculated Expressions

Expressions in Access 2010 are used to do mathematical calculations, combine or extract text, or validate the data in your database. Additional lesson topics: Calculated Fields; How to Write Expressions 35 Total Points
  • Complete: Lesson 14 Assignment
  • Assessment: Lesson 14 Exam

Lesson 15: Summarizing Data

An aggregate query lets you determine statistics for a set of values. Additional lesson topics: Creating Custom Groups; Introduction to Reports 10 Total Points
  • Assessment: Lesson 15 Exam

Lesson 16: PivotTables

In this lesson, you're going to learn how to create and customize the PivotTable view. Additional lesson topics: Create a PivotTable; How to Use a PivotTable 10 Total Points
  • Assessment: Lesson 16 Exam

Lesson 17: PivotCharts

Instead of rows and columns like with PivotTable view, PivotChart view shows series and category areas. Additional lesson topics: Add a PivotChart; PivotCharts 10 Total Points
  • Assessment: Lesson 17 Exam

Lesson 18: Reports

Access 2010 gives you the ability to run reports to view your data. Additional lesson topics: Creating Reports; Using the Report Wizard 35 Total Points
  • Complete: Lesson 18 Assignment
  • Assessment: Lesson 18 Exam

Lesson 19: Designing Your Report

Once you have your report created, you can now modify it to create a more attractive design for it. Additional lesson topics: Creating a Report 8 Total Points
  • Assessment: Lesson 19 Exam

Lesson 20: Advanced Formatting for Reports

To group and sort data in your reports, switch to Design view and go to the Design tab. Additional lesson topics: Formatting Reports in Layout View 10 Total Points
  • Assessment: Lesson 20 Exam

Lesson 21: Macros

A macro is essentially a shortcut; a way to automate regularly used tasks or routines. Additional lesson topics: Working with Macros 10 Total Points
  • Assessment: Lesson 21 Exam

Lesson 22: Printing and Exporting Reports

There are many new ways to print and export reports in Access 2010. In this lesson, we'll introduce you to them, and show you how to do them. Additional lesson topics: Export to PDF; Exporting to Excel 9 Total Points
  • Assessment: Lesson 22 Exam

Lesson 23: Importing and Exporting Data

In this lesson, we're going to learn the multiple ways that you can import and export data to/from Access. Additional lesson topics: Import from Excel; Importing Data 130 Total Points
  • Lesson discussions: Access 2010 Use; Course Comments; Program Evaluation Follow-up Survey (End of Course)
  • Complete: Lesson 23 Assignment
  • Assessment: Lesson 23 Exam
  • Assessment: The Final Exam
586
Total Course Points
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Define what MS Access is and why it is useful
  • Describe about databases and normalization.
  • Summarize database objects.
  • Demonstrate navigatipm
  • Demonstrate creating a database and adding tables.
  • Summarize object views.
  • Demonstrate creating simple forms.
  • Summarize controls and formatting forms.
  • Demonstrate query usage and using criteria, operators, and wildcards.
  • Demonstrate parameter queries.
  • Demonstrate relationships and joins.
  • Demonstrate creating calculated expressions.
  • Describe summarizing data.
  • Demonstrate pivot tables usage
  • Demonstrate designing, creating and printing reports.
  • Determine macro usage.
  • Summarize importing and exporting data.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 

Additional Course Information

Online CEU Certificate
  • Document Your Lifelong Learning Achievements
  • Earn an Official Certificate Documenting Course Hours and CEUs
  • Verify Your Certificate with a Unique Serial Number Online
  • View and Share Your Certificate Online or Download/Print as PDF
  • Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media
Document Your CEUs on Your Resume
 
Course Title: Microsoft Access 2010
Course Number: 8900072
Lessons Rating: 4.1 / 5 Stars (1,664 votes)
Languages: English - United States, Canada and other English speaking countries
Availability: This course is online and available in all 50 states including: California, Florida, Georgia, Illinois, New York, Pennsylvania, Ohio, Texas, and Washington.
Last Updated: June 2022
Course Type: Self-Paced, Online Class
CEU Value: 1.5 IACET CEUs (Continuing Education Units)
CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).
Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.
Assessment Method: Lesson assignments and review exams
Instructor: Dave Scarbrough
Syllabus: View Syllabus
Course Fee: $95.00 U.S. dollars

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$70
for 6 months
 
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
$95
for 6 months
 
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
ALL COURSES
Certificates & CEUs
$189
per year
 
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 600+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $79.00!
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 24 Months
No. of courses 600+