Microsoft Access 2007 - Advanced

Start Managing and Manipulating Your Databases

Course Description: Learn advanced techniques to help you manage, search for, and report large amounts of data. This advanced course in Microsoft Access shows you how to set up tables and fields, use forms to enhance data integrity, run queries, and create useful reports.

Author: Ed Brancheau

Runtime: 6hrs. 31min.

Lessons: 42

Lessons	Time (Min:Sec)
Introduction to Relational Database PREVIEW, CLICK HERE	05:12
Data Types PREVIEW, CLICK HERE	05:08
Creating an Attachment Field PREVIEW, CLICK HERE	06:26
Structure Data Input 1	11:19
Structure Data Input 2	13:11
Data Input Validation 1	10:16
Data Input Validation 2	13:15
Create Indexes and Change Sort Order	08:44
Create Relationships Between Tables 1	09:46
Create Relationships Between Tables 2	11:48
Create Forms and Reports with Related Tables	07:54
Create Forms with Subforms 1	09:17
Create Forms with Subforms 2	13:21
Create Forms with Subforms 3	07:42
Create Forms with Special Views 1	10:11
Create Forms with Special Views 2	11:57
Build a Form in Design View 1	08:39
Build a Form in Design View 2	09:33
Add Controls to Forms 1	10:12
Add Controls to Forms 2	14:24
Add Controls to Forms 1	10:36
Add Controls to Forms 4	13:06
Use Advanced Formatting Tools	12:00
Build Report Based on Queries 1	09:41
Build Report Based on Queries 2	12:42
Build Report Based on Queries 3	11:53
Export a Report and Create a Labels Report	14:23
Create a Subreport Using Design Tools	00:57
Create a Subreport in Design View 1	03:08
Create a Subreport in Design View 2	04:16
Create a Subreport Using the subreport wizard 1	12:47
Create a Subreport Using the subreport wizard 2	09:57
Summarize Report Data 1	09:20
Summarize Report Data 2	09:22
Create a Report with an Interactive Filter	14:48
Create a Crosstab Query	05:41
Create a Pivot Table	03:38
Create a Pivot Chart	03:14
Switchboard & Macro	05:56
Mail Merge with Word	06:50
Action Query	14:33
Inner and Outer Joins	03:40