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 (Part 1)		08:07
Create Table Relationships (Part 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 Text Criteria in a Query		07:14
Create a New Table by Importing a Spreadsheet		07:11
Specify Numeric 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 (Part 1)		10:36
Modify the Design of a Report (Part 2)		10:37
Print a Report and Keep Data		03:50

Address Page

To access this lesson, you need to log in to your account.

Enter your username and password in the boxes at the top right corner of this page.