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

ASSIGNMENT:

WATCH THE FOLLOWING VIDEOS provided by GCFLearnFree.org

1. Watch VIDEO1: Introduction to Databases (Click on Link)
2. Watch VIDEO2: Introduction to Objects (Click on Link)

**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

1. In Google Drive,
   • create a folder for CS151-##,
   • open the CS151 folder, create the following subfolder
     • Access Module 1

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

1. SLO - Microsoft Access: Module 1
   • Demonstrate creating a Table Object using the Table button.

ACCESS PROJECTS- (To be graded in class)

1. 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
2. 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
3. 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:

1. CALL INSTRUCTOR for grading.
2. CLOSE the files.
3. DRAG the 3 files (Riverview1, Vendor1, Beauty1) to your Google Drive CS151/Access Module 1 folder.
4. 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
5. Look at the board to see if your email is in my Inbox.

**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)

1. PRACTICE: Page AC 59~ 78
• Use Riverview2
2. Page AC105 ~ 106 - Review Assignment (#1 - 7) - Modify a Table Object and Create another Table Object in Design View: Use Vendor2

Accessing Student Data Files (On / Off-Campus)

1. Log in to your Email, go to your Google Drive.
2. DOWNLOAD
   • Riverview1 and Vendor1from the previous lesson
   • to your folder on the Desktop.
3. RENAME
   • Riverview1 to Riverview2
   • Vendor1 to Vendor2

LESSON OBJECTIVES

1. SLO - Microsoft Access: Module 2
• Demonstrate creating a Table Object using the Table Design button.
2. Watch VIDEO1: Introduction to Databases (Click on Link)
3. Watch VIDEO2: Introduction to Objects (Click on Link)
4. TABLE Object
   • Watch VIDEO3: Work with Tables (Click on Link)
   • Watch VIDEO4: Customize Tables (Click on Link and scroll down)

INSTRUCTIONS:

1. CALL INSTRUCTOR for grading.
2. CLOSE the files.
3. In Google Drive, create Access Module 2 folder.
4. DRAG the 3 files (Riverview2, Vendor2) to your Google Drive CS151/Access Module 2 folder.
5. 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
6. Look at the board to see if your email is in my Inbox.

INSTRUCTIONS:

1. CALL INSTRUCTOR for grading.
2. CLOSE the files.
3. In Google Drive, create Access Assessment folder.
4. DRAG the Condo Rentals file to your Google Drive CS151/Access Assessment folder.
5. SHARE your CS151/Access Assessment folder with me.
• Right-click on the Access Assessment folder
• click Share
• enter my email address: yvonne.flores@guamcc.edu
6. Look at the board to see if your email is in my Inbox.
7. Delete your folder, Empty your Recycle Bin

Accessing Student Data Files (On / Off-Campus)

1. In your CS151 Google Drive folder, create a Access Module 3 folder.
2. 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)

1. 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.
2. (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

1. Did you watch Video5?
2. SLO - Microsoft Access: Module 3a
• Demonstrate creating a Query Object using the Query Design button.
3. STEP-BY-STEP
• Import Spreadsheet Data - Invoices (See page AC80-83)
4. PRACTICE ( Click on the link for the Queries - Riverview3aQueries)

INSTRUCTIONS:

1. CALL INSTRUCTOR for grading.
2. DRAG the 2 files (Vendor3a, Beauty3a) to your Google Drive Access Module 3 folder.
3. SHARE your folder.
4. Watch VIDEO6: Designing a Multi-Table Query (Click on Link)

Accessing Student Data Files (On / Off-Campus)

1. 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)

1. 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.
2. (Click on the link for the Queries - Module3bMultiQueries)
   • Use the Vendor3b database to create 4 Queries.

LESSON OBJECTIVES

QUERY Object

1. Did you watch Video6?
2. SLO - Microsoft Access: Module 3b
• Demonstrate creating a Query Object using the Query Design button.
3. STEP-BY-STEP DEMONSTRATION:
   • Use Riverview 3b
• Page AC100 ~ 103 Creating a Table Relationship
• Page AC150 ~ 155 Creating Multi-Table / Multi-Criteria Queries using AND and OR operator

INSTRUCTIONS:

1. CALL INSTRUCTOR for grading.
2. DRAG the 2 files (Riverview 3b, Vendor3b) to your Google Drive Access Module 3 folder.
3. SHARE your folder.
4. Self-Assessment - CLICK to TEST YOUR Access Module 1 Terms
5. Self-Assessment - CLICK to TEST YOUR Access Module 2 Terms
6. Self-Assessment - CLICK to TEST YOUR Access Module 3 Terms
7. Watch VIDEO7: Work with Forms (Click on Link)
8. Watch VIDEO8: Work with Reports (Click on Link)

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 the 2 files.
4. Open the Downloads folder, Drag the 2 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 AC198 (Switch to Form View) - Add a New Record (see the picture)
   • Page AC200 ~ 203 Creating a Form and a Sub Form
2. TAKE THE ACCESS TERMS SELF ASSESSMENT: (Expires on Tuesday, March 12, 2019, at 12:00 pm ChST)
   • Self-Assessment - CLICK to TEST YOUR Access Module 4 Terms

LESSON OBJECTIVES

FORM and REPORT Object

1. Did you watch Video 7 and 8
2. SLO - Microsoft Access: Module 4a
• Demonstrate creating a Form Object using the Form Tool
3. SLO - Microsoft Access: Module 4b
   • Demonstrate creating a Report Object using the Report Wizard (Page AC208 ~ 217 Creating a Report Object)

INSTRUCTIONS:

1. CALL INSTRUCTOR for grading.
2. CLOSE the files.
3. In Google Drive, create Access Module 4 folder.
4. DRAG Riverview4.
5. SHARE Access Module 4 folder with me.

**Access Assessment on Tables, Queries, Forms, Reports, Database Terms and Everyday Databases **

(NO Makeup unless PRIOR arrangements are made)

Access Assessment:

1. Part1: Access Terms
2. Part2: Everyday Databases