Access - Beginning
Last revised: August 17, 2010
| Instructor's Notes | |||
|
Tutorial 1 - Database Basics |
|
Instructor's abbreviated notes for Tutorial 1 |
|
|
Tutorial 2 - Building a Database |
|
Instructor's abbreviated notes for Tutorial 2 |
|
|
Tutorial 3 - Querying a Database |
|
Instructor's abbreviated notes for Tutorial 3 |
|
|
Tutorial 4 - Creating Forms & Reports |
|
Instructor's abbreviated notes for Tutorial 4 |
| Recorded Lectures | |||
|
|
Tutorial 1 - Access (Database) Concepts | ||
Part 1
|
Database concepts, creating a database, creating a simple table, changing data types | ||
|
Part 2
|
Importing data, simple query wizard, quick form, quick report | ||
|
|
Tutorial 2 - Creating Database Tables | ||
|
Part 1
|
Database concept review, creating a table in design view, field names, field types | ||
|
Part 2
|
Field properties, entering data, modifying a table's structure | ||
|
Part 3
|
Review; moving, adding, deleting fields; editting data, deleting records; linking tables, referential integrity | ||
|
|
Tutorial 3 - Creating and Running Queries | ||
|
Part 1
|
Finding records, using datasheet view to sort, using datasheet view to filter, creating a query in design view, selecting query fields, designating sort order, sorting on more than one field, basic selection criteria | ||
|
Part 2
|
Review, query criteria, multi-criteria queries | ||
|
Part 3
|
Calculated fields, concatenated fields, aggregate queries | ||
| Assignments | |||
|
|
Tutorial 1 Assignment |
|
Assignment sheet for Tutorial 1 |
|
|
Tutorial 2 Assignment |
|
Assignment sheet for Tutorial 2 |
|
|
Tutorial 3 Assignment Answer Keys for Tutorial 3 |
|
Assignment sheet for Tutorial 3 |
|
|
Tutorial 4 Assignment |
|
Assignment sheet for Tutorial 4 |
| Handouts & Data Files | |||
|
|
Competency Checklist |
|
List of competencies (skills) gained in this course, presented by tutorials |
|
|
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. |
