Universal Class: Over 500 Online Certificate Courses

Course Syllabus: Microsoft Access 2010

Microsoft Training Picture
no certificate
- OR -
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.

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.

Course Requirements


This course will not require you to have previous experience in any particular area but you should have the following:

- Microsoft Access 2010 (recommended)
- a high school reading level.

No books will be required.

This course will be much more effective if you actually have Microsoft Access 2010 installed on your computer and can get hands on experience with it.  If you do not have it you may wish to consider purchasing it on sites such as Amazon or Ebay.   Microsoft Office Professional 2010 will include Access 2010 of course.

If you do not have Microsoft Office 2010 and do not wish to purchase it you can also use public use computers at your local public library, which will likely have it or a similar version.   Please note that if your local public library uses a different version than the 2010 version then there will be some differences.

Course Topics


Lesson 1: Microsoft Access 2010 Introduction

Lesson 2: Access 2010 Requirements and Setup

Lesson 3: About Databases and Normalization

Lesson 4: Access 2010 Database Objects

Lesson 5: Navigating MS Access 2010

Lesson 6: Creating a Database and Adding Tables

Lesson 7: Object Views

Lesson 8: Creating Simple Forms

Lesson 9: Introduction to Controls and Formatting Forms

Lesson 10: Queries

Lesson 11: Using Criteria, Operators, and Wildcards

Lesson 12: Parameter Queries

Lesson 13: Relationships and Joins

Lesson 14: Creating Calculated Expressions

Lesson 15: Summarizing Data

Lesson 16: PivotTables

Lesson 17: PivotCharts

Lesson 18: Reports

Lesson 19: Designing Your Report

Lesson 20: Advanced Formatting for Reports

Lesson 21: Macros

Lesson 22: Printing and Exporting Reports

Lesson 23: Importing and Exporting Data

Course Materials

All course material will be provided in the lessons and netlinks. .

Grading Policy

Each lesson will include a lesson review quiz along with one or two assignments. Students will successfully complete this course by mastering all learning outcomes with 70% or higher overall grade.

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.
  • Know database objects.
  • Demonstrate navigatipm
  • Demonstrate creating a database and adding tables.
  • Know object views.
  • Demonstrate creating simple forms.
  • Know 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.
  • Know importing and exporting data, and
  • Demonstrate mastery of lesson content at levels of 70% or higher.
Show More

Assessment Guide

Lesson 1 Exam6
Lesson 2 Exam10
Lesson 3 Exam10
Lesson 1 - 4 Assignment25
Lesson 4 Exam10
Lesson 5 Navigating Access25
Lesson 5 Exam10
Lesson 6 Assignment25
Lesson 6 Exam8
Lesson 7 Exam9
Lesson 8 Assignment25
Lesson 8 Exam9
Lesson 9 Assignment25
Lesson 9 Exam10
Lesson 10 Assignment25
Lesson 10 Exam9
Lesson 11 Exam9
Lesson 12 Assignment25
Lesson 12 Exam10
Lesson 13 Assignment25
Lesson 13 Exam9
Lesson 14 Assignment25
Lesson 14 Exam10
Lesson 15 Exam10
Lesson 16 Exam10
Lesson 17 Exam10
Lesson 18 Assignment25
Lesson 18 Exam10
Lesson 19 Exam8
Lesson 20 Exam10
Lesson 21 Exam10
Lesson 22 Exam9
Lesson 23 Assignment25
Lesson 23 Exam8
The Final Exam97
Total Points:586
Show More

Related Articles

Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2018 Universal Class™ All rights reserved.