**ALL PROJECTS are to be COMPLETED IN CLASS and DUE on the day assigned.

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 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. EMAIL your completed VENDOR1 and BEAUTY1 as an attachment.
   • To: yvonne.flores@guamcc.edu
   • Cc: your email address
   • Subject: CS151-## Access Module 1a

SLO - Microsoft Access: Module 1a

DEMONSTRATION:

1. Step-By-Step
   • Page AC1 ~ 30 In Class: Step-By-Step Exercises - RIVERVIEW1

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 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. EMAIL your completed VENDOR2 and BEAUTY2 as an attachment.
   • To: yvonne.flores@guamcc.edu
   • Cc: your email address
   • Subject: CS151-## Access Module 2a

SLO - Microsoft Access: Module 2

DEMONSTRATION:

1. Step-By-Step
   • Page AC59 ~ 75 In Class: Step-By-Step Exercises - RIVERVIEW2

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 Tuesday, October 9, 2018, at 2:00 pm CST)
• Watch VIDEO2: Introduction to Objects (expires on Tuesday, October 9, 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 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
   • Page AC125 ~ 138 In Class: Step-By-Step Exercises - RIVERVIEW3a
   • Import Spreadsheet Data - Invoices (See page AC80-83)
   • PRACTICE ( Click on the link for the Queries - Riverview3aQueries)

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

1. Query Online Assessment
• (Click here to take the Online Assessment)
2. Use the Personnel database.
• (Click here for instructions for the Personnel Queries)
3. Use the Zillow database.
• (Click here for instructions for the Zillow Queries

AFTER you complete the above Query Assessments

INFORMATIONAL VIDEOS provided by GCFLearn.org:

1. Watch VIDEO3: Introduction to the Database - Form Object (Expires on Thursday, October 18, 2018, at 2:00 pm CST)
2. Watch VIDEO4: Introduction to the Database - Report Object (Expires on Thursday, October 18, 2018, at 2:00 pm CST)

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.

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 Tuesday, October 23, 2018, at 2: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

Access Assessment:

1. Access Terms
2. Exercise: Everyday Databases