Online Class: Microsoft Access 2010
no certificate
with CEU Certificate*
-
23Lessons
-
35Exams &
Assignments -
15Hours
average time -
1.5CEUs
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
Course Lessons
Lesson 1: Microsoft Access 2010 Introduction
- Lesson discussions: Access 2010; Reasons for Taking this Course
- Assessment: Lesson 1 Exam
Lesson 2: Access 2010 Requirements and Setup
- Assessment: Lesson 2 Exam
Lesson 3: About Databases and Normalization
- Assessment: Lesson 3 Exam
Lesson 4: Access 2010 Database Objects
- Complete: Lesson 1 - 4 Assignment
- Assessment: Lesson 4 Exam
Lesson 5: Navigating MS Access 2010
- Complete Assignment: Lesson 5 Navigating Access
- Assessment: Lesson 5 Exam
Lesson 6: Creating a Database and Adding Tables
- Complete: Lesson 6 Assignment
- Assessment: Lesson 6 Exam
Lesson 7: Object Views
- Assessment: Lesson 7 Exam
Lesson 8: Creating Simple Forms
- Lesson discussions: Using Access 2010
- Complete: Lesson 8 Assignment
- Assessment: Lesson 8 Exam
Lesson 9: Introduction to Controls and Formatting Forms
- Complete: Lesson 9 Assignment
- Assessment: Lesson 9 Exam
Lesson 10: Queries
- Complete: Lesson 10 Assignment
- Assessment: Lesson 10 Exam
Lesson 11: Using Criteria, Operators, and Wildcards
- Assessment: Lesson 11 Exam
Lesson 12: Parameter Queries
- Complete: Lesson 12 Assignment
- Assessment: Lesson 12 Exam
Lesson 13: Relationships and Joins
- Complete: Lesson 13 Assignment
- Assessment: Lesson 13 Exam
Lesson 14: Creating Calculated Expressions
- Complete: Lesson 14 Assignment
- Assessment: Lesson 14 Exam
Lesson 15: Summarizing Data
- Assessment: Lesson 15 Exam
Lesson 16: PivotTables
- Assessment: Lesson 16 Exam
Lesson 17: PivotCharts
- Assessment: Lesson 17 Exam
Lesson 18: Reports
- Complete: Lesson 18 Assignment
- Assessment: Lesson 18 Exam
Lesson 19: Designing Your Report
- Assessment: Lesson 19 Exam
Lesson 20: Advanced Formatting for Reports
- Assessment: Lesson 20 Exam
Lesson 21: Macros
- Assessment: Lesson 21 Exam
Lesson 22: Printing and Exporting Reports
- Assessment: Lesson 22 Exam
Lesson 23: Importing and Exporting Data
- 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
Learning Outcomes
- 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
- 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
Choose Your Subscription Plan
No Certificate / No CEUs
This course only
Includes certificate | X |
Includes CEUs | X |
Self-paced | |
Instructor support | |
Time to complete | 6 months |
No. of courses | 1 course |
Certificate & CEUs
This course only
Includes certificate | |
Includes CEUs | |
Self-paced | |
Instructor support | |
Time to complete | 6 months |
No. of courses | 1 course |
Certificates & CEUs
Includes all 600+ courses
Includes certificate | |
Includes CEUs | |
Self-paced | |
Instructor support | |
Time to complete | 12 Months |
No. of courses | 600+ |
Certificates & CEUs
Includes all 600+ courses
Includes certificate | |
Includes CEUs | |
Self-paced | |
Instructor support | |
Time to complete | 24 Months |
No. of courses | 600+ |
Related Courses
- 32 hours 3.2 CEUs Microsoft Office: Word, Excel, PowerPoint and Outlook + More Info
- 26 hours 2.6 CEUs Ultimate Excel Training Bundle + More Info
- 8 hours 0.8 CEUs Adobe InDesign 101 + More Info
- 7 hours 0.7 CEUs Microsoft Excel Level 3 + More Info
- 14 hours 1.4 CEUs QuickBooks Online + More Info
- 7 hours 0.7 CEUs Microsoft Word Level 1 + More Info
- 12 hours 1.2 CEUs Adobe Photoshop + More Info
- 8 hours 0.8 CEUs Adobe Premiere 101 + More Info
- 9 hours 0.9 CEUs Microsoft Project Level 1 + More Info
- 12 hours 1.2 CEUs Adobe After Effects + More Info
- 6 hours 0.6 CEUs Microsoft Publisher Level 1 + More Info
- 6 hours 0.6 CEUs Adobe Captivate + More Info
- 5 hours 0.5 CEUs Microsoft Outlook Level 1 + More Info
- 20 hours 2.0 CEUs Photoshop Elements 101 + More Info
- 8 hours 0.8 CEUs Adobe Lightroom 101 + More Info
- 8 hours 0.8 CEUs Microsoft PowerPoint Level 1 + More Info
- 7 hours 0.7 CEUs Final Cut Pro X + More Info
- 6 hours 0.6 CEUs Google Docs + More Info
- 7 hours 0.7 CEUs Google Sheets + More Info
- 7 hours 0.7 CEUs Google Slides + More Info
- 13 hours 1.3 CEUs Adobe Illustrator 101 + More Info