Last Updated 4-29-08
| Date |
Lesson |
Homework
(Due by 6pm before next class) |
| Jan-22 |
Syllabus, Web site, Discussion Board, Relational Database Overview, Text Book Layout, Objects, Explore Access Window |
Read Tutorial 1 pages AC1-23, AC33-35, and Appendix AC A23-A24
Homework 1 PDF |
| Jan-29 |
Tutorial 1 - Single Table
Intro. Database Concepts
- Naming Objects and Fields (9)
- Create a Database Table (8-19)
- Primary Key (61)
- Enter Data
- Copy Data from another Table
-
Manipulate Columns
- Print Table
- Compact & Repair (33-35)
- Backing Up & Restoring (35) |
Quiz #1 - Practice Quiz
Homework 2 PDF
Download Provider DB
Read Tutorial 2 pages AC48-81
NEW Read Tutorial 5 pages AC231-239 & AC241-243 |
| Feb-05 |
Tutorial 2 - Two Tables
Session 2.1
- Database Design Guidelines(46-47)
- Field Data Types (48-61) c
-
Field Properties-size, format, caption, others (61-65)c
- Import Excel data into a table (68-71)
- Modify Fields - Move, Insert in middle, Delete (74-79)
- Input Mask (235-239)
- Validation Rule & Text (241-243)
- Lookup Field
(simple list) (slides)
|
Quiz #2 - Tutorial 2
Is available 2/5 - 2/12
Homework 3 PDF
Download Pets.xls
Read Tutorial 2 pages AC46-48, AC81-87, AC244-246 |
| Feb-12 |
Three Tables
- Sort, Find & Replace, Filter
- Import an Access table to make a new table (71-73)
- DB Design
- Design Diagram
- Table Types
- Primary Key using AutoNumber
- Index Field Property (slides)
- Foreign Key (slides) |
Quiz #3 - Design
Is available 2/12 - 2/19
Homework 4-1 PDF
Download Practice.zip, Pets.xls, Adoptions.xls, Customers.xls
Homework 4-2
PDF
Registration Form PDF |
| Feb-19 |
Create Table Relationships
- Relationship Types (81-82)
- Set a Relationship in Access (83-87)
- Relationship View (83-87)
- Print Relationship View (267)
- Referiental Integrity (83)
- Subdatasheets (103)
- Lookup Field (from another table) (231-235)
|
Quiz #4 - Relationships
Is available 2/19 - 2/26
Homework 5 PDF
Download PracticeHW5 DB
Read - see text page numbers to the left |
| Feb-26 |
Relationship Practice
Build a DB in class.
Midterm Q&A |
No Quiz.
Homework: Complete the Midterm Design |
| Mar-04 |
Midterm
Come to class on-time. |
No Quiz.
Bring your Midterm Design to class! |
| Mar-11 |
Spring Break |
n/a |
| Mar-18 |
Class Cancelled |
Read Intro to Queries pages AC104-144 |
| Mar-25 |
Tutorial 3- Intro to Queries (Select Queries) |
Homework 6 PDF
Download Query1 DB
Read Advanced Queries pages AC201-219 and AC226-231 |
| Apr-01 |
Tutorial 5 - Advance Queries (Total Queries) |
Homework 7 PDF
Download Query2 DB
Read Intro to Forms pages AC153-175 & Custom Forms 263-320 |
| Apr-08 |
Tutorial 4 - Intro to Forms
Hand out Final Project
|
Homework 8 PDF
Download Forms1.zip, it contains DB & graphics
Read Intro to Forms pages AC153-175 & Custom Forms 263-320 |
| Apr-15 |
Tutorial 6 - Design Forms |
Homework 9 PDF
Download Forms2.zip, it contains DB & a graphic
Read Reports pages AC 176-189 and AC334-377 |
| Apr-22 |
Tutorial 7 - Reports
Final Project - Optional - Bring your Relationship Diagram to class for me to review. |
Homework 10 PDF
Download Reports.zip, it contains DB & a graphic
Read Tutorial 8 pages AC390-434 |
| Apr-29 |
Letter Report
Export Data
Final Project Q & A/ Workshop - bring your project to class |
Homework #10 - do not hand in.
Work on Project |
| May-06 |
Present Project |
No Homework |