Master Microsoft Access 2013 & 2016 for Beginners
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English (UK) | Size: 17.12 GB | Duration: 31h 15m
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English (UK) | Size: 17.12 GB | Duration: 31h 15m
Everything you need to know to fully understand MS Access 2013 & 2016. 28 hours of helpful professional training.
What you'll learn
Using touch devices
Sorting information and running queries
Safeguards and restrictions
Creating tables and relationships
Navigating the Access Interface
Designing forms
How to use queries
Generating reports
Discover how to effectively link to other data sources.
Learn how to split a database by splitting the frontend and backend
Find out about the use of macros
Explore the use of Visual Basic for Applications (VBA)
Discover advanced options for the use of forms
Dive into options for packaging your application for distribution
Practice what you learned with included exercise files
Sorting information and running queries
Learn valuable new skills for complex data projects at work
Supercharge your database projects
Discover how to into import data from Excel
Learn Queries, use validations, how to create and print reports
How to compact, repair and backup your database
How to create a linked table
Discover how to use the Query Wizard
Learn to use Model Dialog and Macros
Requirements
Microsoft Access 2013 or Microsoft Access 2016
Description
Become a super star Access 2013 & 2016 user everyone relies on with this big 29-hour course with 3 courses, over 160 video tutorials.
Starts from the very beginning
No Microsoft Access experience needed
3 courses for learning Microsoft Access160+ expertly produced videos
A full 28 hours of instruction
Makes all aspects of Access easy to master
Covers exciting features new for 2013 & 2016
Learn to use full program, not just basics
Get up and running quickly
Immediately learn things you can use at work
Supercharge your personal projects
Become the MS Access expert everyone appreciates
Work at your own pace in your spare timePractice what you learned with included exercise files
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 coursesThrough 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.Here’s what our students are saying…“As someone who has no experience I am finding this course very easy to understand and follow. Great pace and the modules don't overwhelm you. So glad I purchased this.”- Sharon Knight“Highly recommended this course to everyone.This is the best course i ever had.Good English that we can understand. Suberb…..I understood every lesson in the course.- Yunesh Garusinghe“Outstanding course! I will use the as a reference for years to come. I am 100% satisfied.- Larry ReidDid you know?Simon Sez IT teaches all sorts of software, including:- Microsoft Excel- Microsoft PowerPoint- Microsoft Word- Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements- Web Development Languages- And so much more!Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.
Who this course is for:
Anyone new to Microsoft Access, Users new to Microsoft Access 2013 or 2016 and those upgrading from previous software versions, Anyone new to the data management role, Anyone who wants to learn data management and Microsoft Access