Microsoft Access 2010 Introduction

Organize Your Data and Create Your Own Databases

Course Description: Explore the basics of database creation and management in this introductory Access 2010 course. Learn how to perform the daily tasks associated with any database, including creating databases, tables, forms, and reports. Learn how to filter records, as well as search your database with effective queries.

Author: Irasema Perrot

Runtime: 4hrs. 57min.

Lessons: 89

Lessons		Time (Min:Sec)
Introduction PREVIEW, CLICK HERE		00:55
Chapter 1: What Is a Database?
Overview PREVIEW, CLICK HERE		00:21
Databases PREVIEW, CLICK HERE		00:40
Tables		00:42
Queries		00:14
Forms		00:16
Reports		00:21
Macros		00:12
Modules		00:10
Chapter 2: Navigating the Workspace
Overview		00:20
Access Objects		03:32
Searching for Access Objects		00:59
Deleting Access Objects		01:55
Access Ribbons		03:28
Help Feature		02:14
Chapter 3: Creating a Database
Overview		00:12
Table Components		01:24
Planning the Tables		03:28
Creating the Table		10:15
Editing the Table		03:22
Entering Table Data		02:22
DataTypes		03:16
Table Templates		05:42
Template Pros and Cons		01:48
Chapter 4: Working with Tables
Overview		00:24
Table Design		03:19
Importing from Excel		06:14
Printing Tables		01:00
Relating Tables		06:25
Referential Integrity		02:11
Adding and Deleting Tables		03:47
Navigating Through Tables		02:04
Exporting to Excel		01:24
Exporting to Text Files		00:56
Exporting to PDF		01:04
Emailing Tables		00:57
Exporting to Word		01:19
More Export Options		01:55
Chapter 5: Finding, Sorting, & Filtering Data
Overview		00:12
Finding Data		04:00
Sorting Data		01:34
Filtering Data		04:53
Chapter 6: Working with Queries
Overview		00:34
Creating in Design View		04:39
Sorting Query Information		05:15
Creating from Existing Queries		02:02
Queries with And Conditions		02:20
Queries with Or Conditions		04:54
Multiple Or		02:08
Specifying Numeric Criteria		04:04
Numeric Ranges		03:19
Grouping Data		03:35
Calculated Fields		03:50
Mathematical Queries Exercise		07:44
Multi-Table Queries (Part 1)		11:04
Multi-Table Queries (Part 2)		04:00
Date Ranges Exercise		03:03
Searching for Empty Fields		02:38
Finding Unmatched Records		03:54
Exporting Queries		01:24
Chapter 7: Working with Forms
Overview		00:34
Importing from Previous Access Versions		04:41
The Form Wizard		07:51
Modifying the Form		15:50
Form Design		10:07
Additional Modifying Techniques		04:17
Logos and Background		05:25
More Forms Tool		03:57
Quick Form Tool		02:45
Chapter 8: Working with Reports
Overview		00:41
The Report Tool		06:14
Report Design		09:41
Report Design in Layout View		06:35
Blank Report		04:37
Creating Reports from Queries (Part 1)		09:30
Creating Reports from Queries (Part 2)		04:28
Creating Reports from Queries (Part 3)		07:09
Creating Reports from Queries (Part 4)		08:33
Formatting Controls		03:39
The Format Painter		01:55
Using Themes		02:05
Creating Labels		03:35
Printing Reports		01:43
Exporting to Excel		02:23
Exporting to Text Files		01:57
Exporting to PDF		01:29
Emailing Reports		01:05
Exporting to Word		00:57
Conclusion		01:20