MSAccess Teaching Plan

Appendix H: Subject/Module Outline for each Subject or Module in a Program

Time,	Main Topic	Relative
hours	Sub-Topics	Value in %	Date
4	Lesson 1: Create Database Tables (pages 1056-1074)	16
0.5	1. Working in the Access Window		July 07
0.5	2. Defining Data Needs and Types
0.5	3. Creating a Database
0.5	4. Creating a Database Table
0.5	5. Saving a Database Object
	Assignment 1: Student Information
1.5	6. Assessment
	Knowledge Assessment
	Matching (page 1052)
	True/False (page 1052)
	Competency Assessment
	Project 1: Task List
	Project 2: Database Views
	Proficiency Assessment
	Project 3: Understanding Database Design (page 1053-1054)
	Project 4: Planning Table Fields (page 1054)
	Mastery Assessment
	Project 5: Planning Data Types for Fields (page 1054)
	Assignment 2: Blank Database XXX
	Knowledge Assessment
	Fill in the Blank (page 1070)
	Multiple Choice (pages 1071-1072)
	Competency Assessment
	Project 1: Contacts Database (page 1072)
	Project 2: Database for Restaurants (page 1072)
	Proficiency Assessment
	Project 3: Adding Tables (page 1073)
	Project 4: Nutrition Tracker (page 1073)
Time,	Main Topic	Relative
hours	Sub-Topics	Value in %
	Mastery Assessment
	Project 5: Northwind Traders (page 1073)
	Project 6: Customer Service Database (page 1074)
4	Lesson 2: Work with Tables/Database Records (pages 1075-1103)	16	July 07-08
0.5	1. Entering, Editing, and Deleting Records
0.5	2. Finding and Replacing Data
0.5	3. Sorting and Filtering Data within a Table
0.5	4. Creating and Modifying Primary Keys
0.5	5. Table Relationships
	Assignment 1: Fourth Coffee XXX
1.5	6.Assessment
	Knowledge Assessment
	Matching (page 1099)
	True/False (pages 1100)
	Competency Assessment
	Project 1: Charity Event Contact List (page 1100)
	Project 2: Angels Project Wish List (page 1101)
	Proficiency Assessment
	Project 3: Angels Project Contact Information (page 1101)
	Project 4: Wingtip Toys Inventory Table (page 1102)
	Mastery Assessment
	Project 5: Soccer Roster (pages 1102-1103)
	Project 6: Donations Table (page 1103)
4	Lesson 3: Modifying Tables and Fields (pages 1104-1127)	16
0.6	1. Modifying a Database Table		July 08
0.6	2. Renaming and Deleting Tables
0.6	3. Creating and Deleting Fields
0.7	4. Modifying Table and Field Properties
	Assignment 1: Events (pages 795-818)
1.5	5.Assessment
	Knowledge Assessment
Time,	Main Topic	Relative
hours	Sub-Topics	Value in %
	Fill in the Blank (pages 1122)
	Multiple Choice (pages 1123)
	Competency Assessment
	Project 1: Home Inventory (page 1124)
	Project 2: Customer Service (page 1124)
	Proficiency Assessment
	Project 3: Modify Field Properties (pages 1125)
	Project 4: Modify Database Tables (page 1125-1126)
	Mastery Assessment
	Project 5: Changing List Items (page 1126)
	Project 6: Lending Library (page 1126)
4	Lesson 4: Create Forms (pages 1128-1149)	16	July 09
0.6	1. Creating a Form in Design View
0.6	2. Applying an AutoFormat
0.6	3. Sorting Data within a Form
0.7	4. Filtering Data within a Form
	Assignment 1: Graphic Art XXX
1.5	5.Assessment
	Knowledge Assessment
	Matching (page 1145)
	True/False (page 1146)
	Competency Assessment
	Project 1: Form Wizard (page 1146)
	Project 2: Used games Forms (pages 1146-1147)
	Proficiency Assessment
	Project 3: Sort and Filter Games (page 1147)
	Project 4: Toy Inventory (pages 1147-1148)
	Mastery Assessment
	Project 5: Red Wines (page 1148)
	Project 6: Personal Contacts (page 1149)
4	Lesson 5: Create Reports (pages 1150-1170)	16
			July 09
Time,	Main Topic	Relative
hours	Sub-Topics	Value in %
0.6	1. Creating a Report in Design View
0.6	2. Applying an AutoFormat
0.6	3. Sorting Data within a Report
0.7	4. Filtering Data within a Report
	Assignment 1: Alpine Ski House XXX
1.5	5.Assessment
	Knowledge Assessment
	Matching (page 1166)
	True/False (page 1167)
	Competency Assessment
	Project 1: Soccer Team Report (page 1167)
	Project 2: Fourth Coffee Inventory Report (page 1167-1168)
	Proficiency Assessment
	Project 3: Alpine Ski House Reservations Report (page 1168)
	Project 4: Wingtip Toys Design View Report (page 1168-1169)
	Mastery Assessment
	Project 5: Filter and Sort a Wingtip Toys Report (page 1169)
	Project 6: Angel Project Report (page 1170)
4	Lesson 6: Create and Modify Queries (pages 1171-1207)	16	July 10
0.5	1. Creating a Query from a Table
0.5	2. Creating a Query from Multiple Tables
0.5	3. Modifying a Query
0.5	4. Adding Criteria to a Query
0.5	5. Sorting and Filtering Data within a Query
	Assignment 1: Northwind XXX (pages 872-893)
1.5	6.Assessment
	Knowledge Assessment
	Fill in the Blank (page 1188)
	Multiple Choice (pages 1188-1189)
	Competency Assessment
	Project 1: Create a Games Select Query (page 1190)
Time,	Main Topic	Relative
hours	Sub-Topics	Value in %
	Project 2: Create and Find Duplicates Query (page 1190)
	Proficiency Assessment
	Project 3: Create a Query (page 1191)
	Project 4: Creating Parameter Queries (page 1191)
	Mastery Assessment
	Project 5: Create a Query (page 1192)
	Project 6: Create a Parameter Query (page 1192)
1	Exam: Club’s Database	4	July 11