31 hours
Any Level
Available
Simon Sez IT
Everything you need to know to fully understand MS Access 2013 & 2016. 28 hours of helpful professional training.
Become a super star Access 2013 & 2016 user everyone relies on with this big 29-hour course with 3 courses, over 160 video tutorials.
Learn to Capture and Synthesize Information, Becoming a Data Management Guru.
Being a data rock star is more important than ever. To stand out in the workplace, it's essential to be able to find information fast and to identify game-changing insights.
The Microsoft Access database can help you store and track a variety of information, such as inventory, contacts, or business processes. Logistically, it combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools, and is a member of the Microsoft Office suite of applications, included in the Professional and higher editions, or sold separately.
It is a tool that spans across many fields and is helpful to anyone needing to tightly organize varied data: office managers, project managers, executive assistants, scientists, and busy families to list a few.
Contents and Overview for the Access 2013 beginner and advanced courses
Through 96 lectures, 19 hours of quality content, this training 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 2013 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.
Practice 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.
Contents and Overview for the Access 2016 beginner course
Microsoft Access 2016 For Beginners starts at the very beginning show you where to get your copy of MS Access and how to install it on your computer. Before we go further, you get a quick tour of all the new features and improvements in 2016.
You will learn how to easily get started with database templates that make the entire process faster. Then you see how to create, save, and open databases.
After a tour of Access Workspace and Backstage, you see a complete explanation of the toolbars and ribbons. Next you get a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency.
Now it's time to create your own working database. Videos step you through the process helping you master details while understanding the big picture.
Later the course goes into importing data from Excel, creating and working with forms, and lots of great information on sub-forms. As you become more advanced, you learn Queries, using Validations, how to create Reports, and Printing your projects.
This course contains a big 10 Chapters with multiple videos in each chapter for a total of 70 videos. Get started with this course now to easily become expert at MS Access 2016.
Lore delivers value at the intersection of learning, interests and skills.
Access learning options recommended by industry experts, professionals and thought leaders.
Quickly search, select and add learning options to your learning list.
Tell us more about yourself to access the latest learning options, curated just for you.