Online Class: Microsoft Access 2013

This course will teach you everything you need to know to successfully use Microsoft Access 2013, even if you have never used a database before.

$95.00
no certificate
- OR -
$120.00
with CEU Certificate*
Start Right Now!
$120.00 (with CEU Certificate)
Taking multiple courses? Save with our platinum program.
 
  • 21
    Lessons
  • 23
    Exams &
    Assignments
  • 2,792
    Students
    have taken this course
  • 10
    Hours
    average time
  • 1.0
    CEUs
 
 
 

Course Description

Microsoft Access 2013 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 2013 and how to use them. This course is designed for beginners so that even if you've never so much as opened the program before, you can learn how to use it like a pro. Once we cover the basics, we'll move on to advanced features. If you've used Access before, perhaps previous 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 2013, 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 2013 is just as easy for the beginner to use as it is someone who's been using it for years. With step-by-step written directions, screenshots of every procedure, and HD Video tutorials, you'll have no problems learning this program! 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. So join us today!

  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video  
  • 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.3 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(1,080 votes)

Lesson 1: Introduction to Microsoft Access 2013

7 Points
Microsoft Access is an information management tool that allows you to store, report, and analyze information.
  • Lesson 1 Video
  • Lesson discussions: Reasons for Taking this Course
  • Complete Assignment: Motives for Taking this Course
  • Assessment: Lesson 1 Exam

Lesson 2: Access 2013 Requirements and Setup

5 Points
Access 2013 Requirements and Setup
  • Lesson 2 Video
  • Assessment: Lesson 2 Exam

Lesson 3: About Databases and Design

5 Points
About Databases and Design
  • Lesson 3 Video
  • Assessment: Lesson 3 Exam

Lesson 4: Access 2013 Database Objects

5 Points
Access 2013 Database Objects
  • Lesson 4 Video
  • Assessment: Lesson 4 Exam

Lesson 5: Navigating MS Access 2013

5 Points
Navigating MS Access 2013
  • Lesson 5 Video
  • Assessment: Lesson 5 Exam

Lesson 6: Creating a Database and Adding Tables

6 Points
Creating a Database and Adding Tables
  • Lesson 6 Video
  • Assessment: Lesson 6 Exam

Lesson 7: Object Views

5 Points
Object Views
  • Lesson 7 Video
  • Assessment: Lesson 7 Exam

Lesson 8: Creating Simple Forms

5 Points
Creating Simple Forms
  • Lesson 8 Video
  • Assessment: Lesson 8 Exam

Lesson 9: Introduction to Controls and Formatting Forms

5 Points
Introduction to Controls and Formatting Forms
  • Lesson 9 Video
  • Assessment: Lesson 9 Exam

Lesson 10: Queries

8 Points
Understanding Queries
  • Lesson 10 Video
  • Assessment: Lesson 10 Exam

Lesson 11: Using Criteria, Operators, and Wildcards

5 Points
Using Criteria, Operators, and Wildcards
  • Lesson 11 Video
  • Assessment: Lesson 11 Exam

Lesson 12: Parameter Queries

3 Points
Parameter Queries
  • Lesson 12 Video
  • Assessment: Lesson 12 Exam

Lesson 13: Relationships

5 Points
Relationships
  • Lesson 13 Video
  • Assessment: Lesson 13 Exam

Lesson 14: Normalization

5 Points
Normalization
  • Lesson 14 Video
  • Assessment: Lesson 14 Exam

Lesson 15: Creating Calculated Expressions

5 Points
Creating Calculated Expressions
  • Lesson 15 Video
  • Assessment: Lesson 15 Exam

Lesson 16: Summarizing Data

3 Points
Summarizing Data
  • Lesson 16 Video
  • Assessment: Lesson 16 Exam

Lesson 17: Reports

4 Points
Creating reports using the report tool
  • Lesson 17 Video
  • Assessment: Lesson 17 Exam

Lesson 18: Designing Your Report

5 Points
Once you have your report created, you can now modify it to create a more attractive design for it.
  • Lesson 18 Video
  • Assessment: Lesson 18 Exam

Lesson 19: Advanced Formatting for Reports

3 Points
Advanced Formatting for Reports
  • Lesson 19 Video
  • Assessment: Lesson 19 Exam

Lesson 20: Printing and Exporting Reports

6 Points
There are many new ways to print and export reports in Access 2013. In this lesson, we will both introduce and show you how to do them.
  • Lesson 20 Video
  • Assessment: Lesson 20 Exam

Lesson 21: Importing and Exporting Data

79 Points
In this lesson, we're going to learn the multiple ways that you can import and export data to and from Access.
  • Lesson 21 Video
  • Lesson discussions: What do you think about this course?; Program Evaluation Follow-up Survey (End of Course); Course Comments
  • Assessment: Lesson 21 Exam
  • Assessment: Final Exam
179
Total Course Points
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Describe databases and design.
  • Identify database objects.
  • Demonstrate navigating, creating a database, and adding tables in Access 2013.
  • Describe object views.
  • Demonstrate creating simple forms.
  • Demonstrate using controls and formatting forms.
  • Demonstrate creating queries and using criteria, operators and wildcards in Access 2013
  • Demonstrate creating and using parameter queries.
  • Describe relationships.
  • Describe normalization.
  • Demonstrate creating calculated expressions.
  • Demonstrate summarizing data and creating reports.
  • Demonstrate printing and exporting reports.
  • Summarize importing and exporting data in Access 2013.
  • 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 2013
Course Number: 8900311
Lessons Rating: 4.3 / 5 Stars (1,080 votes)
Languages: English - United States, Canada and other English speaking countries
Availability: Available across all 50 U.S. states, this course includes key regions such as California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. The course is also open in major English-speaking countries, including Australia, Canada, the UK, and Ireland.
Last Updated: July 2023
Course Type: Self-Paced, Online Class
CEU Value: 1.0 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
Syllabus: View Syllabus
Course Fee: $120.00 U.S. dollars

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$95
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
$120
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+
 

Student Testimonials

  • "What was most helpful was setting up tables and linking them in Queries and reports." -- Tony W.
  • "What was most helpful was the part on creating reports and forms. As a beginner, it was quite easy to follow along with the steps." -- Dionne K.