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.2 (34 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,093 students enrolled
$100
Take This Course
  • Lectures 45
  • Contents Video: 9.5 hours
    Other: 20 mins
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2013 English

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

What are the requirements?

  • Anyone with a basic understanding of Microsoft Access
  • Microsoft Access 2013

What am I going to get from this course?

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

What is the target audience?

  • Anyone with a basic understanding of Microsoft Access

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Prerequisites and Basic Knowledge of Access 2013
Preview
09:10
IMPORTANT - Read this to ensure the best video quality!
Article
Course exercise files
Article
Access 2013 keyboard shortcuts
19 pages
Section 2: Indexes
Indexes and Introduction to the Movies Database
Preview
14:36
Section 3: Datasheet View
Basics in Working with Datasheet View
Preview
10:29
Controlling the Display and Advanced Sorting and Filtering in Datasheet View
15:21
Section 4: Linking Access Databases
Linking to Other Access Database Tables
14:41
Section 5: Chapter 5: ODBC and SQL Server
How to Install SQL Server Express
14:49
Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
16:50
Section 6: Splitting an Access Database
Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
Preview
15:19
Consequences of the Split; Moving a Database; Adding a Trusted Location
16:07
Section 7: Multi-user Aspects
Access Options relating to Multi-user Issues; Record Locking
14:58
Section 8: Macros
Basics of Macros and Properties of Macro Editor
Preview
14:24
Examples of Macros; Autoexec
14:29
More Autoexec
14:43
Macro Security
08:37
Section 9: The Ribbon
Customizing the Quick Access Toolbar and the Ribbon
15:17
Section 10: Visual Basic for Applications
Convert Macro to VBA; VBA Editor
Preview
14:13
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
Section 11: Events
Course Review
00:43
Customizing Events
15:08
Responding to Events and Developing Error Handles
14:00
More on Events
14:12
Getting Help with Events
08:24
Section 12: Forms
Basics of Forms: Review and Tips and Tricks
Preview
15:39
Advanced Features of Forms Part 1
Preview
17:19
Advanced Features of Forms Part 2
14:33
Advanced Features of Forms Part 3
14:49
Advanced Features of Forms Part 4
15:19
Section 13: SQL
Basics of Queries: Review
13:57
Main Features and Syntax of SQL Statements
15:53
Use of Multiple Criteria of a Where Clause
12:55
Section 14: Joins
How Joins Look in SQL Statements and using Query Grids
15:50
Section 15: Action Queries
Update Query
Preview
15:42
Delete and Make Table Queries
12:20
Append Query
07:13
Section 16: Packaging your Application
Protecting your Database and Codes
15:08
Making your Database More User-Friendly
07:23
Section 17: Web Apps
Setting up an Access Web App
16:33
Building Basic Web Apps
16:48
Section 18: Conclusion
Closing
00:44
Section 19: Assessment Test
Access 2013 Advanced Quiz
45 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Software training to help you succeed

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.

Ready to start learning?
Take This Course