Access 2010 Advanced
4.2 (16 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.
192 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Access 2010 Advanced

Learn how to bring all Access objects together to create a cohesive and effective application
4.2 (16 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.
192 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Design the application
  • Create and use advanced queries
  • Use advanced form design
  • Create effective reports
  • Create and use macros
  • Understand importance of documentation
  • Distribute the database
View Curriculum
Requirements
  • Basic Microsoft Windows and Intermediate Microsoft Access 2010 training or equivalent experience
Description

This course builds on the Introduction and Intermediate courses to show techniques to bring all of the different Access objects together to make a cohesive application. It does this by showing the viewer how and why Microsoft Access utilizes the Properties and Events of the different objects. Finally, the course shows the viewer how to create macros using the new Macro editor and how to select the proper Control and Event for the best possible outcome.

Who is the target audience?
  • Students who are familiar with creating and expanding upon basic databases looking to automate their databases through the use of macros, create more effective reports and use controls
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 27 Lectures Collapse All 27 Lectures 03:54:39
+
Introduction
1 Lecture 02:40

If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.  

Preview 02:40
+
Designing The Application
6 Lectures 18:00

Define Database Architecture
01:51

Entire Database on Server
02:33

Splitting the Database
03:48

Creating a Database Project
02:32

+
Table Data Macros
3 Lectures 29:02

Event-Driven Data Macro
17:16

The Application Log
07:37
+
Creating Advanced Queries
3 Lectures 35:22
Using Left and Right Joins
12:21

Creating a Crosstab Query
07:48

Using Access Function within a Query
15:13
+
Advanced Form Design
5 Lectures 01:00:39
Creating an Autofill Form
10:47

Forms and Subforms
10:49

Advanced Calculated Controls
19:05

Using the Tab Control
10:00

Option Group Control
09:58
+
Macros
3 Lectures 53:28

Reviewing the Object Events
15:35

Creating Macros
32:42
+
System Wrap-Up and Distribution
5 Lectures 31:50
AutoStart Options
09:05

Documenting a Database
10:42

Encrypting and Decrypting a Database
04:20

Converting to an .accde File
03:52

Packaging the Database
03:51
+
Conclusion
1 Lecture 03:38
Conclusion
03:38
About the Instructor
Intellezy Trainers
4.4 Average rating
3,061 Reviews
20,728 Students
132 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.