Last updated 2/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.44 GB | Duration: 9h 7m
The ultimate next step for anyone interested in supercharging their Microsoft Access and data analysis skills
What you'll learn
Discover how to effectively link to other data sources.
Learn how to split a database by splitting the frontend and backend.
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 with included Access 2016 exercises files.
Follow along with the instructor with included instructor demostration files.
Discover advanced options and tips for building and using queries.
Follow along as you learn to create and maintain macros.
Complete database projects at the advanced level.
Get helpful techniques that allow you to link, report, and package your data quickly.
Requirements
A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases.
Microsoft Access 2016
Description
Become a Microsoft Access database expert with this easy-to-follow course featuring 8 hours of professionally produced videos. Exercise and demo files included.
Practice what you learn with included exercise files.
A full 8 hours of professional video instruction.
48 easy-to-follow how-to videos.
Everything explained step-by-step for quick comprehension.
Complete database projects at the advanced level.
The next step after completing Microsoft Access 2016 for Beginners.
Enables you to complete projects on time and within budget.
Increase your value at work.
Starts with basic advanced features.
Discover how to effectively link to other data sources.
Learn how to split a database by splitting the frontend and backend.
Follow along as you learn to create and maintain macros.
Explore the use of Visual Basic for Applications (VBA).
Discover advanced options for the use of forms and queries.
Dive into options for packaging your application for distribution.
Practice with bonus Access 2016 exercises.
In today's data-driven world, effective data management is crucial, with no room for error. If you've already taken our beginner Microsoft Access 2016 course, or have a beginner knowledge of Microsoft Access 2016, you're ready for our Microsoft Access 2016 Advanced course. Get ready to become a data management expert as this 8-hour class takes your skills to the next level.
You'll boost your knowledge significantly as you get acquainted with Microsoft Access 2016's most sophisticated features.
Contents and Overview
Your Microsoft certified professional trainer will show you how to use macros, advanced forms and queries, and other tools to create a professional, working database. Follow along as you learn to create and maintain macros, then see how to effectively link to other data sources.
Get helpful techniques that allow you to link, report, and package your data quickly, and discover how to split a database by splitting the frontend and backend.
With this informative course, you'll learn the skills you need to make an impact with sleek, high-performing databases that help you do your job efficiently and competently.
Plus, when you sign up for this course, you'll also get these extras:
Exercise files - to help you become proficient with the material.
Instructor demo files - use the same database files used by your instructor.
An optional online quiz (45 questions) - to test what you've learned.
A certificate of completion - to tell everyone you've aced the course.
If you're ready to master Microsoft Access 2016 and sign up for the course, go ahead and hit that Enroll button, or try some of the free videos by using the Free Preview feature. We look forward to seeing you in the course!
Here's what our students are saying."Instructor is really knowledgeable. The course is indeed advanced access and covers a lot of topics. By definition none of them in depth, but it's all about giving us the bearing points to pursue our own learning with the 3 key p's: practice, practice and practice! Totally recommended."- Moises Redondo "Very descriptive/informative and easy to follow steps. Love the accent."*- Brenda Bachtold"Well prepared and clearly presented by arguably the best instructor on Udemy." - Bill Dam Did 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.
Overview
Section 1: Introduction to Microsoft Access 2016 Advanced
Lecture 1 Course Overview and Content
Lecture 2 WATCH ME: Essential Information for a Successful Training Experience
Lecture 3 DOWNLOAD ME: Course Exercise Files
Lecture 4 DOWNLOAD ME: Course Demo Files
Section 2: Primary Keys and Indexes
Lecture 5 Primary Keys and Indexing Rules and Guidelines
Lecture 6 More About Indexes
Section 3: Using Datasheet View
Lecture 7 Setting-up Northwind Database
Lecture 8 Working in a Datasheet View
Lecture 9 Customizing Datasheet View and Advanced Sorting and Filtering
Lecture 10 Subdatasheets
Lecture 11 Exercise 01
Section 4: Linking to Other Access Databases
Lecture 12 Linking Two Tables to Other Access Databases
Section 5: Using ODBC and SQL Server
Lecture 13 Acquiring and Installing SQL Server Express
Lecture 14 Setting up SQL Server Database
Lecture 15 Exercise 2
Section 6: Splitting An Access Database
Lecture 16 Splitting an Access Database into Front-end and Back-end Databases
Lecture 17 Converting Shared Table into Local Table; Moving Back-end Database
Lecture 18 Exercise 3
Lecture 19 Addressing Multi-users Issues When Sharing Data
Section 7: Macros
Lecture 20 Basics of Macros
Lecture 21 Macros on Events; AutoExec
Lecture 22 More About AutoExec; Bypassing AutoExec
Lecture 23 Macro Security Settings
Lecture 24 Exercise 4
Section 8: The Ribbon
Lecture 25 Customizing the Ribbon and Quick Access Tool
Section 9: Visual Basic for Applications in Access 2016
Lecture 26 Convert Macros to VBA; VBA Editor and Property Windows
Lecture 27 VBA Modules; Running Code and Error Handling
Lecture 28 Creating Modules; Subs, Functions, Intellisense and Variables
Lecture 29 Scope, Variable Naming and Strings
Lecture 30 Standard Functions; Logical, Case and Loop Statements
Section 10: Access Events Model
Lecture 31 Adding Events to Assets Database
Lecture 32 Exercise 05
Lecture 33 Common Events; Form and Report Events
Lecture 34 Switchboard and Navigation Form; Error Handling
Lecture 35 Exercise 06
Section 11: Forms
Lecture 36 Formatting Bound and Control Form
Lecture 37 Split Forms; Macro Error Handling
Lecture 38 Creating Form with Tab
Lecture 39 Go To Combo Box and Its Properties
Lecture 40 Exercise 07
Section 12: Advanced Use of Queries
Lecture 41 Basic of Queries: Review
Lecture 42 Syntax of SQL Statements
Lecture 43 Use of Multiple Where Criteria & Select Statements Function
Lecture 44 Joins and Its Types
Lecture 45 Exercise 08
Lecture 46 Action Queries - Part 1
Lecture 47 Action Queries - Part 2
Lecture 48 Subqueries
Section 13: Packaging Your Application
Lecture 49 Steps in Packaging Access Application
Lecture 50 Exercise 09
Section 14: Conclusion
Lecture 51 Online Support and Conclusion
Section 15: Extras
Lecture 52 EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic
Experienced database managers or those who are familiar with Access 2016 or 2013
Homepage
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
