Microsoft Access 2007 - Introduction

Learn to Create Your Own Easy-to-Use Databases

Course Description: Control complex tasks by creating and updating database information with Microsoft Access. This introductory course covers the basic concepts in accessing, manipulating, and using database information so you can start putting this powerful program to use.

Author: Ed Brancheau

Runtime: 4hrs. 9min.

Lessons: 41

Lessons	Time (Min:Sec)
Introduction PREVIEW, CLICK HERE	05:46
Add Records to a Table PREVIEW, CLICK HERE	07:02
Rename Fields PREVIEW, CLICK HERE	05:08
Modify the Design of a Table	07:33
Add a Second Table to a Database	06:29
Print a Table	04:03
Create and Use a Query	04:51
Create and Use a Form	02:39
Create and Print a Report	03:59
Close and Save a Database	00:38
Create a Database Using a Template	04:53
Organize Database Objects in the Navigation Pane	03:08
Create a New Table in a Database with a Template	02:44
View a Report	00:30
Use the Access Help System	02:15
Create Table Relationships 1	08:07
Create Table Relationships 2	07:39
Sort Records in a Table	04:06
Create a Query in Design View	07:47
Create a New Query from an Existing Query	03:06
Sort Query Results	04:39
Specify Criteria in a Query	07:14
Create a New Table By Importing a Spreadsheet	07:11
Specify Criteria in a Query	09:52
Use Compound Criteria	07:30
Create a Query Based on More Than One Table	06:44
Use Wildcards in a Query	05:58
Use Calculated Fields in a Query	07:35
Group Data and Calculate Statistics in a Query	05:14
Create a Form	06:45
Use a Form to Add and Delete Records	11:27
Create a Form by using the Form Wizard	05:11
Modify a form in Design View	09:26
Modify a form in Layout View	09:57
Filter Records	07:47
Create a Report by Using the Report Tool	08:33
Create a Report by Using the Blank Report Tool	06:07
Create a Report by Using the Report Wizard	07:18
Modify the Design of a Report 1	10:36
Modify the Design of a Report 2	10:37
Print a Report and Deep Data	03:50