| Day 1 |
March 9 |
| Objective |
Database in Microsoft Access |
| Opening Activity |
Obtain and answer e-mail |
| Presentation of Material |
Joining tables, restricting
records in a join, using computed fields, calculating stats, using criteria in calculated
statistics, grouping, saving a query, adding, changing, deleting, search for a record,
update field contents, switching from form to data views, using update query, use query to
delete record |
| Guided Practice |
Office 95 Introductory Book
A2.23 |
| Notes/Materials |
|
|
Homework |
|
| Day 2 |
March 10 |
| Objective |
Database in Microsoft Access |
| Opening Activity |
Obtain and answer e-mail |
| Presentation of Material |
Add new field, updating,
resize a column, using update query, use query to delete records, creating validation
rules, specify range, specify default value, specify format, save, update table with
validation rules, make individual changes, specify referential integrity, ordering
records, creating and using indices |
| Guided Practice |
Office 95 Introductory Book
A3.4 |
| Notes/Materials |
|
|
Homework |
|
| Day 3 (Block) |
March 11 |
| Objective |
Database in Microsoft Access |
| Opening Activity |
Obtain and answer e-mail |
| Presentation of Material |
Creating a report: using
design view, report sections, changing properties, printing a report |
| Guided Practice |
Office 95 Introductory Book
A4.6 |
| Notes/Materials |
timed writings, turn in
printed report, turn in advanced database vocabulary definitions |
|
Homework |
|
| Day 4 |
March 13 |
|
Objective |
Database in Microsoft Access |
|
Opening Activity |
Obtain and answer e-mail |
|
Presentation of Material |
Grouping in a report:
creating the query, creating a second report, reviewing the report design, removing
unwanted controls, enlarging the page header section, changing column headings, previewing
the report, printing the report |
|
Guided Practice |
Office 95 Introductory Book
A4.2 |
|
Notes/Materials |
|
|
Homework |
|