Access 2016 Advanced
4.1 (10 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.
70 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access 2016 Advanced to your Wishlist.

Add to Wishlist

Access 2016 Advanced

Students will learn the advanced features and functionality of Access 2016
4.1 (10 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.
70 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Improve the Structure of a Database
  • Maintain a Database
  • Work with Access Switchboards
  • Configure Access for Multiple Users
  • Automate Processed with VBA
  • Use Table Events
View Curriculum
Requirements
  • Access Introduction and Intermediate courses or equivalent experience.
Description

Access 2016 Advanced will further build upon the topics covered in the Access 2016 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database by using the table analyzer wizard and creating a junction table. They will explore how to maintain an Access database, including how to back up a database and how to use various tools such as the object dependencies tool. Student will also learn how to create and modify Switchboards, how to configure security and access for multi-user environments, how to automate processes with VBA (Visual Basic for Applications), and finally how to use Table Events.

Who is the target audience?
  • Students who wish to learn the more advanced capabilities of Access.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
01:37:43
+
Introduction
1 Lecture 00:50
+
Improving the Structure of a Database
3 Lectures 19:51
Using the Table Analyzer Wizard
05:01

Append Querying to Normalize a Table
08:22

+
Maintaining a Database
5 Lectures 10:13
Backing Up a Database
02:05

Using the Compact and Repair Database Tool
03:06


Using the Database Documenter Tool
01:40

Using the Performance Analyzer Tool
01:28
+
Working with Access Switchboards
4 Lectures 21:22
Understanding the Access Switchboard
03:18

Using The Switchboard Manager
09:02


Setting the Startup Options
03:48
+
Configuring Access for Multiple Users
5 Lectures 10:54
Using the Database Splitter
03:29

Configuring Trusted Locations
01:43


Password Protecting Modules
01:16

Converting a Database to an ACCDE file
01:28
+
Automating Processes with VBA
4 Lectures 23:40
Understanding VBA Basics
05:49

Exploring Variables and Control Flow Statements
10:13


Converting a Macro to VBA
01:38
+
Using Table Events
3 Lectures 10:06
Understanding Table Events
01:50


Using the After Change Event Command
04:18
+
Conclusion
1 Lecture 00:47
Course Recap
00:47
About the Instructor
Intellezy Trainers
4.4 Average rating
5,030 Reviews
28,824 Students
137 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.