Access 2010 - Intermediate
Last revised: July 28, 2011
| Instructor's Notes | |||
|
Database Design |
|
Unit 1 Notes for how to design adaptable, flexible and accurate relational databases. |
|
|
Database Design Steps |
|
Unit 1 Handy, one-page guide to database design. |
|
|
Building Databases |
|
Unit 1 Notes for how to build effective table structures. |
|
|
Advanced Queries |
|
Unit 2 Notes on creating simple queries, aggregate queries, parameter queries, update queries and delete queries |
|
|
Form & Report Wizards |
|
Unit 3 Notes for how to use Form and Report wizards |
|
|
Customizing Forms |
|
Unit 4 Notes for how to customize forms, making data entry simple. Includes showing calculated fields. |
|
|
Customizing Reports |
|
Unit 5 Notes for how to customize reports. |
|
|
Data Integration |
|
Unit 6 Notes for how to integrate Access databases with other database programs. |
| Recorded Lectures | |||
|
|
No recorded lectures available at this time. | ||
| Assignments | |||
|
|
Advanced Table Design |
|
Unit 1 Assignment |
|
|
Advanced Queries Answer Keys for Tutorial 2 |
|
Unit 2 Assignment |
|
|
Form & Report Wizards |
|
Unit 3 Assignment |
|
|
Custom Forms |
|
Unit 4 Assignment |
|
|
Custom Reports |
|
Unit 5 Assignment |
|
|
Data Integration |
|
Unit 6 Assignment |
| Handouts & Data Files | |||
|
|
Student Files
How to Download Student Files |
|
Data files for all six units, stored in zip files. How to download and extract (unzip) student files. |
