COURSE SCHEDULE

(Last Revised: April 2, 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.

 

Feb 21 - Apr 2
Introduction to Microsoft Access
Feb 21

SLO - Microsoft Access: Module 1a

 

DOWNLOAD STUDENT DATA FILES

 

DEMONSTRATION:

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

 

 

**All the assignments for Access are PROGRESSIVE. You'll need to complete them in order to continue with Access Module 2, 3, and 4.**

 

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. EMAIL all files as attachments.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Access Module 1a
  2. DRAG files into your Google Drive
  3. CALL ME for grading.
  4. DELETE
    • Everything in DOWNLOADS folder
    • Your FOLDER
    • AND EMPTY RECYCLE BIN
Feb 26

SLO - Microsoft Access: Module 2

 

DOWNLOAD STUDENT DATA FILES

  • Click on this Link to Google Drive for file.
  • Log in using your guamcc email address.
  • Right-click to Download Riverview1 file.
    • Rename: Riverview1 to Riverview2
  • Open your Google Drive or Sent Folder:
  • Download your Vendor1 and Beauty1 from last class.
    • Rename: Vendor1 to Vendor2
    • Rename: Beauty1 to Beauty2
  • Open the Downloads folder, Drag the 3 files to your folder.

DEMONSTRATION:

  1. Step-By-Step (to be graded in class):
    • Page AC59 ~ 103 In Class: Step-By-Step Exercises - RIVERVIEW2

 

 

 

 

Access Projects (to be graded in class):

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

Instructions:

  1. EMAIL all files as attachments.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Access Module 2a
  2. DRAG files into your Google Drive
  3. CALL ME for grading.
  4. DELETE
    • Everything in DOWNLOADS folder
    • Your FOLDER
    • AND EMPTY RECYCLE BIN
Feb 28 **Access Assessment - Table Object**

SLO - Access Assessment - Table Object

  1. Create a Database and Table Objects
  2. VIDEO: Introduction to Databases (Watch the Video, expires on Wednesday, February 28, 2018, at 4:00 pm CST)
  3. VIDEO: Introduction to Objects (Watch the Video, expires on Wednesday, February 28, 2018, at 4:00 pm CST)
  4. SELF ASSESSMENT: (Expires on Wednesday, February 28, 2018, at 4:00 pm CST)
Mar 7

SLO - Microsoft Access: Module 3a

 

DOWNLOAD STUDENT DATA FILES

  • Click on this Link to Google Drive for file.
  • Log in using your guamcc email address.
    • Download all the files.
      • Rename: Riverview2 to Riverview3a
      • Rename: Vendor2 to Vendor3a
      • Rename: Beauty2 to Beauty3a
  • Open the Downloads folder, Drag all the files to your folder.

DEMONSTRATION:

  1. Step-By-Step (to be demonstrated in class):

 

 

Access Projects (to be graded in class):

  1. Use the Vendor3a database to create 5 Queries.
    1. Import Spreadsheet Data (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 (See page AC107 #8)
    2. (Click on the link for the Queries - Beauty3aQueries)

Instructions:

  1. EMAIL all Vendor3a and Beauty3a as attachments.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Access Module 3a
  2. DRAG files into your Google Drive
  3. CALL ME for grading.
  4. DELETE
    • Everything in DOWNLOADS folder
    • Your FOLDER
    • AND EMPTY RECYCLE BIN
Mar 12

 

SLO - Microsoft Access: Module 3b

 

DOWNLOAD STUDENT DATA FILES

CLASS DEMONSTRATION:

  1. Step-By-Step (to be demonstrated in class):
  2. Use Riverview3b
  3. Page AC100 ~ 103 Will be demonstrated in class - Creating Table Relationships
  4. Page AC150 ~ 155 Will be demonstrated in class.

Access Projects (to be graded in class):

  1. Use Riverview3b file to complete the following:
    • Create a Calculated Field
    • Complete Step-By-Step on Page AC157 - 160
  2. Use Vendor3b file to complete 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.
  3. Continue using Vendor3b file to complete:
    • Page AC171 - Review Assignment (#1 - 11)- Create Multi-Table Queries.

Instructions:

  1. EMAIL Vendor3b as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Access Module 3b
  2. DRAG files into your Google Drive
  3. CALL ME for grading.
  4. DELETE
    • Everything in DOWNLOADS folder
    • Your FOLDER
    • AND EMPTY RECYCLE BIN
Mar 14

**Access Assessment - Query Object**

DOWNLOAD STUDENT DATA FILES

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

  1. WATCH THE VIDEO: Introduction to the Database - Form Object (Expires on Thursday, March 15, 2018, at 9:00 am CST)
  2. WATCH THE VIDEO: Introduction to the Database - Report Object (Expires on Thursday, March 15, 2018, at 9:00 am CST)
Mar 21

SLO - Microsoft Access: Module 4a

SLO - Microsoft Access: Module 4b

 

DOWNLOAD STUDENT DATA FILES

CLASS DEMONSTRATION:

  1. Step-By-Step (to be demonstrated in class):
  2. Use Riverview4
  3. Page AC182 ~ 199 Will be demonstrated in class - Creating a Form Object and Navigating a Form
  4. Page AC208 ~ 217 Will be demonstrated in class.

Access Projects (to be graded in class):

  1. Use Riverview4 file to complete the following:
    • Complete Step-By-Step on Page AC200 - 203
  2. Use Vendor4 file to complete:
    • Page AC223 - 224 Review Assignment (#1 - 18)- Create Form and Report Object.
  3. TAKE THE ACCESS TERMS SELF ASSESSMENT: (Expires on Thursday, March 22, 2018, at 3:30 pm CST)

Instructions:

  1. EMAIL Vendor4 as an attachment.
    • To: yvonne.flores@guamcc.edu
    • Cc: your email address
    • Subject: CS151-## Access Module 4
  2. DRAG files into your Google Drive
  3. CALL ME for grading.
  4. DELETE
    • Everything in DOWNLOADS folder
    • Your FOLDER
    • AND EMPTY RECYCLE BIN
Apr 2 **Access Assessment

Access Assessment:

  1. Access Terms
  2. Exercise: Everyday Databases

© 2018 Yvonne C. Flores, Guam Community College