Video description

Master Access 2013 on your terms with this one-of-a-kind video training course Access 2013 is Microsoft's database management software that allows users to enter, manage, and build reports on large amounts of data. Our instructors provide expert, straight-forward, user-friendly training to help you tackle Access 2013 the way you want to learn. Get to know the Access work environment, master tables, DataFields, and Datatypes Understand queries and create a simple select query Build a simple UI with forms Create simple reports and automate tasks with macros Includes over 9 hours of Access 2013 video training If you're looking for real-world Access 2013 instruction, you'll find it here. Lesson files for this course can be found here http://www.wiley.com/WileyCDA/Section/id-826020.html

---

Table of Contents

Lesson 1

What Is Access? 00:13:48

The Office 2013 Environment 00:10:55

The Access Work Environment 00:15:38

Tables 00:13:48

Views 00:17:57

Forms 00:10:10

Queries 00:13:17

Reports 00:08:36

Relationships 00:12:03

Lesson 2

Fields, Records, Datatypes, Data 00:21:02

Data Entry 00:13:50

The Datasheet View 00:13:20

Sorting, Filtering, and Totals 00:09:24

The Design View 00:17:00

AutoNumber and Primary Keys 00:07:56

Creating and Editing Relationships 00:15:05

Relationships: Referential Integrity 00:06:23

Input Masks and Validation 00:22:15

Using Lookups 00:08:47

Lesson 3

Creating a Simple Select Query 00:19:06

Grouping and Calculated Fields 00:11:00

Functions, Expressions 00:15:05

Joining Tables with Queries 00:15:40

Action Queries and Parameters 00:20:38

Crosstabs and Totals Queries 00:13:20

SQL: Access’s Hidden Engine 00:09:19

Lesson 4

Building a Simple UI with Forms 00:13:30

Form Layout 00:14:29

Form Design 00:19:15

Adding Controls to a Form UI 00:18:31

Sorting and Filtering with Forms 00:07:54

Getting More Complex: Subforms, Split Forms, and Validation 00:12:46

Navigation Forms and More Subforms 00:14:23

Lesson 5

Creating Simple Reports 00:09:22

Using Expressions in a Report 00:06:41

Grouping and Sorting 00:16:09

Report Layout and Formatting 00:22:11

The Design View 00:22:39

Lesson 6

Automating Tasks with Macros 00:13:23

External Data: Importing, Linking, and Exporting 00:14:46