Access 2013 Essentials

Table of contents

1. Lesson 1
   1. What Is Access? 00:13:48
   2. The Office 2013 Environment 00:10:55
   3. The Access Work Environment 00:15:38
   4. Tables 00:13:48
   5. Views 00:17:57
   6. Forms 00:10:10
   7. Queries 00:13:17
   8. Reports 00:08:36
   9. Relationships 00:12:03
2. Lesson 2
   1. Fields, Records, Datatypes, Data 00:21:02
   2. Data Entry 00:13:50
   3. The Datasheet View 00:13:20
   4. Sorting, Filtering, and Totals 00:09:24
   5. The Design View 00:17:00
   6. AutoNumber and Primary Keys 00:07:56
   7. Creating and Editing Relationships 00:15:05
   8. Relationships: Referential Integrity 00:06:23
   9. Input Masks and Validation 00:22:15
   10. Using Lookups 00:08:47
3. Lesson 3
   1. Creating a Simple Select Query 00:19:06
   2. Grouping and Calculated Fields 00:11:00
   3. Functions, Expressions 00:15:05
   4. Joining Tables with Queries 00:15:40
   5. Action Queries and Parameters 00:20:38
   6. Crosstabs and Totals Queries 00:13:20
   7. SQL: Access's Hidden Engine 00:09:19
4. Lesson 4
   1. Building a Simple UI with Forms 00:13:30
   2. Form Layout 00:14:29
   3. Form Design 00:19:15
   4. Adding Controls to a Form UI 00:18:31
   5. Sorting and Filtering with Forms 00:07:54
   6. Getting More Complex: Subforms, Split Forms, and Validation 00:12:46
   7. Navigation Forms and More Subforms 00:14:23
5. Lesson 5
   1. Creating Simple Reports 00:09:22
   2. Using Expressions in a Report 00:06:41
   3. Grouping and Sorting 00:16:09
   4. Report Layout and Formatting 00:22:11
   5. The Design View 00:22:39
6. Lesson 6
   1. Automating Tasks with Macros 00:13:23
   2. External Data: Importing, Linking, and Exporting 00:14:46