Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Ultimate Microsoft Access 2013 Training Bundle
Chapter 1: Introduction
Acquiring Access 2013; Course Overview
What's New in Access 2013
Course Exercise Files
Chapter 2: Using Touch
Overview of Principles
Chapter 3: Getting Started
Database Templates; Creating, Opening and Saving Databases
Workspace and Backstage View
Chapter 4: Help
Online, Offline and Contextual Help
Chapter 5: Keyboard Shortcuts and Key Tips
Finding Keyboard Shortcuts and Key Tips
Chapter 6: Access Options
Customizing the Settings and Use of Access 2013
Chapter 7: The Ribbon and Toolbars
The Ribbon
Quick Access Toolbar
Chapter 8: Status Bar
Customizing the Status Bar
Chapter 9: Database Basics
Overview of the Main Features of Access Database
Web App Basics
Chapter 10: Tables
Creating Tables - Part 1
Creating Tables - Part 2
Relationship between Tables - Part 1
Relationship between Tables - Part 2
Chapter 11: 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
Chapter 12: Table Design
Design View; Field Properties
Saving Data; Data Types, Attachments and Field Size
Input Masks; More on Field Properties
Chapter 13: 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
Chapter 14: 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
Chapter 15: Reports
Report Wizard; Previewing a Report
Report Design
Grouped and Summary Reports; Modifying a Report
Adding Subreports
Adding Subreports
Documenter; Print Properties and Options
Chapter 17: Importing and Exporting Data
Import and Append; Copy and Paste; Export Access Database
Chapter 18: Templates and Application Parts
Database Templates and Application Parts
Chapter 19: More on Forms
Navigation Form
Modal Dialogs - Part 1
Modal Dialogs - Part 2
Modal Dialogs - Part 3
Chapter 20: Macros and VBA
Actions; Example of VBA; Creating AutoExec Macro
Chapter 21: Additional Topics
More Access Options
Info Tab
Chapter 23: Security
Trust Center
Chapter 23: Conclusion
Updates; Closing
Chapter 1: Introduction
Pre-requisites and Basic Knowledge of Access 2013
Course Exercise Files
Chapter 2: Indexes
Indexes and Introduction to the Movies Database
Chapter 3: Datasheet View
Basics in Working with Datasheet View
Controlling the Display and Advanced Sorting and Filtering in Datasheet View
Chapter 4: Linking Access Databases
Linking to Other Access Database Tables
Chapter 5: ODBC and SQL Server
How to Install SQL Server Express
Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
Chapter 6: 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
Chapter 7: Multi-user Aspects
Access Options relating to Multi-user Issues; Record Locking
Chapter 8: Macros
Basics of Macros and Properties of Macro Editor
Examples of Macros; Autoexec
More Autoexec
Macro Security
Chapter 9: The Ribbon
Customizing the Quick Access Toolbar and the Ribbon
Chpater 10: Visual Basic for Applications
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
Chapter 11: Events
Customizing Events
Responding to Events and Developing Error Handles
More on Events
Getting Help with Events
Chapter 12: Forms
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
Chapter 13: SQL
Basics of Queries: Review
Main Features and Syntax of SQL Statements
Use of Multiple Criteria of a Where Clause
Chapter 14: Joins
How Joins Look in SQL Statements and using Query Grids
Chapter 15: Action Queries
Update Query
Delete and Make Table Queries
Append Query
Chapter 16: Packaging your Application
Protecting your Database and Codes
Making your Database More User-Friendly
Chapter 17: Web Apps
Setting up an Access Web App
Building Basic Web Apps
Chapter 18: Conclusion
Closing
Bonus Material
Access 2013 Keyboard Shortcuts
Acquiring Access 2013; Course Overview
Complete and Continue