Take this
course

Office Productivity / Microsoft

Access 2010 Advanced

Learn the advanced features and functionality of Access 2010.

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.


Instructor: Timothy Miles

Full details

Curriculum

  • Introduction
    Introduction
    2:41
    Course Exercise Files
  • Designing the Application
    Reviewing Access Development Phases
    4:26
    Defining Database Architecture
    1:52
    Using an Entire Database on a Server
    2:34
    Splitting the Database
    3:49
    Creating a Database Project: SQL Server
    2:34
    Integrating with SharePoint
    2:52
  • Table Data Macros
    Different Data Macro Types
    4:10
    Event-Driven Data Macro
    17:17
    The Application Log
    7:38
  • Creating Advanced Queries
    Using Left and Right Joins
    12:22
    Creating a Crosstab Query
    7:49
    Using Access Function Within a Query
    15:14
  • Advanced Form Design
    Creating an Autofill Form
    10:48
    Forms and Subforms
    10:50
    Advanced Calculated Controls
    19:06
    Using the Tab Control
    10:01
    Option Group Control
    9:59
  • Macros
    Different Macro Types
    5:13
    Reviewing the Object Events
    15:36
    Creating Macros
    32:43
  • System Wrap-Up
    AutoStart Options
    9:07
    Documenting a Database
    10:43
    Encrypting and Decrypting a Database
    4:21
    Converting to an .accde File
    3:53
    Packaging the Database
    3:52
  • Conclusion
    Course Recap
    3:39

Skills

  • Microsoft Access

Similar Courses

More Courses by this Instructor