**ALL Projects are to be graded in class and DUE on the day assigned.

SLO - Microsoft Access: Module 1a

DOWNLOAD STUDENT DATA FILES

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

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

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

SLO - Access Assessment - Table Object

1. Create a Database and Table Objects
2. VIDEO: Introduction to Databases (Watch the Video, expires on Thursday, March 1, 2018, at 3:35 pm CST)
3. VIDEO: Introduction to Objects (Watch the Video, expires on Thursday, March 1, 2018, at 3:35 pm CST)
4. SELF ASSESSMENT: (Expires on Thursday, March 1, 2018, at 3:35 pm CST)

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):
   • Page AC125 ~ 138 In Class: Step-By-Step Exercises - RIVERVIEW3a
   • Import Spreadsheet Data (See page AC80-83)
   • (Click on the link for the Queries - Riverview3aQueries)

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

SLO - Microsoft Access: Module 3b

DOWNLOAD STUDENT DATA FILES

• Click on this Link to Google Drive for file.
• Log in using your guamcc email address.
  • Download all the files.
• Open the Downloads folder, Drag all the files to your folder.

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

REMINDER:

1. WATCH THE VIDEO: Introduction to the Database - Form Object
2. WATCH THE VIDEO: Introduction to the Database - Report Object

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 Monday, March 19, 2018, at 12:00 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

Access Assessment:

1. Access Terms
2. Exercise: Everyday Databases