Following are links to videos of a CS101 instructor's in-class Access lectures. They are arranged in the order in which they're covered in class. The in-class videos are excellent for reviewing material, but aren't a substitute for class participation, where you can ask questions and work on in-class examples.
Note: There may be some time- and instructor-specific assignments and dates in the lectures (due dates, bonus point opportunities, homework assignments, etc.). These do not apply to your section and class; please see your instructor or your section-specific CS101 website for this information regarding your section.
| Chapter 1, Part 1 | Definitions and concepts |
| Chapter 1, Part 2 | Interface, opening and navigating existing tables |
| Chapter 1, Part 3 | Adding/editing/deleting records, using existing forms and reports |
| Chapter 1, Part 4 | Using existing queries, filters, sorting tables |
| Chapter 1, Part 5 | Concepts: primary keys, foreign keys, relationships |
| Chapter 1, Part 6 | Creating relationships |
| Chapter 2, Part 1 | Database creation, table design, field types, field properties |
| Chapter 2, Part 2 | Setting primary keys, table/field creation, Design View vs. Datasheet View, field Descriptions |
| Chapter 2, Part 3 | Adding table records, establishing relationships |
| Chapter 2, Part 4 | Creating queries: design view, multi-table queries, execution, datasheet view |
| Chapter 2, Part 5 | Creating a three-table database |
| Chapter 2, Part 6 | Creating lookup and Yes/No fields (other table and same table) |
| Chapter 2, Part 7 | Creating three-table queries, creating and using forms with subforms |
| Chapter 2, Part 8 | Criteria in queries, AND/OR |
| Chapter 2, Part 9 | Sorting query results, wildcards, "Like" keyword, comparison operators, dates in criteria |
| Chapter 3, Part 1 | Calculated query fields: entering in field, expression builder, changing query dataset column width |
| Chapter 3, Part 2 | Total/Aggregate queries (Group By, Sum, Count), aliasing field names |
| Chapter 3, Part 3 | Multiple total/aggregate queries on the same field |
| Other Topics, Part 1 | Importing XML data to tables, composite keys |
| Other Topics, Part 2 | Creating relationships in queries |
| Other Topics, Part 3 | Compact and repair a database |
| Other Topics, Part 4 | Reports, referential integrity, cascade update/delete, exporting to Excel |
| Other Topics, Part 5 | Access vs. Excel, data normalization(first, second, and third normal forms) |
| Other Topics, Part 6 | Switchboards |
| Supplemental Content, Part 1 | SQL: definitions, SELECT statements |
| Supplemental Content, Part 2 | SQL: DDL, DML, JOIN |
| Exam Review | Tables, fields, relationships, primary/foreign/composite keys, forms, reports, queries, importing from XML |