Date
|
Lesson
/ Step-By-Step Exercises
|
End-Of
Lesson/Unit Projects
|
|
Step-By-Step
Exercises will be DEMONSTRATED in class. Mastery of the software requires
PRACTICE. |
**ALL
PROJECTS are to be COMPLETED IN CLASS and DUE on the day assigned.
|
Aug
20 - Sep 17 |
|
Sep
19 - Oct 15 |
|
Oct
17 - Nov 7 |
Introduction
to Microsoft Access
|
Oct
17 |
Accessing
Student Data Files (On Campus)
- ON-CAMPUS
- CS151
/ Access / Access 1 folder
- Files
do not exist, they need to be created.
- Folder
only contains information to copy from one database to another database.
|
ACCESS
PROJECTS- (To be graded in class)
- IN-CLASS
DEMONSTRATION:
Access1 Folder / Module Folder - (Page
AC8 ~ 30)
- Create
a new blank database named Riverview1 (followed
your initials)
- Inside
the database Create a Table Object saved as Visit
- Page
AC45 - Review Assignment (#1 - 7)
- Create
a new blank database named Vendor1 (followed
your initials)
- Inside
the database Create a Table Object saved as Supplier
- Page
AC46 - Case Problem 1 (#1 - 7)
- Create
a new blank database named Beauty1 (followed
by your initials)
- Inside
the database Create a Table Object saved as Option
|
Accessing
Student Data Files (Off-Campus)
- OFF-CAMPUS
- Click
on this Link to Google Drive for files.
- Files
do not exist, they need to be created.
- The
3 files only contain information to copy from one database to another
database.
|
LESSON
OBJECTIVES
- SLO
- Microsoft Access: Module 1
- Create
a Table Object using the Table button.
|
Oct
22 |
Accessing
Student Data Files
- ON
/ OFF-CAMPUS - Click
on this Link to Google Drive for files.
|
ACCESS
PROJECTS- (To be graded in class)
- Right-click
on Vendor2 (ADD your initials to the
file name).
- IN-CLASS
DEMONSTRATION:
Open PRACTICE - Riverview2 - (Page
AC59 ~ 78)
- Page
AC105 ~ 106 - Review Assignment (#1 - 7)
- Open
Vendor2,
Modify a Table Object and Create another Table Object in Design
View.
|
LESSON
OBJECTIVES
- Self-Assessment
- CLICK to TEST YOUR Access Module 1 Terms
- SLO
- Microsoft Access: Module 2
- Create
a Table Object using the Table Design button.
|
Oct
24 |
Accessing
Student Data Files
- ON
/ OFF-CAMPUS - Click
on this Link to Google Drive for files.
|
ACCESS
PROJECTS- (To be graded in class)
- IN-CLASS
DEMONSTRATION - Importing:
Open PRACTICE - Riverview3a - (Page
AC80 ~ 83)
- IN-CLASS
DEMONSTRATION - Create a Query:
(Page AC124 ~ 139)
- PROJECT
- Use the Vendor3a database to create 5
Queries (Click
on the Link)
- PROJECT
- Use the Beauty3a database to create 5
Queries
(Click
on the Link)
|
LESSON
OBJECTIVES
- Self-Assessment
- CLICK to TEST YOUR Access Module 2 Terms
- SLO
- Microsoft Access: Module 3a
|
Oct
29 |
Accessing
Student Data Files
- ON
/ OFF-CAMPUS - Click
on this Link to Google Drive for files.
|
ACCESS
PROJECTS- (To be graded in class)
- IN-CLASS
DEMONSTRATION -
Open PRACTICE - Riverview3b
- Creating
a Table Relationship (Page AC100 ~ 103)
- Creating
a Multi-Table / Multi-Criteria Criteria Queries
-
using AND or OR operator (Page AC150 ~ 155)
- PROJECT
- Use the Vendor3b database to create 4
Queries (Click
on the Link)
- PROJECT
- Use the Beauty3b database to create 3
Queries (Click
on the Link)
|
LESSON
OBJECTIVES
- Self-Assessment
- CLICK to TEST YOUR Access Module 3 Terms
- SLO
- Microsoft Access: Module 3b
|
Oct
31 |
**Check
your Email**
|
Nov
5 |
Accessing
Student Data Files
- ON
/ OFF-CAMPUS - Click
on this Link to Google Drive for files.
|
ACCESS
PROJECTS- (To be graded in class)
- IN-CLASS
DEMONSTRATION -
Open PRACTICE - Riverview4a
- Creating
a Form Object Using the Form Wizard (Page AC182 ~ 192)
- PROJECT
- Use the Vendor4a database. (Page AC 223
#1 - 12)
- PROJECT
- Use the Beauty4a database. (Page AC 225
#1 - 11)
|
LESSON
OBJECTIVES
- SLO
- Microsoft Access: Module 4a
- Self-Assessment
- CLICK to TEST YOUR Access Module 4 Terms
|
Nov
7 |
Accessing
Student Data Files
- ON
/ OFF-CAMPUS - Click
on this Link to Google Drive for files.
|
ACCESS
PROJECTS- (To be graded in class)
- LAB
-
Open Riverview4b
- Creating
a Report Object Using the Report Wizard (Page AC208 ~ 220)
|
LESSON
OBJECTIVES
- SLO
- Microsoft Access: Module 4b
|
Nov
12 |
Part
1 - HANDS-ON: Click
on this Link to Google Drive to download 4 files
Part
2 - ONLINE
ASSESSMENT
|
**Access
Mastery Assessment**
(REMINDER:
As stated in the syllabus, ***NO MAKEUP*** will be allowed unless PRIOR
arrangements are made.)
|