Difference between revisions of "Relational Database Programming Study Guide"

From RobotX
Jump to navigation Jump to search
Line 11: Line 11:
 
*[https://youtu.be/1GSjbWt0c9M?list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo Representing Numbers and Letters with Binary: Crash Course Computer Science #4]
 
*[https://youtu.be/1GSjbWt0c9M?list=PL8dPuuaLjXtNlUrzyH5r6jN9ulIgZBpdo Representing Numbers and Letters with Binary: Crash Course Computer Science #4]
 
===Training Topics===
 
===Training Topics===
−
*Intro to EXCEL: Cell Mechanics, Formulas, importin and Exporting CSV Files
+
*Intro to EXCEL: Cell Mechanics, Formulas, Importing and Exporting CSV Files
 
*Intro to Access Forms, Queries, Tables, Reports, Switchboard, VB IDE
 
*Intro to Access Forms, Queries, Tables, Reports, Switchboard, VB IDE
 
*Intro to a Wiki and it's Markup Language
 
*Intro to a Wiki and it's Markup Language

Revision as of 22:14, 27 June 2020

Study Guide

Session 1

Pre-Session Reading

Pre-Session Videos

Training Topics

  • Intro to EXCEL: Cell Mechanics, Formulas, Importing and Exporting CSV Files
  • Intro to Access Forms, Queries, Tables, Reports, Switchboard, VB IDE
  • Intro to a Wiki and it's Markup Language

Homework Assignment

  • Build an Excel Spreadsheet with a graph
  • Get an Intellipedia Wiki Account, set up a User Page, and A Sandbox page

Session 2

Pre-Session Reading

Pre-Session Videos

Training Topics

  • Intro to Access Table creation with Parent Child Relationships
  • Intro SQL Querries

Homework Assignment

Build a 3 Table Database with 2 child relationships

Retrieved from "http://OCRobotx.org/mediawiki/index.php?title=Relational_Database_Programming_Study_Guide&oldid=13362"