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.
|
Jan
9 - Feb 13 |
|
Feb
18- Mar 20 |
Introduction
to Microsoft Access
|
Feb
18 |
**WARNING**
- The
Access Modules are PROGRESSIVE.
- The
Riverview1, Vendor1, Beauty1 files in this module need to be created
in order to do Access Module2, Access Module3, and Access Module 4.
- Look
at the schedule below, **DO NOT** miss
class for any assessment.
|
LESSON
OBJECTIVES
WATCH
THE FOLLOWING VIDEOS provided by GCFLearnFree.org
- In
Google Drive,
- create
a folder for CS151-##,
- open
the CS151 folder, create the following subfolder
|
Accessing
Student Data Files (On Campus)
- The
following files are used for DEMONSTRATION only
- FILES
are located in the CS151 FOLDER.
- FOLDER
1: CS151\Access\
- DRAG
Access1 folder to your
folder on the Desktop
|
LESSON
OBJECTIVES
- SLO
- Microsoft Access: Module 1
- Demonstrate
creating a Table Object using the Table button.
|
ACCESS
PROJECTS- (To be graded in class)
- PRACTICE:
Page AC 8 ~ 30
- Create
a new blank database named Riverview1 (followed
your initials)
- and
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)
- and
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)
- and
inside the database Create a Table Object saved as Option
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files.
- DRAG
the 3 files (Riverview1, Vendor1, Beauty1)
to your Google Drive CS151/Access Module 1
folder.
- SHARE
your CS151/Access Module 1 folder with me.
- Right-click
on the Access Module 1 folder
-
click Share
-
enter my email address: yvonne.flores@guamcc.edu
- Look
at the board to see if your email is in my Inbox.
|
Feb
20 |
**WARNING**
- The
Access Modules are PROGRESSIVE.
- You
need to do the Access Module 1 assessment from Feb 18 before proceeding.
- Look
at the schedule below, **DO NOT** miss
class for any assessment.
|
ACCESS
PROJECTS- (To be graded in class)
- PRACTICE:
Page AC 59~ 78
- Page
AC105 ~ 106 - Review Assignment (#1 - 7) - Modify a Table
Object and Create another Table Object in Design View: Use
Vendor2
- Page
AC106 ~ 107- Case Problem 1 (#1 - 7) - Modify a Table Object
and Create another Table Object in Design View:
Use Beauty2
|
Accessing
Student Data Files (On / Off-Campus)
- Log
in to your Email, go to your Google Drive.
- DOWNLOAD
- Riverview1,
Vendor1, Beauty1 from the previous lesson
-
to your folder on the Desktop.
- RENAME
- Riverview1
to Riverview2
- Vendor1
to Vendor2
- Beauty1
to Beauty2
|
LESSON
OBJECTIVES
- SLO
- Microsoft Access: Module 2
- Demonstrate
creating a Table Object using the Table Design button.
- Watch
VIDEO1: Introduction to Databases (Click on Link)
- Watch
VIDEO2: Introduction to Objects (Click on Link)
- TABLE
Object
|
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files.
- In
Google Drive, create Access Module 2
folder.
- DRAG
the 3 files (Riverview2, Vendor2)
to your Google Drive CS151/Access Module 2
folder.
- SHARE
your CS151/Access Module 2 folder with me.
- Right-click
on the Access Module 2folder
-
click Share
-
enter my email address: yvonne.flores@guamcc.edu
- Look
at the board to see if your email is in my Inbox.
|
Feb
25 |
|
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files.
- In
Google Drive, create Access Assessment
folder.
- DRAG
the Condo Rentals file to your Google
Drive Access Assessment folder.
- SHARE
your Access Assessment folder with me.
- Right-click
on the Access Assessment folder
-
click Share
-
enter my email address: yvonne.flores@guamcc.edu
- Look
at the board to see if your email is in my Inbox.
- Delete
your folder, Empty your Recycle Bin
|
Feb
27 |
Accessing
Student Data Files (On / Off-Campus)
- In
your CS151 Google Drive folder, create a Access
Module 3 folder.
- Click
on this Link to DOWNLOAD files.
- Log
in using your guamcc email address.
- Right-click
to Download each file.(The files are downloaded
to the Downloads folder.)
- Open
the Downloads folder, Drag the 2 files to your folder.
|
ACCESS
PROJECTS- (To be graded in class)
- Click
on this Link to DOWNLOAD files.
- Log
in using your guamcc email address.
- Right-click
to Download each file.(The files are downloaded
to the Downloads folder.)
- Open
the Downloads folder, Drag the 2 files to your folder.
- (Click
on the link for the Queries - Module3aQueries)
- Use
the Vendor3a database to create 5 Queries.
- Use
the Beauty3a database to create 5 Queries.
|
LESSON
OBJECTIVES
QUERY
Object
- Did
you watch Video5?
- SLO
- Microsoft Access: Module 3a
- Demonstrate
creating a Query Object using the Query Design button.
- STEP-BY-STEP
- Import
Spreadsheet Data - Invoices (See page AC80-83)
- PRACTICE
( Click on the link for the Queries - Riverview3aQueries)
|
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- DRAG
the 2 files (Vendor3a, Beauty3a)
to your Google Drive Access Module 3
folder.
- SHARE
your folder.
- Watch
VIDEO6: Designing a Multi-Table Query (Click on Link)
|
Mar
4 |
**HOLIDAY
- Guam History & Chamorro Heritage Day**
|
Mar
6 |
Accessing
Student Data Files (On / Off-Campus)
- Click
on this Link to DOWNLOAD files.
- Log
in using your guamcc email address.
- Right-click
to Download each file.(The files are downloaded
to the Downloads folder.)
- Open
the Downloads folder, Riverview3b and
Vendor 3b to your folder.
|
ACCESS
PROJECTS- (To be graded in class)
- Use
the Vendor3b to complete the following:
- Create
a One-To-Many relationship between the Product
and Supplier table using the SupplierID
as the Common Field.
- Check
Referential Integrity Option
- Check
Cascade Update Related Fields
- Save
and Close the Relationship window.
- (Click
on the link for the Queries - Module3bMultiQueries)
- Use
the Vendor3b database to create 4 Queries.
|
LESSON
OBJECTIVES
QUERY
Object
- Did
you watch Video6?
- SLO
- Microsoft Access: Module 3b
- Demonstrate
creating a Query Object using the Query Design button.
- STEP-BY-STEP
DEMONSTRATION:
- Page
AC100 ~ 103 Creating a Table Relationship
- Page
AC150 ~ 155 Creating Multi-Table / Multi-Criteria
Queries using AND and OR
operator
|
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- DRAG
the 2 files (Riverview 3b, Vendor3b) to
your Google Drive Access Module 3 folder.
- SHARE
your folder.
- Self-Assessment
- CLICK to TEST YOUR Access Module 1 Terms
- Self-Assessment
- CLICK to TEST YOUR Access Module 2 Terms
- Self-Assessment
- CLICK to TEST YOUR Access Module 3 Terms
- Watch
VIDEO7: Work with Forms (Click on Link)
- Watch
VIDEO8: Work with Reports (Click on Link)
|
Mar
11 |
Accessing
Student Data Files (On / Off-Campus)
- Click
on this Link to Google Drive for file.
- Log
in using your guamcc email address.
- Right-click
to Download the 2 files.
- Open
the Downloads folder, Drag the 2 files to your folder.
|
ACCESS
PROJECTS- (To be graded in class)
- LAB:
Use the Riverview4 to complete the following:
- Page
AC182 ~ 192 Creating a Form Object and Navigating a Form
- Page
AC198 (Switch to Form View) - Add a New Record (see the picture)
- Page
AC200 ~ 203 Creating a Form and a Sub Form
- TAKE
THE ACCESS TERMS SELF ASSESSMENT: (Expires on Wednesday, March 13, 2019,
at 10:00 am ChST)
- Self-Assessment
- CLICK to TEST YOUR Access Module 4 Terms
|
|
LESSON
OBJECTIVES
FORM
and REPORT Object
- Did
you watch Video 7 and 8
- SLO
- Microsoft Access: Module 4a
- Demonstrate
creating a Form Object using the Form Tool
- SLO
- Microsoft Access: Module 4b
- Demonstrate
creating a Report Object using the Report Wizard (Page
AC208 ~ 217 Creating a Report Object)
|
INSTRUCTIONS:
- CALL
INSTRUCTOR for grading.
- CLOSE
the files.
- In
Google Drive, create Access Module 4
folder.
- DRAG
Riverview4.
- SHARE
Access Module 4 folder with me.
|
Mar
13 |
**Access
Assessment on
Queries, Forms, Reports, Database
Terms and Everyday Databases **
(NO
Makeup unless PRIOR arrangements are made)
|
Access
Assessment:
- Part1:
Access Terms
- Part2:
Everyday Databases
|