Table of contents

Introduction

Welcome

0:47

0.9 MB

1. Getting Started with Access

Database concepts and terminology	10:12	17.4 MB
Starting Access	5:15	7.5 MB
The Getting Started window	4:42	6.8 MB
The Quick Access toolbar	3:51	6.7 MB
Opening an existing Access database	2:51	5.2 MB
The work environment	9:38	14.4 MB
Customizing the Access environment	6:48	11.2 MB

2. Creating Databases and Tables

Planning and designing databases	2:38	2.7 MB
Working with fields	5:31	3.9 MB
Choosing keys	3:42	2.8 MB
Creating tables	3:10	4.5 MB
Creating fields	6:30	6.6 MB
Working with records	5:05	5.6 MB
Working with data	7:15	9.8 MB
Checking spelling	5:32	7.4 MB

3. Working with Fields and Records

Modifying table design	6:08	8.6 MB
Finding and editing records	3:39	5.3 MB
Organizing and sorting records	4:58	7.4 MB

4. Creating Data Entry Rules

Setting field properties	5:32	7.3 MB
Using input masks	5:36	7.3 MB
Setting validation rules	8:26	12.4 MB

5. Relational Database Techniques

Creating key fields	4:56	6.6 MB
Creating table relationships	5:58	7.2 MB
Enforcing referential integrity	4:17	4.8 MB
Using subdatasheets	4:24	5.5 MB

6. Working with Queries

Creating a query using the wizard	5:15	6.3 MB
Creating a query from scratch	6:34	8.3 MB
Modifying a query in Design view	4:41	5.7 MB
Performing calculations on a group of records	2:37	3.2 MB
Creating flexible queries	7:27	9.7 MB

7. Working with Forms

Introduction to forms	2:08	1.9 MB
Creating forms with the Form wizard	6:27	7.2 MB
Creating forms from the Design view	5:00	6.3 MB
Modifying a form's design	8:09	15.8 MB
Creating subforms	6:19	9.9 MB
Adding command buttons to a form	5:57	9.4 MB
Sorting and filtering with forms	6:17	8.1 MB
Switchboards vs. the Navigation pane	11:20	16.7 MB

8. Working with Reports

Using the Report wizard	6:09	7.5 MB
Modifying reports in Design view	7:30	12.8 MB
Adding custom calculated fields to a report	7:11	11.1 MB
Formatting reports	9:49	17.3 MB
Summarizing report information	7:58	12.3 MB
Creating a mailing label report	6:26	8.9 MB
Printing reports	4:34	6.9 MB

9. Working with Macros

Creating macros	4:57	6.2 MB
Attaching macros	5:01	8.1 MB
Automating data entry with macros	7:49	10.1 MB
Validating data with macros	7:16	9.3 MB
Creating auto-executing macros	2:55	3.5 MB

10. Sharing Data with Word and Excel

Importing data into Access	6:14	8.7 MB
Using Package and Sign	5:28	8 MB
Sharing via email	4:29	6.7 MB
Exporting data to Excel	4:37	7.8 MB

11. Working with Charts

Working with charts	7:14	14.3 MB
Working with pivot charts	5:21	7.4 MB