Get Adobe Flash player

Database Assignment - US Presidents

Lesson Topic: Databases, Microsoft Access SOL: C/T 6-8.1 - C/T 6-8.6

Objective: SWBAT be able to create a table in Access with 3 fields on the Presidents

Procedure: Have students open Microsoft Access Have students create a table with the following 3 fields:

  • Common Name
  • Political Party
  • Years
Students sort by Political Party, then create a query of all Federalist Presidents.

President Name
Political Party
George Washington None 1789-1797
John Adams Federalist 1797-1801
Thomas Jefferson Democratic-Republican 1801-1809
James Madison Democratic-Republican 1809-1817
James Monroe Democratic-Republican 1817-1825
John Quincy Adams Democratic-Republican 1825-1829
Andrew Jackson Democratic 1829-1837
Martin Van Buren Democratic 1837-1841
William Henry Harrison Whig 1841
John Tyler Whig 1841-1845
James Polk Democratic 1845-1849
Zachary Taylor Whig 1849-1850