Access - Intermediate
Last revised: August 17, 2010
| 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 |
|
|
Customizing Forms |
|
Unit 3 and Unit 4 Notes for how to customize forms, making data entry simple. Includes showing calculated fields. |
|
|
Customizing Reports |
|
Unit 3 and Unit 5 Notes for how to customize reports. |
|
|
Data Integration |
|
Unit 6 Notes |
| 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 four tutorials, stored in a self-extracting zip file. Copy this file to your computer. Then, double-click the file and tell the extractor where to store your files. |
