"Good source to start learning Access.
I acquired basic knowledge and learned to apply the skill in a practical manner.
"Thank you, Computer Mama!" GL., UDEMY
Microsoft Access 2013 Beginning
Another Computer Mama Guide: www.thecomputermama.com
Beginning Guide to Microsoft Access 2013. If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need: Step-by-step video demonstrations, Companion eBook with detailed instructions, Sample databases, Practice, Quizzes and Skill Test.
All materials for this program are available online. The following resources are available to download throughout the lessons:
- Beginning Guide to Microsoft® Access 2013 (PDF)
- Microsoft Access 2013 Beginning Sample files
In Microsoft Access, you’ll cover basic through advanced topics, including:
- Learn how to navigate the online course and submit your assignments
- Understand the purpose of Tables and how they are used in a database
- Edit the Form Properties to help Users navigate the Form Fields and enter data
- Learn how to design Queries and use Queries to lookup records in the Tables
- Use Query Criteria and Parameter Queries to select specific records in the Tables
- Learn how to design and modify Reports in Layout and Design Views
- Learn how to manage Database files: Save and Save As
A student who wishes to take Microsoft Access should be comfortable working with files and saving different versions of their work. In terms of Microsoft Excel, students should have some experience creating formulas. Microsoft Access and Excel use similar formulas to calculate dates (DateDiff), Logical functions (IIF), and financials (SUM, COUNT, AVERAGE, MAX and MIN.)
Who Can Benefit From This Course: You!
This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately. This program is also suitable for you if you are looking to learn about this software and expand your job possibilities.
Microsoft Office Specialist Certification
Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics.
This course teaches the objectives for the following certification tests:
Access® 2013: Exam 77-424
Elizabeth earned a BA in Biology from the University of Michigan.