Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
In this day and age, data management is absolutely crucial, and there’s not much room for error. If you’ve already taken our basic Microsoft Access 2013 course, or know your way around the program already, you’re ready for our Microsoft Access 2013 Advanced course. Get ready to become a data management expert as this 9.25 hour class takes your skills to the next level.
In the Microsoft Access 2013 Advanced video training course, you’ll take your knowledge up a notch as you get acquainted with Microsoft Access 2013’s most sophisticated features. If you think you know all you need to know about Access 2013, think again, as this course goes way beyond the basics, leaving you with knowledge of all of the best Access tips and tricks out there.
Your professional trainer will show you how to use macros, tables, forms, 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 find out 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 better.
Plus, when you sign up for our class, you’ll also get these 4 BONUSES:
Where else can you find so many extra tools to help you master Access 2013?
What people are saying:
"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."
Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Prerequisites and Basic Knowledge of Access 2013Preview
IMPORTANT - Read this to ensure the best video quality!
Course exercise files
Access 2013 keyboard shortcuts
|Section 2: Indexes|
Indexes and Introduction to the Movies DatabasePreview
|Section 3: Datasheet View|
Basics in Working with Datasheet ViewPreview
Controlling the Display and Advanced Sorting and Filtering in Datasheet View
|Section 4: Linking Access Databases|
Linking to Other Access Database Tables
|Section 5: Chapter 5: ODBC and SQL Server|
How to Install SQL Server Express
Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
|Section 6: Splitting an Access Database|
Reasons to Split a Database; Splitting a Database to a Front-end and a Back-endPreview
Consequences of the Split; Moving a Database; Adding a Trusted Location
|Section 7: Multi-user Aspects|
Access Options relating to Multi-user Issues; Record Locking
|Section 8: Macros|
Basics of Macros and Properties of Macro EditorPreview
Examples of Macros; Autoexec
|Section 9: The Ribbon|
Customizing the Quick Access Toolbar and the Ribbon
|Section 10: Visual Basic for Applications|
Convert Macro to VBA; VBA EditorPreview
Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes
Modules, Subs, Options Explicit, and Variables
Scope of Variables
Branch and Loop
|Section 11: Events|
Responding to Events and Developing Error Handles
More on Events
Getting Help with Events
|Section 12: Forms|
Basics of Forms: Review and Tips and TricksPreview
Advanced Features of Forms Part 1Preview
Advanced Features of Forms Part 2
Advanced Features of Forms Part 3
Advanced Features of Forms Part 4
|Section 13: SQL|
Basics of Queries: Review
Main Features and Syntax of SQL Statements
Use of Multiple Criteria of a Where Clause
|Section 14: Joins|
How Joins Look in SQL Statements and using Query Grids
|Section 15: Action Queries|
Delete and Make Table Queries
|Section 16: Packaging your Application|
Protecting your Database and Codes
Making your Database More User-Friendly
|Section 17: Web Apps|
Setting up an Access Web App
Building Basic Web Apps
|Section 18: Conclusion|
|Section 19: Assessment Test|
Access 2013 Advanced Quiz
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.