Online Class: Microsoft Access 2013
We're sorry, this course is no longer open for enrollment.
-
21Lessons
-
23Exams &
Assignments -
10Hours
average time -
1.0CEUs
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
Course Lessons
Lesson 1: Introduction to Microsoft Access 2013
- 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
- Lesson 2 Video
- Assessment: Lesson 2 Exam
Lesson 3: About Databases and Design
- Lesson 3 Video
- Assessment: Lesson 3 Exam
Lesson 4: Access 2013 Database Objects
- Lesson 4 Video
- Assessment: Lesson 4 Exam
Lesson 5: Navigating MS Access 2013
- Lesson 5 Video
- Assessment: Lesson 5 Exam
Lesson 6: Creating a Database and Adding Tables
- Lesson 6 Video
- Assessment: Lesson 6 Exam
Lesson 7: Object Views
- Lesson 7 Video
- Assessment: Lesson 7 Exam
Lesson 8: Creating Simple Forms
- Lesson 8 Video
- Assessment: Lesson 8 Exam
Lesson 9: Introduction to Controls and Formatting Forms
- Lesson 9 Video
- Assessment: Lesson 9 Exam
Lesson 10: Queries
- Lesson 10 Video
- Assessment: Lesson 10 Exam
Lesson 11: Using Criteria, Operators, and Wildcards
- Lesson 11 Video
- Assessment: Lesson 11 Exam
Lesson 12: Parameter Queries
- Lesson 12 Video
- Assessment: Lesson 12 Exam
Lesson 13: Relationships
- Lesson 13 Video
- Assessment: Lesson 13 Exam
Lesson 14: Normalization
- Lesson 14 Video
- Assessment: Lesson 14 Exam
Lesson 15: Creating Calculated Expressions
- Lesson 15 Video
- Assessment: Lesson 15 Exam
Lesson 16: Summarizing Data
- Lesson 16 Video
- Assessment: Lesson 16 Exam
Lesson 17: Reports
- Lesson 17 Video
- Assessment: Lesson 17 Exam
Lesson 18: Designing Your Report
- Lesson 18 Video
- Assessment: Lesson 18 Exam
Lesson 19: Advanced Formatting for Reports
- Lesson 19 Video
- Assessment: Lesson 19 Exam
Lesson 20: Printing and Exporting Reports
- Lesson 20 Video
- Assessment: Lesson 20 Exam
Lesson 21: Importing and Exporting Data
- Lesson 21 Video
- Lesson discussions: What do you think about this course?; Program Evaluation Follow-up Survey (End of Course)
- Assessment: Lesson 21 Exam
- Assessment: Final Exam
Learning Outcomes
- 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.
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.
Related Courses
- 26 hours 2.6 CEUs Ultimate Excel Training Bundle + More Info
- 14 hours 1.4 CEUs QuickBooks 101 + More Info
- 8 hours 0.8 CEUs Adobe Premiere 101 + More Info
- 14 hours 1.4 CEUs QuickBooks Online + More Info
- 8 hours 0.8 CEUs Adobe InDesign 101 + More Info
- 5 hours 0.5 CEUs Adobe Muse 101 + More Info
- 12 hours 1.2 CEUs Adobe After Effects + More Info
- 7 hours 0.7 CEUs Microsoft Word Level 1 + More Info
- 7 hours 0.7 CEUs Final Cut Pro X + More Info
- 5 hours 0.5 CEUs SalesForce 101 + More Info
- 12 hours 1.2 CEUs Adobe Photoshop + More Info
- 4 hours 0.4 CEUs Slack + More Info
- 8 hours 0.8 CEUs Microsoft PowerPoint Level 1 + More Info
- 6 hours 0.6 CEUs Microsoft Publisher Level 1 + More Info
- 7 hours 0.7 CEUs Google Slides + More Info
- 20 hours 2.0 CEUs Photoshop Elements 101 + More Info
- 7 hours 0.7 CEUs Google Sheets + More Info
- 6 hours 0.6 CEUs Google Docs + More Info
- 8 hours 0.8 CEUs Adobe Lightroom 101 + More Info
- 7 hours 0.7 CEUs Microsoft Visio Level 1 + More Info
- 9 hours 0.9 CEUs Microsoft Project Level 1 + More Info
- 6 hours 0.6 CEUs Adobe Captivate + More Info
- 7 hours 0.7 CEUs Microsoft Excel Level 3 + More Info
- 13 hours 1.3 CEUs Adobe Illustrator 101 + More Info