Volkers Web Site

Disclaimer: This website was last updated in January 2016--MATERIAL MAY BE DATED.

Access 2013 - Intermediate
Last revised: August 2, 2014

Syllabus

Instructor's Notes & Videos  
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 Databasess
Unit 1 YouTube Videos
 
Unit 1 Notes for how to build effective table structures.
Advanced Queries
Unit 2 YouTube Videos
 
Unit 2 Notes on creating simple queries, aggregate queries, parameter queries, update queries and delete queries
Form & Report Wizards
Unit 3 YouTube Videos
 
Unit 3 Notes for how to use Form and Report wizards
Customizing Forms
Unit 4 YouTube Videos
 
Unit 4 Notes for how to customize forms, making data entry simple. Includes showing calculated fields.
Customizing Reports
Unit 5 YouTube Videos
 
Unit 5 Notes for how to customize reports.
Data Integration
Unit 6 YouTube Videos
Unit 6 Notes for how to integrate Access databases with other database programs.

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
Data files for all six units, stored in zip files.
How to Download Student Files How to download and extract (unzip) student files.
How to Compress Assignment Files How to use Windows to compress multiple assignment files into one Zip file.

 
MSTC Stevens Point