Access 2013 Advanced
4.4 (4 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.
37 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Access 2013 Advanced

Learn to improve and maintain a database, create Switchboards, and secure and automate an Access database
4.4 (4 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.
37 students enrolled
Last updated 8/2016
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 2.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 an Access Database
  • Maintain an Access Database
  • Create and Modify Switchboards
  • Configure Security and Multi-User Environments
  • Automate Processes with VBA
  • Use Table Events
View Curriculum
Requirements
  • Access 2013 Introduction and Intermediate courses or equivalent experience
Description

Access 2013 Advanced will further build upon the topics covered in the Access 2013 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, using the Table Analyzer Wizard, Normalize tables, and creating Junction Tables, and how to maintain an Access database by creating backups, compacting and repairing, and using the Performance Analyzer Tool. Students will create and modify Switchboards for easier user navigation, configure security and multi-user environments by splitting a database and password protecting a database. In addition, students will automate processes with VBA (Visual Basic for Applications), and learn to use Table Events.

Who is the target audience?
  • Students who wish to build upon the topics covered in the Access Introduction and Intermediate courses.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
28 Lectures
02:28:15
+
Introduction
1 Lecture 03:08
+
Improving the Structure of an Access Database
3 Lectures 23:51

Using an Append Query to Normalize a Table
08:43

Creating a Junction Table to Manage a Many-to-Many Relationship
08:28
+
Maintaining an Access Database
5 Lectures 13:48

Using the Compact and Repair Database Tool
03:22

Using the Object Dependencies Tool
02:58

Using the Database Documenter Tool
01:54

Using the Performance Analyzer Tool
03:04
+
Creating and Modifying Switchboards
4 Lectures 21:46

Using the Switchboard Manager
08:23

Modifying a Switchboard
05:53

Setting the Startup Options
04:59
+
Configuring Security and Multi-User Environments
5 Lectures 17:42
Using the Database Splitter
04:03

Configuring Trusted Locations
03:27

Password Protecting a Database
03:40

Password Protecting Modules
03:10

Converting an Access Database to an ACCDE File
03:22
+
Automating Processes with VBA
6 Lectures 51:17

Exploring Variables and Control Flow Statements
09:04

Using VBA to Export a Table or Query to Excel
10:43

Using VBA to Export the Specified Table or Query to Excel
10:26

Using VBA to Create a Custom Switchboard
09:25

Converting a Macro to VBA
05:09
+
Using Table Events
3 Lectures 13:51

Using the Before Change Event Command
07:08

Using the After Update Event Command
04:52
+
Conclusion
1 Lecture 02:52
Course Recap
02:52
About the Instructor
Intellezy Trainers
4.4 Average rating
4,602 Reviews
26,915 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.