Difference between revisions of "Relational Database Programming Study Guide"

From RobotX
Jump to navigation Jump to search
Line 19: Line 19:
 
*Get an Intellipedia Wiki Account, set up a User Page, and A Sandbox page
 
*Get an Intellipedia Wiki Account, set up a User Page, and A Sandbox page
  
==Session 1==
+
==Session 2==
 
===Pre-Session Reading===
 
===Pre-Session Reading===
  

Revision as of 02:42, 24 June 2020

Study Guide

Session 1

Pre-Session Reading

Pre-Session Videos

Training Topics

  • Intro to EXCEL: Cell Mechanics, Formulas, importin 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