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

The Ultimate Microsoft Access 2013 Training Bundle

Course Summary

The Most Convenient Way to Boost Your Confidence And Learn MS Access 2013 Inside And Out—Quickly, No Travel or Classes.

  • +

    Course Syllabus

    • Learn Microsoft Access 2013 Beginner Course
      • Acquiring Access 2013; Course Overview
      • What's New in Access 2013
      • Using Touch
      • Database Templates; Creating, Opening and Saving Databases
      • Access 2013 Exercise Files
      • Workspace and Backstage View
      • Online, Offline, and Contextual Help
      • Finding Keyboard Shortcuts and Key Tips
      • Customizing the Settings and Use of Access 2013
      • The Ribbon
      • Quick Access Toolbar
      • Customizing the Status Bar
      • Overview of the Main Features of Access Database
      • Web App Basics
      • Creating Tables - Part 1
      • Creating Tables - Part 2
      • Relationships Between Tables - Part 1
      • Relationships Between Tables - Part 2
      • Inserting and Formatting Fields; Field Validation; Navigation Buttons
      • Sorting, Filtering and Finding Data
      • Entering Data; Changing the Order of Columns, Field Width and Height
      • Design View; Field Properties
      • Saving Data; Data Types, Attachments and Field Size
      • Input Masks; More on Field Properties
      • Creating Forms; Form Wizard
      • Single Forms; Insert, Delete, Modify, Sort and Filter Records
      • Layout View; Adding Existing Fields
      • Design View; Arranging Fields
      • Controls
      • Form Design
      • Query Design
      • Joins and Query Wizard
      • Query Types
      • Operators and Expressions - Part 1
      • Operators and Expressions - Part 2
      • Operators and Expressions - Part 3
      • Subforms
      • Report Wizard; Previewing a Report
      • Report Design
      • Grouped and Summary Reports; Modifying a Report
      • Adding Subreports
      • Documenter; Print Properties and Options
      • Import and Append; Copy and Paste; Export Access Database
      • Database Templates and Application Parts
      • Navigation Form
      • Modal Dialogs - Part 1
      • Modal Dialogs - Part 2
      • Modal Dialogs - Part 3
      • Actions; Example of VBA; Creating AutoExec Macro
      • More Access Options
      • Info Tab
      • Trust Center
      • Updates; Closing
      • Access 2013 Quiz
    • Learn Microsoft Access 2013 Advanced Training Course
      • Course Review
      • Pre-requisites and Basic Knowledge of Access 2013
      • Access 2013 Advanced Exercise Files
      • Indexes and Introduction to the Movies Database
      • Basics in Working with Datasheet View
      • Controlling the Display and Advanced Sorting and Filtering in Datasheet View
      • Linking to Other Access Database Tables
      • How to Install SQL Server Express
      • Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
      • 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
      • Access Options relating to Multi-user Issues; Record Locking
      • Basics of Macros and Properties of Macro Editor
      • Examples of Macros; Autoexec
      • More Autoexec
      • Macro Security
      • Customizing the Quick Access Toolbar and the Ribbon
      • 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
      • Customizing Events
      • Responding to Events and Developing Error Handles
      • More on Events
      • Getting Help with Events
      • 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
      • Basics of Queries: Review
      • Main Features and Syntax of SQL Statements
      • Use of Multiple Criteria of a Where Clause
      • How Joins Look in SQL Statements and using Query Grids
      • Update Query
      • Delete and Make Table Queries
      • Append Query
      • Protecting your Database and Codes
      • Making your Database More User-Friendly
      • Setting up an Access Web App
      • Building Basic Web Apps
      • Closing
      • Access 2013 Advanced Quiz

Course Fee:
USD 177

Course Type:


Course Status:



1 - 4 hours / week

Related Posts:

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