COURSE SCHEDULE

(Last Revised: October 29, 2018)

Disclaimer: The instructor reserves the right to make changes in the course schedule.

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 15 - Sep 24
Introduction to Microsoft Excel
Oct 1 - Oct 22
Introduction to Microsoft Access
Oct 1

Accessing Student Data Files (On / Off-Campus)

  1. Use FILE EXPLORER
    • GO TO the DOWNLOADS folder
    • DELETE everything in the folder before doing the following.
  2. Click on this Link to Google Drive for files.
  3. Log in using your guamcc email address.
  4. Right-click to Download each file.
  5. Open the Downloads folder, Drag the 3 files to your folder.

 

ACCESS PROJECTS- (To be graded in class)

    1. Page AC45 - Review Assignment (#1 - 7) - Create a new blank database and Table Object: VENDOR1
    2. Page AC46 - Case Problem 1 (#1 - 7) - Create a new blank database and Table Object: BEAUTY1

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the file before EMAILING.
  3. EMAIL your completed VENDOR1 and BEAUTY1 as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Access Module 1a
  4. VERIFY with instructor FILE RECEIVED. (Look at the board to see if your email is in my Inbox and has a paperclip icon).

 

 

SLO - Microsoft Access: Module 1a

DEMONSTRATION:

  1. Step-By-Step (to be graded in class):
    • Page AC1 ~ 30 In Class: Step-By-Step Exercises - RIVERVIEW1
Oct 3

Accessing Student Data Files (On / Off-Campus)

  1. Use FILE EXPLORER
    • GO TO the DOWNLOADS folder
    • DELETE everything in the folder before doing the following.
  2. Click on this Link to Google Drive for files.
  3. Log in using your guamcc email address.
  4. Right-click to Download each file.
  5. Open the Downloads folder, Drag the 3 files to your folder.

ACCESS PROJECTS- (To be graded in class)

    1. Page AC105 ~ 106 - Review Assignment (#1 - 7) - Modify a Table Object and Create another Table Object in Design View: VENDOR2
    2. Page AC106 ~ 107- Case Problem 1 (#1 - 7) - Modify a Table Object and Create another Table Object in Design View: BEAUTY2

INSTRUCTIONS:

  1. CALL INSTRUCTOR for grading.
  2. CLOSE the file before EMAILING.
  3. EMAIL your completed VENDOR2 and BEAUTY2 as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Access Module 2a
  4. VERIFY with instructor FILE RECEIVED. (Look at the board to see if your email is in my Inbox and has a paperclip icon).

 

 

SLO - Microsoft Access: Module 2

 

DEMONSTRATION:

  1. Step-By-Step
    • Page AC59 ~ 75 In Class: Step-By-Step Exercises - RIVERVIEW2
Oct 8
**Access Assessment - Table Object**

SLO - Access Assessment - Table Object

  1. Create a Database and Table Objects (See Instructor for handout).
  2. SELF ASSESSMENT: Database Terms & Table Object
  3. INFORMATIONAL VIDEOS provided by GCFLearn.org:
    • Watch VIDEO1: Introduction to Databases (expires on Wednesday, October 10, 2018, at 4:00 pm CST)
    • Watch VIDEO2: Introduction to Objects (expires on Wednesday, October 10, 2018, at 4:00 pm CST)
Oct 10

Accessing Student Data Files (On / Off-Campus)

  1. Use FILE EXPLORER
    • GO TO the DOWNLOADS folder
    • DELETE everything in the folder before doing the following.
  2. Click on this Link to Google Drive for files.
  3. Log in using your guamcc email address.
  4. Right-click to Download each file.
  5. Open the Downloads folder, Drag the 6 files to your folder.

 

 

 

Access Projects (to be graded in class):

  1. Use the Vendor3a database to create 5 Queries.
    1. Import Spreadsheet Data - Supplies (See page AC106 #8)
    2. (Click on the link for the Queries - Vendor3aQueries)
  2. Use the Beauty3a database to create 5 Queries.
    1. Import Text file Data - Customers (See page AC107 #8)
    2. (Click on the link for the Queries - Beauty3aQueries)

INSTRUCTIONS:

  1. EMAIL your completed VENDOR3a and BEAUTY3a as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Access Module 3a

 

SLO - Microsoft Access: Module 3a

 

DEMONSTRATION:

  1. Step-By-Step
Oct 15

Accessing Student Data Files (On / Off-Campus)

  1. Click on this Link to Google Drive for files.
  2. Log in using your guamcc email address.
  3. Right-click to Download each file.
  4. Open the Downloads folder, Drag the 2 files to your folder.

 

Access Projects (to be graded in class):

  1. Use the Vendor3b to completed the following:
    • Create a One-To-Many relationship between the Product and Supplier table using the SupplierID as the Common Field.
    • Select the Referential Integrity Option
    • Select Cascade Updates Options for the Relationship.
    • Save and Close the Relationship window.
  2. Continue using Vendor3b file to complete:
    • Page AC171 - Review Assignment (#1 - 11)- Create Multi-Table Queries

INSTRUCTIONS:

  1. EMAIL your completed VENDOR3b as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Access Module 3b

 

SLO - Microsoft Access: Module 3b

 

DEMONSTRATION:

  1. Step-By-Step Exercises: Riverview 3b
    • Page AC100 ~ 103 Creating a Table Relationship
    • Page AC150 ~ 155 Creating Multi Criteria Queries using AND and OR operator
    • Page AC157 ~ 160 Create a Calculated Field
Oct 17
**Access Assessment - Query Object**
 Access Query Assessment (to be graded in class):
  1. Query Online Assessment
  2. Use the Personnel database.
  3. Use the Zillow database.

AFTER you complete the above Query Assessments

INFORMATIONAL VIDEOS provided by GCFLearn.org:

  1. Watch VIDEO3: Introduction to the Database - Form Object (Expires on Monday, October 22, 2018, at 2:00 pm CST)
  2. Watch VIDEO4: Introduction to the Database - Report Object (Expires on Monday, October 22, 2018, at 2:00 pm CST)
Accessing Student Data Files (On / Off-Campus)
  1. Click on this Link to Google Drive for files.
  2. Log in using your guamcc email address.
  3. Right-click to Download each file.
  4. Open the Downloads folder, Drag the 2 files to your folder.
Oct 22

Accessing Student Data Files (On / Off-Campus)

  1. Click on this Link to Google Drive for file.
  2. Log in using your guamcc email address.
  3. Right-click to Download each file.
  4. Open the Downloads folder, Drag the files to your folder.

 

 

Access Projects (to be graded in class):

  1. LAB: Use the Riverview4 to complete the following:
    • Page AC182 ~ 192 Creating a Form Object and Navigating a Form
    • Page AC200 ~ 203 Creating a Form and a Sub Form
    • Page AC208 ~ 217 Creating a Report Object
  2. TAKE THE ACCESS TERMS SELF ASSESSMENT: (Expires on Wednesday, October 24, 2018, at 12:00 pm CST)

INSTRUCTIONS:

  1. EMAIL your completed RIVERVIEW4 as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Access Module 4

SLO - Microsoft Access: Module 4a

 

SLO - Microsoft Access: Module 4b
Oct 24  
Oct 29
**Access Assessment**

Access Assessment:

  1. Access Terms
  2. Exercise: Everyday Databases

© 2018 Yvonne C. Flores, Guam Community College