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
 

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.
 
 

Assessment Guide

Assessment Points
Lesson 1 Exam 6 points
Lesson 2 Exam 10 points
Lesson 3 Exam 10 points
Lesson 1 - 4 Assignment 25 points
Lesson 4 Exam 10 points
Lesson 5 Navigating Access 25 points
Lesson 5 Exam 10 points
Lesson 6 Assignment 25 points
Lesson 6 Exam 8 points
Lesson 7 Exam 9 points
Lesson 8 Assignment 25 points
Lesson 8 Exam 9 points
Lesson 9 Assignment 25 points
Lesson 9 Exam 10 points
Lesson 10 Assignment 25 points
Lesson 10 Exam 9 points
Lesson 11 Exam 9 points
Lesson 12 Assignment 25 points
Lesson 12 Exam 10 points
Lesson 13 Assignment 25 points
Lesson 13 Exam 9 points
Lesson 14 Assignment 25 points
Lesson 14 Exam 10 points
Lesson 15 Exam 10 points
Lesson 16 Exam 10 points
Lesson 17 Exam 10 points
Lesson 18 Assignment 25 points
Lesson 18 Exam 10 points
Lesson 19 Exam 8 points
Lesson 20 Exam 10 points
Lesson 21 Exam 10 points
Lesson 22 Exam 9 points
Lesson 23 Assignment 25 points
Lesson 23 Exam 8 points
The Final Exam 97 points
Adobe Premiere: How to Create Sequences
Adobe Premiere: How to Create Sequences
Operations Management Courses
Operations Management Courses
Get Started with Adobe Photoshop
Get Started with Adobe Photoshop
Microsoft Project Level 1
Microsoft Project Level 1
Microsoft Office: Word, Excel, PowerPoint and Outlook
Microsoft Office: Word, Excel, PowerPoint and Outlook
Microsoft PowerPoint Level 1
Microsoft PowerPoint Level 1
QuickBooks Courses
QuickBooks Courses
How to Organize Images in Adobe Photoshop Lightroom
How to Organize Images in Adobe Photoshop Lightroom
Adobe Premiere: Organizing Your Media in the Project Panel
Adobe Premiere: Organizing Your Media in the Project Panel
Microsoft Excel Courses
Microsoft Excel Courses
Business Writing Courses
Business Writing Courses
How to Manage Bank Accounts and Credit Cards in QuickBooks Online
How to Manage Bank Accounts and Credit Cards in QuickBooks Online
Getting Started with Adobe InDesign
Getting Started with Adobe InDesign
Communications Courses
Communications Courses
Microsoft Excel Level 3
Microsoft Excel Level 3
Google Docs
Google Docs
Microsoft Word Courses
Microsoft Word Courses
Ultimate Excel Training Bundle
Ultimate Excel Training Bundle