|
Lessons |
Viewing Times |
|
Introduction to Access 2007 |
|
|
Lesson 1:
Introduction to the Environment and to Databases |
6:32 |
|
Lesson 2: Introduction to Tables and Queries |
9:23 |
|
Lesson 3: Introduction to Forms and Reports |
6:31 |
|
Tables |
|
|
Lesson 4: Create Tables in Table View
|
4:22 |
|
Lesson 5: Create Tables in Design View
|
8:16 |
|
With LNC Code Overview
|
|
|
Lesson 6: Modify Tables
|
8:12 |
|
Add/Delete/Modify Fields
Modify Field Properties |
|
|
Lesson 7: Table Relationships |
8:19 |
|
Primary Keys
Create/Delete Joins
Enforce Referential
Integrity |
|
|
Lesson 8: Using Table Records | Sort and Filter Table Data |
5:21 |
|
Enter/Delete/Modify Records
Sort
Filter |
|
|
Queries |
|
|
Lesson 9: Create Queries with the Wizard and in Design View |
4:07 |
|
Lesson 10: Queries: Add/Delete/Rearrange and Sort |
6:22 |
|
Lesson 11: Queries: Criteria Row and OR Row
|
7:37 |
|
Lesson 12: Queries: Show Row and Totals Row
|
5:14 |
|
Lesson 13: Queries: Calculated Fields
|
4:16 |
|
Lesson 14: Queries: Parameter Queries
|
4:38 |
|
Forms |
|
|
Lesson 15: Create Forms with the Wizard
|
4:11 |
|
Lesson 16: Create Forms in Design View
|
3:45 |
|
Lesson 17: Modify Forms |
5:08 |
|
Add/Delete/Rearrange Fields |
|
|
Lesson 18: Use Forms
|
5:09 |
|
View/Edit/Add/Delete
Records |
|
|
Reports |
|
|
Lesson 19: Create Reports with the Wizard |
7:00 |
|
Lesson 20: Create Reports in Design View
|
6:04 |
|
Lesson 21: Modify Reports |
6:08 |
|
Add/Delete/Edit Fields
Move Fields
Grouping and Sorting |
|
|
Lesson 22: Reduce Whitespace, Align Fields and Add Totals |
8:00 |
|
Lesson 23: Keep Groups Together, Format Report and Add Title
|
5:37 |
|
Lesson 24: Calculated Fields |
5:53 |
|
Lesson 25: Use Reports: View in Print Preview |
3:29 |
