Learn Microsoft Access 2013 Beginner Course
  • Acquiring Access 2013; Course Overview
  • WATCH ME: Essential Information for a Successful Training Experience
  • Access 2013 Exercise Files
  • What's New in Access 2013
  • 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
  • WATCH ME: Essential Information for a Successful Training Experience
  • 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