Access 2010 Advanced

Name: Access 2010 Advanced
Rating: 4.3 (31 reviews)

Learn how to bring all Access objects together to create a cohesive and effective application

Created byIntellezy Trainers

Last updated 5/2018

English

English [Auto],

What you'll 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

Course content

9 sections • 27 lectures • 3h 54m total length

Introduction2: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.

Creating an Autofill Form10:47
Create an auto fill form in access 2010 advanced to automatically populate related customer details when selecting a customer, without coding, and allow edits that sync back to the tables.
Forms and Subforms10:49
Advanced Calculated Controls19:05
Using the Tab Control10:00
Use the tab control to organize a long order form into customer detail, shipping, and payment tabs, so most information fits on one screen and tab order guides navigation.
Option Group Control9:58

Different Macro Types5:11
Reviewing the Object Events15:35
Explore how Access form events drive behavior, from On Current and On Load to On Close and Timer, including focus, dirty state, and testing with macros.
Creating Macros32:42
Learn to design Microsoft Access forms with embedded and standalone macros that control credit card visibility and validate credit card number and expiration date using on click and set property.

AutoStart Options9:05
Learn how to wrap up and distribute an Access database by setting auto start options, startup forms, login screens, securing with a password, and converting to an A.S.C. e-file.
Documenting a Database10:42
Encrypting and Decrypting a Database4:20
Converting to an .accde File3:52
Convert your Access 2010 database to an accde file using save as, advanced, and make accde. Package and sign the file, use the compatibility checker for SharePoint, and enable backup.
Packaging the Database3:51

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 this course is for:

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

Access 2010 Advanced

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Designing The Application6 lectures • 18min

Table Data Macros3 lectures • 29min

Creating Advanced Queries3 lectures • 35min

Advanced Form Design5 lectures • 1hr 1min

Macros3 lectures • 53min

System Wrap-Up and Distribution5 lectures • 32min

Conclusion1 lecture • 4min