Microsoft Access 2013 Advanced Course
4.1 (48 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,195 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access 2013 Advanced Course to your Wishlist.

Add to Wishlist

Microsoft Access 2013 Advanced Course

Get ready to take your Microsoft Access 2013 skills to the next level with this advanced Access 2013 course.
4.1 (48 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,195 students enrolled
Created by Simon Sez IT
Last updated 1/2017
English
Current price: $10 Original price: $100 Discount: 90% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • Anyone with a basic understanding of Microsoft Access
  • Microsoft Access 2013
Description

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:

  1. Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster.
  2. Exercise files – to help you become proficient with the material.
  3. An online quiz (45 questions) - to test what you've learned.
  4. A certificate of completion to tell everyone you've aced the course.

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."

- TopTenReviews.com

Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.

Who is the target audience?
  • Anyone with a basic understanding of Microsoft Access
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 45 Lectures Collapse All 45 Lectures 09:46:46
+
Introduction
4 Lectures 11:12

Essential Information for a Successful Training Experience
01:36

Course exercise files
00:25

Access 2013 keyboard shortcuts
19 pages
+
Datasheet View
2 Lectures 25:50

Controlling the Display and Advanced Sorting and Filtering in Datasheet View
15:21
+
Linking Access Databases
1 Lecture 14:41
Linking to Other Access Database Tables
14:41
+
Chapter 5: ODBC and SQL Server
2 Lectures 31:39
How to Install SQL Server Express
14:49

Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
16:50
+
Splitting an Access Database
2 Lectures 31:26

Consequences of the Split; Moving a Database; Adding a Trusted Location
16:07
+
Multi-user Aspects
1 Lecture 14:58
Access Options relating to Multi-user Issues; Record Locking
14:58
+
Macros
4 Lectures 52:13

Examples of Macros; Autoexec
14:29

More Autoexec
14:43

Macro Security
08:37
+
The Ribbon
1 Lecture 15:17
Customizing the Quick Access Toolbar and the Ribbon
15:17
+
Visual Basic for Applications
5 Lectures 01:15:29

Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes
14:27

Modules, Subs, Options Explicit, and Variables
15:58

Scope of Variables
16:13

Branch and Loop
14:38
9 More Sections
About the Instructor
Simon Sez IT
4.4 Average rating
9,724 Reviews
289,437 Students
113 Courses
280,000+ Students | Wordwide Use 180 Countries |115 Courses

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,500+ 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 280,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.