Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Access 2010 Training - Beginners/Intermediate
Chapter 1 - Getting to Know the Workspace
Intro to Backstage View, Ribbon, Quick Access Toolbar & Options (15:38)
Start/Exit, Help Features, Shortcuts, Views, Templates (15:32)
Chapter 2 - Access Basics
Understanding Database Components (15:14)
Introduction to Design of a Database (14:19)
Introduction to Building a Database (13:27)
Chapter 3 - Tables
Creating Tables & Basic Setup of Relationships (15:25)
Using Quick Parts to Setup New Table, Importing Spreadsheet (16:18)
Entering Data Types into Tables (15:18)
Changing Table Attributes, Copy, Rename, Delete Records (16:21)
Table Structures (15:15)
Table and Field Properties (15:55)
Chapter 4 - Forms
Types of Different Forms & Creating New (14:56)
Improve Look, Style, & Feel of Forms (15:13)
Adding Fields to Existing Form (15:58)
Chapter 5 - Expression Builder
Understanding and Setting Up the Expression Builder (14:58)
Chapter 6 - Conditional Formatting
Format Control on Forms/Reports (14:58)
Chapter 7 - Sorting and Filtering
Sorting Single & Multiple Columns; Filter One Field Data Records (15:33)
Sorting & Filtering Data in Form View; Find & Replace in Forms (15:10)
Chapter 8 - Reports
Understanding Reports & Structure (15:24)
Creating Reports; Using Print Preview to Check Report Outcome (15:35)
Advanced Reporting; Formatting Reports (15:23)
How to Improve Report Design, Add Existing Fields; Group/Sort (14:25)
Chapter 9 - Queries
Select Queries; Sorting; Defined Criteria (15:00)
Change Fields wthin Query; Specifying Criteria for Numbers/Text (15:31)
Update Queries; Append Queries; Delete Queries (15:56)
Inner/Outer Joins; Make Table Queries; Mail Merge (16:27)
Chapter 10 - Security
Securing Database and Views; New Features (14:01)
Course Transcripts
Course Quiz and Certificate of Completion
Understanding Database Components
Complete and Continue