Introduction
  • Introduction
  • Getting familiar with course tools
  • Our final product
  • What is an edge list?
Your Records Management System
  • The Spreadsheet Problem: Why We Need Relational Databases
  • Lecture 6: Your RMS
Creating a search tool
  • A simple SQL query
  • Placeholder Queries
  • Making a table
  • Append and Delete Queries
  • Putting the Search Tool Together: Macros in MS Access
Creating an edge list
  • Query 1
  • Query 2
  • Query 3
  • Query 4
  • Query 5
  • Query 6
  • Query 7
  • Query 8
  • Macro #2
NodeXL
  • Introduction to NodeXL
  • Transitioning Edge List Data to NodeXL
Trouble-shooting
  • Multiple Person_Event tables workaround