MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Microsoft Access 2010 Training - Advanced

Course Summary

Upgrading your Microsoft Access skills is a smart move for any professional.


  • +

    Course Syllabus

    • Chapter 1 - Introduction
      • Introduction to Advanced Access 2010
      • Course transcripts
      • Microsoft Access 2010 keyboard shortcuts
      • MP3 audio files
    • Chapter 2 - Macros
      • Working with Macros
      • AutoExec Macro
    • Chapter 3 - Database Options before Distribution
      • Database Options
      • More Database Options
    • Chapter 4 - Naming
      • Renaming Database Objects
    • Chapter 5 - Tables
      • Review of Table Basics & Understanding Data Types
      • Table Field Properties
      • Validation Rules & Text
    • Chapter 6 - Keys and Indexes
      • Understanding & Using Keys and Indexes
    • Chapter 7 - Normalization
      • Data Normalization
    • Chapter 8 - Relationships
      • Types of Relationships
      • Maintaining Relationships
    • Chapter 9 - Queries
      • Using & Understanding Queries
      • Complex Queries
      • Creating Queries and Using Join & Sub-Queries
    • Chapter 10 - Datasheet View
      • Course Review
      • Datasheet View
    • Chapter 11 - Forms
      • Creating & Working with Forms
      • Using Forms to Maintain Data
      • Command Buttons
      • Command Buttons Part 2
      • Form Features that Need VBA Code
    • Chapter 12 - Visual Basic for Applications
      • Understanding When & How to Use VBA
      • More about VBA and Using It to Improve Database
      • VBA Language Structure & Making a Switchboard
      • Error Handling
    • Chapter 13 - Polishing Up
      • Cleaning Up Before Distribution
    • Chapter 14 - Security
      • Security Techniques
    • Chapter 15 - Import/Export
      • External Data & Importng/Exporting Data
    • Chapter 16 - Linking to Data
      • Linking to Excel & Linking to Another Database
    • Chapter 17 - Splitting Database
      • Separating/Splitting Up Forms, Reports, etc from Database
    • Chapter 18 - Multi-User
      • Options for Making Changes When Database is Multi-User
    • Chapter 19 - Reports
      • Advanced Features for Reports
      • Advanced Features for Reports part 2
    • Chapter 20 - Package & Distribute
      • Distributing Application
    • Quiz
      • Assessment Test


Course Fee:
USD 97

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top