Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Ultimate Microsoft Access 2013 Training Bundle
Chapter 1: Introduction
Acquiring Access 2013; Course Overview (14:31)
What's New in Access 2013 (9:26)
Course Exercise Files
Chapter 2: Using Touch
Overview of Principles (5:53)
Chapter 3: Getting Started
Database Templates; Creating, Opening and Saving Databases (11:26)
Workspace and Backstage View (10:31)
Chapter 4: Help
Online, Offline and Contextual Help (5:49)
Chapter 5: Keyboard Shortcuts and Key Tips
Finding Keyboard Shortcuts and Key Tips (5:57)
Chapter 6: Access Options
Customizing the Settings and Use of Access 2013 (11:23)
Chapter 7: The Ribbon and Toolbars
The Ribbon (11:22)
Quick Access Toolbar (4:49)
Chapter 8: Status Bar
Customizing the Status Bar (3:42)
Chapter 9: Database Basics
Overview of the Main Features of Access Database (16:43)
Web App Basics (10:42)
Chapter 10: Tables
Creating Tables - Part 1 (15:29)
Creating Tables - Part 2 (14:46)
Relationship between Tables - Part 1 (14:32)
Relationship between Tables - Part 2 (8:37)
Chapter 11: 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)
Chapter 12: 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)
Chapter 13: 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)
Chapter 14: 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)
Chapter 15: 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)
Adding Subreports
Documenter; Print Properties and Options (9:20)
Chapter 17: Importing and Exporting Data
Import and Append; Copy and Paste; Export Access Database (13:45)
Chapter 18: Templates and Application Parts
Database Templates and Application Parts (14:21)
Chapter 19: 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)
Chapter 20: Macros and VBA
Actions; Example of VBA; Creating AutoExec Macro (15:25)
Chapter 21: Additional Topics
More Access Options (8:45)
Info Tab (11:49)
Chapter 23: Security
Trust Center (12:58)
Chapter 23: Conclusion
Updates; Closing (2:22)
Chapter 24: Course Quiz
Microsoft Access 2013 Beginners Course Quiz
Chapter 1: Introduction
Pre-requisites and Basic Knowledge of Access 2013 (9:10)
Course Exercise Files
Chapter 2: Indexes
Indexes and Introduction to the Movies Database (14:36)
Chapter 3: Datasheet View
Basics in Working with Datasheet View (10:29)
Controlling the Display and Advanced Sorting and Filtering in Datasheet View (15:21)
Chapter 4: Linking Access Databases
Linking to Other Access Database Tables (14:41)
Chapter 5: ODBC and SQL Server
How to Install SQL Server Express (14:49)
Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server (16:50)
Chapter 6: Splitting an Access Database
Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end (15:19)
Consequences of the Split; Moving a Database; Adding a Trusted Location (16:07)
Chapter 7: Multi-user Aspects
Access Options relating to Multi-user Issues; Record Locking (14:58)
Chapter 8: Macros
Basics of Macros and Properties of Macro Editor (14:23)
Examples of Macros; Autoexec (14:29)
More Autoexec (14:43)
Macro Security (8:37)
Chapter 9: The Ribbon
Customizing the Quick Access Toolbar and the Ribbon (15:17)
Chpater 10: Visual Basic for Applications
Convert Macro to VBA; VBA Editor (14:13)
Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes (14:27)
Modules, Subs, Options Explicit, and Variables (15:58)
Scope of Variables (16:13)
Branch and Loop (14:38)
Chapter 11: Events
Customizing Events (15:08)
Responding to Events and Developing Error Handles (14:00)
More on Events (14:11)
Getting Help with Events (8:24)
Chapter 12: Forms
Basics of Forms: Review and Tips and Tricks (15:39)
Advanced Features of Forms - Part 1 (17:19)
Advanced Features of Forms - Part 2 (14:33)
Advanced Features of Forms - Part 3 (14:49)
Advanced Features of Forms - Part 4 (15:19)
Chapter 13: SQL
Basics of Queries: Review (13:57)
Main Features and Syntax of SQL Statements (15:53)
Use of Multiple Criteria of a Where Clause (12:55)
Chapter 14: Joins
How Joins Look in SQL Statements and using Query Grids (15:49)
Chapter 15: Action Queries
Update Query (15:42)
Delete and Make Table Queries (12:20)
Append Query (7:12)
Chapter 16: Packaging your Application
Protecting your Database and Codes (15:08)
Making your Database More User-Friendly (7:23)
Chapter 17: Web Apps
Setting up an Access Web App (16:33)
Building Basic Web Apps (16:48)
Chapter 18: Conclusion
Closing (0:44)
Chapter 19: Course Quiz
Quiz - Microsoft Access 2013 Advanced Course
Bonus Material
Access 2013 Keyboard Shortcuts
Customizing Events
Complete and Continue