The Most Convenient Way to Boost Your Confidence And Learn MS Access 2013 Inside And Out—Quickly, No Travel or Classes.
What you'll learn:
Sorting information and running queries
Practice with exercise files that are included with both courses
Safeguards and restrictions
Creating tables and relationships
Navigating the Access 2013 interface
How to use queries
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
Get An Advanced Understanding of the Many Access 2013 Features That Will Enable You to Gather and Interpret Data Faster.
Sorting Information and Running Queries
Creating Tables and Relationships
Designing Forms (+ Advanced Form Options)
Splitting the Frontend and Backend
Visual Basic for Applications (VBA)
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 2013 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
Through 96 lectures, 19 hours of quality content, and 2 quizzes, this 19-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 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.
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.
** Updated June 2017. Course transcripts now available.