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 Training Bundle

Course Summary

The Most Convenient Way to Boost Your Confidence And Learn MS Access 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
      • Access 2013 Exercise Files
      • Using Touch
      • Database Templates; Creating, Opening and Saving Databases
      • 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
      • Relationship 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
      • Prerequisites 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
    • Learn Microsoft Access 2010 Beginner Course
      • Course Review
      • Intro to Backstage View, Ribbon, Quick Access Toolbar & Options
      • Start/Exit, Help Features, Shortcuts, Views, Templates
      • Understanding Database Components
      • Introduction to Design of a Database
      • Introduction to Building a Database
      • Creating Tables & Basic Setup of Relationships
      • Using Quick Parts to Setup New Table, Importing Spreadsheet
      • Entering Data Types into Tables
      • Changing Table Attributes, Copy, Rename, Delete Records
      • Table Structures
      • Table and Field Properties
      • Auto-Create Forms, Filtering & Searching
      • Types of Different Forms & Creating New
      • Improve Look, Style, & Feel of Forms
      • Adding Fields to Existing Form
      • Understanding and Setting Up the Expression Builder
      • Format Control on Forms/Reports
      • Sorting Single & Multiple Columns; Filter One Field Data Records
      • Sorting & Filtering Data in Form View; Find & Replace in Forms
      • Understanding Reports & Structure
      • Creating Reports; Using Print Preview to Check Report Outcome
      • Advanced Reporting; Formatting Reports
      • How to Improve Report Design, Add Existing Fields; Group/Sort
      • Select Queries; Sorting; Defined Criteria
      • Change Fields wthin Query; Specifying Criteria for Numbers/Text
      • Update Queries; Append Queries; Delete Queries
      • Inner/Outer Joins; Make Table Queries; Mail Merge
      • Securing Database and Views; New Features
      • Access 2010 Quiz
    • Learn Microsoft Access 2010 Advanced Course
      • Introduction to Advanced Access 2010
      • Working with Macros
      • AutoExec Macro
      • Database Options
      • More Database Options
      • Renaming Database Objects
      • Basics & Understanding Data Types
      • Table and Field Properties
      • Validation Rules & Text
      • Understanding & Using Keys and Indexes
      • Data Normalization
      • Types of Relationships
      • Maintaining Relationships
      • Using & Understanding Queries
      • Complex Queries
      • Creating Queries and Using Join & Sub-Queries
      • Datasheet View
      • Creating & Working with Forms
      • Using Forms to Maintain Data
      • Command Buttons
      • Command Buttons Part 2
      • Form Features that Need VBA Code
      • Understanding When & How to Use VBA
      • More about VBA and Using It to Improve Database
      • VBA Language Structure & Making a Switchboard
      • Error Handling
      • Cleaning Up Before Distribution
      • Security Techniques
      • External Data & Importng/Exporting Data
      • Linking to Excel & Linking to Another Database
      • Separating/Splitting Up Forms, Reports, etc from Database
      • Options for Making Changes When Database is Multi-User
      • Advanced Features for Reports
      • Advanced Features for Reports Part 2
      • Distributing Application
      • Access 2010 Advanced Quiz


Course Fee:
USD 297

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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