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 2013 Advanced Course

Course Summary

Get ready to take your Microsoft Access 2013 skills to the next level with this advanced Access 2013 course.

  • +

    Course Syllabus

    • Introduction
      • Prerequisites and Basic Knowledge of Access 2013
      • Course exercise files
      • Access 2013 keyboard shortcuts
    • Indexes
      • Indexes and Introduction to the Movies Database
    • Datasheet View
      • Basics in Working with Datasheet View
      • Controlling the Display and Advanced Sorting and Filtering in Datasheet View
    • Linking Access Databases
      • Linking to Other Access Database Tables
    • Chapter 5: ODBC and SQL Server
      • How to Install SQL Server Express
      • Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
    • Splitting an Access Database
      • Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
      • Consequences of the Split; Moving a Database; Adding a Trusted Location
    • Multi-user Aspects
      • Access Options relating to Multi-user Issues; Record Locking
    • Macros
      • Basics of Macros and Properties of Macro Editor
      • Examples of Macros; Autoexec
      • More Autoexec
      • Macro Security
    • The Ribbon
      • Customizing the Quick Access Toolbar and the Ribbon
    • Visual Basic for Applications
      • Convert Macro to VBA; VBA Editor
      • Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes
      • Modules, Subs, Options Explicit, and Variables
      • Scope of Variables
      • Branch and Loop
    • Events
      • Course Review
      • Customizing Events
      • Responding to Events and Developing Error Handles
      • More on Events
      • Getting Help with Events
    • Forms
      • Basics of Forms: Review and Tips and Tricks
      • Advanced Features of Forms Part 1
      • Advanced Features of Forms Part 2
      • Advanced Features of Forms Part 3
      • Advanced Features of Forms Part 4
    • SQL
      • Basics of Queries: Review
      • Main Features and Syntax of SQL Statements
      • Use of Multiple Criteria of a Where Clause
    • Joins
      • How Joins Look in SQL Statements and using Query Grids
    • Action Queries
      • Update Query
      • Delete and Make Table Queries
      • Append Query
    • Packaging your Application
      • Protecting your Database and Codes
      • Making your Database More User-Friendly
    • Web Apps
      • Setting up an Access Web App
      • Building Basic Web Apps
    • Conclusion
      • Closing
    • Assessment Test
      • Access 2013 Advanced Quiz

Course Fee:
USD 97

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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