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

Accessing Student Data Files (On Campus)

1. ON-CAMPUS - CS151 / Access / Access 1 folder
• Files do not exist, they need to be created.
• Folder only contains information to copy from one database to another database.

ACCESS PROJECTS- (To be graded in class)

1. IN-CLASS DEMONSTRATION: Access1 Folder / Module Folder - (Page AC8 ~ 30)
• Create a new blank database named Riverview1 (followed your initials)
• 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)
   • 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)
• Inside the database Create a Table Object saved as Option

Accessing Student Data Files (Off-Campus)

1. OFF-CAMPUS - Click on this Link to Google Drive for files.
   • Files do not exist, they need to be created.
   • The 3 files only contain information to copy from one database to another database.

LESSON OBJECTIVES

1. SLO - Microsoft Access: Module 1

Accessing Student Data Files (Off-Campus)

1. ON / OFF-CAMPUS - Click on this Link to Google Drive for files.

ACCESS PROJECTS- (To be graded in class)

1. Right-click on Vendor2 (ADD your initials to the file name).
2. IN-CLASS DEMONSTRATION: Open PRACTICE - Riverview2 - (Page AC59 ~ 78)
3. Page AC105 ~ 106 - Review Assignment (#1 - 7)
• Open Vendor2, Modify a Table Object and Create another Table Object in Design View.

LESSON OBJECTIVES

1. Self-Assessment - CLICK to TEST YOUR Access Module 1 Terms
2. SLO - Microsoft Access: Module 2
   • Create a Table Object using the Table Design button.

Accessing Student Data Files (Off-Campus)

1. ON / OFF-CAMPUS - Click on this Link to Google Drive for files.

ACCESS PROJECTS- (To be graded in class)

1. IN-CLASS DEMONSTRATION - Importing: Open PRACTICE - Riverview3a - (Page AC80 ~ 83)
2. IN-CLASS DEMONSTRATION - Create a Query: (Page AC124 ~ 139)
   • PRACTICE - Use Riverview3a (Click on the link)
3. PROJECT - Use the Vendor3a database to create 5 Queries (Click on the Link)
4. PROJECT - Use the Beauty3a database to create 5 Queries (Click on the Link)

LESSON OBJECTIVES

1. Self-Assessment - CLICK to TEST YOUR Access Module 2 Terms
2. SLO - Microsoft Access: Module 3a

Accessing Student Data Files (Off-Campus)

1. ON / OFF-CAMPUS - Click on this Link to Google Drive for files.

ACCESS PROJECTS- (To be graded in class)

1. IN-CLASS DEMONSTRATION - Open PRACTICE - Riverview3b
   • Creating a Table Relationship (Page AC100 ~ 103)
   • Creating a Multi-Table / Multi-Criteria Criteria Queries
     • using AND or OR operator (Page AC150 ~ 155)
2. PROJECT - Use the Vendor3b database to create 4 Queries (Click on the Link)
3. PROJECT - Use the Beauty3b database to create 3 Queries (Click on the Link)

LESSON OBJECTIVES

1. Self-Assessment - CLICK to TEST YOUR Access Module 3 Terms
2. SLO - Microsoft Access: Module 3b

Accessing Student Data Files

1. ON / OFF-CAMPUS - Click on this Link to Google Drive for files.

ACCESS PROJECTS- (To be graded in class)

1. IN-CLASS DEMONSTRATION - Open PRACTICE - Riverview4a
   • Creating a Form Using the Form Wizard (Page AC182 ~ 192)
2. PROJECT - Use the Vendor4a database. (Page AC 223 #1-12)
3. PROJECT - Use the Beauty4a database. (Page AC 225 #1-11)

LESSON OBJECTIVES

1. SLO - Microsoft Access: Module 4a
2. Self-Assessment - CLICK to TEST YOUR Access Module 4 Terms

Accessing Student Data Files

1. ON / OFF-CAMPUS - Click on this Link to Google Drive for files.

ACCESS PROJECTS- (To be graded in class)

1. LAB - Open Riverview4b
   • Creating a Report Object Using the Report Wizard (Page AC208 ~ 220)

LESSON OBJECTIVES

1. SLO - Microsoft Access: Module 4b

Part 1 - HANDS-ON: Click on this Link to Google Drive to download 4 files

Part 2 - ONLINE ASSESSMENT

**Access Mastery Assessment**

(REMINDER: As stated in the syllabus, ***NO MAKEUP*** will be allowed unless PRIOR arrangements are made.)