Ultimate Microsoft Access 2016 Course - Beginner to Expert

The Most Convenient Way to Boost Your Confidence And Learn MS Access 2016 Inside and Out—Quickly, No Travel or Classes.
Instructed by: Simon Sez IT | Subject: Office Productivity, Microsoft

Description

Through 118 lectures, 18 hours of quality content, and quizzes, this 18-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Budding Access 2016 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence. Exercise files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application. This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills. Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately.

Outcome

1. Practice what you learned with included exercise files
2. Sorting information and running queries
3. Creating tables and relationships
4. Navigating the Access 2016 interface
5. Design forms and generate reports
6. Learn valuable new skills for complex data projects at work
7. Supercharge your database projects
8. Discover how to into import data from Excel
9. Learn Queries, use validations, how to create and print reports
10. How to compact, repair and backup your database
11. How to create a linked table
12. Discover how to use the Query Wizard
13. Learn to use Model Dialog and Macros
14. Discover how to effectively link to other data sources.
15. Learn how to split a database by splitting the frontend and backend.
16. Explore the use of Visual Basic for Applications (VBA).
17. Discover advanced options for the use of forms.
18. Dive into options for packaging your application for distribution.
19. Practice with included Access 2016 exercises files.
20. Follow along with the instructor with included instructor demostration files.
21. Follow along as you learn to create and maintain macros.
22. Complete database projects at the advanced level.
23. Get helpful techniques that allow you to link, report, and package your data quickly.

Take This Course

Notify me when course available for FREE

Course Info

• 125 Lectures
• 20.5 Hours
• Language: English
• Subject: Office Productivity, Microsoft
• Instructed by: Simon Sez IT
• Last updated on August 2017
• Platform: Udemy