Introduction
  • Acquiring Access 2013; Course Overview
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Downloadable Course Transcripts
  • What's New in Access 2013
  • Access 2013 keyboard shortcuts
Using Touch
  • Overview of Principles
Getting Started
  • Database Templates; Creating, Opening and Saving Databases
  • Workspace and Backstage View
Help
  • Online, Offline, and Contextual Help
Keyboard Shortcuts and Key Tips
  • Finding Keyboard Shortcuts and Key Tips
Access Options
  • Customizing the Settings and Use of Access 2013
The Ribbon and Toolbars
  • The Ribbon
  • Quick Access Toolbar
Status Bar
  • Customizing the Status Bar
Database Basics
  • Overview of the Main Features of Access Database
  • Web App Basics
Introduction to Tables
  • Tables - Part 1
  • Tables - Part 2
  • Relationship between Tables - Part 1
  • Relationship between Tables - Part 2
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
Table Design
  • Design View; Field Properties
  • Saving Data; Data Types, Attachments and Field Size
  • Input Masks; More on Field Properties
Forms
  • Course Review
  • 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
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
Reports
  • Report Wizard; Previewing a Report
  • Report Design
  • Grouped and Summary Reports; Modifying a Report
  • Adding Subreports
Printing
  • Documenter; Print Properties and Options
Importing and Exporting Data
  • Import and Append; Copy and Paste; Export Access Database
Templates and Application Parts
  • Database Templates and Application Parts
More on Forms
  • Navigation Form
  • Modal Dialogs - Part 1
  • Modal Dialogs - Part 2
  • Modal Dialogs - Part 3
Macros and VBA
  • Actions; Example of VBA; Creating AutoExec Macro
Additional Topics
  • More Access Options
  • Info Tab
Security
  • Trust Center
Conclusion
  • Updates; Closing
Course Quiz
  • Assessment Test