Access 2013: Introduction
  • Acquiring Access 2013; Course Overview
  • Essential Information for a Successful Training Experience
  • Access 2013 Exercise Files
  • Downloadable Course Transcripts
  • What's New in Access 2013
Access 2013: Using Touch
  • Using Touch
Access 2013: Getting Started
  • Database Templates; Creating, Opening and Saving Databases
  • Workspace and Backstage View
Access 2013: Help
  • Online, Offline, and Contextual Help
Access 2013: Keyboard Shortcuts and Key Tips
  • Finding Keyboard Shortcuts and Key Tips
Access 2013: Access Options
  • Customizing the Settings and Use of Access 2013
Access 2013: The Ribbon and Toolbars
  • The Ribbon
  • Quick Access Toolbar
Access 2013: Status Bar
  • Customizing the Status Bar
Access 2013: Database Basics
  • Overview of the Main Features of Access Database
  • Web App Basics
Access 2013: Tables
  • Creating Tables - Part 1
  • Creating Tables - Part 2
  • Relationships Between Tables - Part 1
  • Relationships Between Tables - Part 2
Access 2013: Datasheet View
  • Inserting and Formatting Fields; Field Validation; Navigation Buttons
  • Sorting, Filtering and Finding Data
  • Entering Data; Changing the Order of Columns, Field Width and Height
Access 2013: Table Design
  • Design View; Field Properties
  • Saving Data; Data Types, Attachments and Field Size
  • Input Masks; More on Field Properties
Access 2013: Forms
  • 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
Access 2013: Queries
  • Query Design
  • Joins and Query Wizard
  • Query Types
  • Operators and Expressions - Part 1
  • Operators and Expressions - Part 2
  • Operators and Expressions - Part 3
  • Subforms
Access 2013: Reports
  • Report Wizard; Previewing a Report
  • Report Design
  • Grouped and Summary Reports; Modifying a Report
  • Adding Subreports
Access 2013: Printing
  • Documenter; Print Properties and Options
Access 2013: Importing and Exporting Data
  • Import and Append; Copy and Paste; Export Access Database
Access 2013: Templates and Application Parts
  • Database Templates and Application Parts
Access 2013: More on Forms
  • Navigation Form
  • Modal Dialogs - Part 1
  • Modal Dialogs - Part 2
  • Modal Dialogs - Part 3
Access 2013: Macros and VBA
  • Actions; Example of VBA; Creating AutoExec Macro
Access 2013: Additional Topics
  • More Access Options
  • Info Tab
Access 2013: Security
  • Trust Center
Access 2013: Conclusion
  • Updates; Closing
  • Access 2013 Quiz
Access 2013 Advanced: Introduction
  • Pre-requisites and Basic Knowledge of Access 2013
  • Essential Information for a Successful Training Experience
  • Access 2013 Advanced Exercise Files
  • Course Review
Access 2013 Advanced: Indexes
  • Indexes and Introduction to the Movies Database
Access 2013 Advanced: Datasheet View
  • Basics in Working with Datasheet View
  • Controlling the Display and Advanced Sorting and Filtering in Datasheet View
Access 2013 Advanced: Linking Access Databases
  • Linking to Other Access Database Tables
Access 2013 Advanced: ODBC and SQL Server
  • How to Install SQL Server Express
  • Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
Access 2013 Advanced: 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
Access 2013 Advanced: Multi-user Aspects
  • Access Options relating to Multi-user Issues; Record Locking
Access 2013 Advanced: Macros