Week Date Work Recordings
1.1 Tue, 8/26/25 Attendance
HPIA
Class Introduction
Books and chatbot
Project01-Website
Project02-Database Connections
Project03-Business Database
Project04-IoT Databases

Core Website Files
Formative00_Part1-course tech
class01
* Course Introduction

* Core Website Files

* Formative00-Part1



1.2 Th, 8/28/25 Attendance
Formative00_Part2-course tech
Formative00_Part3-course tech
Website URL Submission

URL Check- Review URL submission(s)
class02
* Formative00-Part2

* Formative00-Part3

* Website URL Submission

2.1 Tue, 9/2/25 Attendance
Start Project01 Part 1-website
class03
* Project01-website
2.2 Th, 9/4/25 Attendance
Finish Project01 Part 1-website
Formative01-Flat File problems
class04 -
3.1 Tue, 9/9/25 Project 1 Part 2-Retrieving Assignments
A&P-suggested-LinkedIn Learning-Access 2019 Essential Training
Presentation01-Access Database Introduction
Summative01-Database Objects-pull from GitHub repo
class05- no recording
* Project01-Part 2
Summative01
3.2 Th, 9/11/25 finish Summative01, start Summative02
Project04-IOT00-Raspberry Pi overview
LinkedIn Learning01-Access Essential Training
class06- website problems

IOT00
4.1 Tue, 9/16/25 Presentation02-Building a Database
Summative02-Creating Tables and Relationships
class07- Summative02

4.2 Th, 9/18/25 Presentation03-Query Basics
Query Tips
Query Exercises
GenerativeAI
Project04-IOT01-Raspberry Pi setup
class08-
Summative02, IOT01

IOT01
5.1 Tue, 9/23/25 Formative03-Query Basics
Summative03-Queries
class09-
Summative03
5.2 Th, 9/25/25 Project04-IOT02-VNC
LinkedIn Learning02-Queries
Raspberry Pi and WiFi
class10-
Summative03, Formative03-
6.1 Tue, 9/30/25 Presentation04-Form and Report Basics
Form and report tips
Formative04-form and reports
Summative04-Forms and Reports
class11 -
Formative04
6.2 Th, 10/2/25 Review for Midterm
Midterm01 available in D2L
Project04-IOT03-ssh remote connections
class12- Sum04
IOT03-

Summative04-Exercises 5,6
       
7.1 Tue, 10/7/25 Presentation05-Advanced Queries and Tables
Formative05-Advanced Queries
Summative05-Queries, Enhanced Tables
Queries and tables
Lookup Exercise
class13 - Summ05-Adv queries
7.2 Th, 10/9/25 Project02-preparation-Install Hyper-V  Review LinkedIn Learning videos class 14-
Week Date Work Recordings
       
8.1 Tue, 10/14/25 Project02-Database Connections
Project02-Part 1-Access and MySQL
class15- Project02 Part 1
8.2 Th, 10/16/25 Project02-Part 2-Access and SQL Server
Project04-IOT10-MySQL on RPi
class16- Proj 2 P2, IOT1,2,3,10
9.1 Tue, 10/21/25 Presentation06-Advanced Forms
Formative06-Advanced Forms
For fun, try to solve Formative06 using Excel Pivot Table

class17  -Formative06
9.2 Th, 10/23/25 Summative06-Custom Forms
Form tips
Summative06  
class18- Formative06
10.1 Tue, 10/28/25 Presentation07-Advanced Reports
Advanced Report Tips
Formative07-Advanced Reports
class19 - Sum05, Sum06
10.2 Th, 10/30/25 Summative07-Custom Reports
LinkedIn Learning03-Forms and Reports
Project04-IOT19-sensor data to cloud
class20- Sum06-forms
11.1 Tue, 11/4/25 Presentation08-Sharing Data
Data Integration Tips
Formative08-Linked Tables
Linked Table Madness!
class21- IOT19, Form07
11.2 Th, 11/6/25 Summative08-Sharing Data
Pivot Table Example
Midterm02 available in D2L
class22-  Sum07
12.1 Tue, 11/11/25   Veteran's Day-No Class  
12.2 Th, 11/13/25 discuss and work on Project 2
Presentation09-Action Queries
Action Query Tips
Formative09-Specialty Queries

Summative09-Action Queries and Advanced Table Relationships
Project04-IOT20 -MySQL and ODBC
class23-IOT20, Sum09
13.1 Tue, 11/18/25 Presentation10-Macros
Presentation11-Visual Basic for Applications-coding
Formative10-VBA
Presentation12-Database Management
class24  -Sum09, start s10
Summative10 -VBA, forms
13.2 Th, 11/20/25 Summative10-Managing Databases
Project04-IOT21- sensor data to MySQL
class25 - IOT20,21 Summative10
14.1 Tue, 11/25/25 Access Macros and VBA for Project03
Project04-IOT21-sensor data to MySQL
LinkedIn Learning04-Database Foundations
class26- IOT25, Form10, P3-start
       
14.2 Th, 11/27/25 Thanksgiving-No Class  
15.1 Tue, 12/2/25 work on Project03
Grading Issues
LinkedIn Learning05-IoT Fundamentals
class27-fall 24-Project3, Form10
class27-fall 22-S10, start Project3
15.2 Th, 12/4/25 finish Project03
Course Review and Feedback
Grading Issues Addressed in class
class28 -Project03
    Final Exam  
Week Date Work Recordings