Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Microsoft Access 2013
Introduction
Acquiring Access 2013; Course Overview (14:31)
What's New in Access 2013 (9:26)
Course Exercise Files
Using Touch
Overview of Principles (5:53)
Getting Started
Database Templates; Creating, Opening and Saving Databases (11:26)
Workspace and Backstage View (10:31)
Help
Online, Offline, and Contextual Help (5:49)
Keyboard Shortcuts and Key Tips
Finding Keyboard Shortcuts and Key Tips (5:57)
Access Options
Customizing the Settings and Use of Access 2013 (11:23)
The Ribbon and Toolbars
The Ribbon (11:22)
Quick Access Toolbar (4:49)
Status Bar
Customizing the Status Bar (3:42)
Database Basics
Overview of the Main Features of Access Database (16:43)
Web App Basics (10:42)
Introduction to Tables
Tables - Part 1 (15:29)
Tables - Part 2 (14:46)
Relationship between Tables - Part 1 (14:32)
Relationship between Tables - Part 2 (8:37)
Datasheet View
Inserting and Formatting Fields; Field Validation; Navigation Buttons (12:19)
Sorting, Filtering and Finding Data (13:21)
Entering Data; Changing the Order of Columns, Field Width and Height (8:00)
Table Design
Design View; Field Properties (13:36)
Saving Data; Data Types, Attachments and Field Size (14:06)
Input Masks; More on Field Properties (15:06)
Forms
Creating Forms; Form Wizard (14:36)
Single Forms; Insert, Delete, Modify, Sort and Filter Records (12:35)
Layout View; Adding Existing Fields (15:55)
Design View; Arranging Fields (16:27)
Controls (14:06)
Form Design (13:25)
Queries
Query Design (15:30)
Joins and Query Wizard (15:03)
Query Types (13:51)
Operators and Expressions - Part 1 (12:00)
Operators and Expressions - Part 2 (7:32)
Operators and Expressions - Part 3 (15:04)
Subforms (12:32)
Reports
Report Wizard; Previewing a Report (9:41)
Report Design (13:57)
Grouped and Summary Reports; Modifying a Report (15:26)
Adding Subreports (11:40)
Printing
Documenter; Print Properties and Options (9:20)
Importing and Exporting Data
Import and Append; Copy and Paste; Export Access Database (13:45)
Templates and Application Parts
Database Templates and Application Parts (14:21)
More on Forms
Navigation Form (10:45)
Modal Dialogs - Part 1 (11:52)
Modal Dialogs - Part 2 (13:33)
Modal Dialogs - Part 3 (9:39)
Macros and VBA
Actions; Example of VBA; Creating AutoExec Macro (15:25)
Additional Topics
More Access Options (8:45)
Info Tab (11:49)
Security
Trust Center (12:58)
Conclusion
Updates; Closing (2:21)
Course Quiz and Certificate of Completion
Query Design
Complete and Continue