HIS819: Using online probate inventories to create a database from scratch: William Harvey and his slaves
Probate inventories are sometimes found online. At the bottom of the page are a modest sample. Inventories can contain almost any item and are used by historians, art historians, historians of books and furniture, agricultural historians and so on because of the detail they give of a whole range of consumer durables. Particularly interesting, although morally repugnant, are American inventories that detail slave ownership.
Today's exercise is simply to construct a modest database from scratch with the aim of finding out something about the value of slaves in Alabama State. You should start with those inventories giving age information, as well as a valuation. William Harvey's estate is the best for this purpose. William Harvey's estate
To begin constructing a database you should have a look at William Harvey's records, and decide on the number and nature of the fields. Think about the structure of the data. You will probably decide that you want to construct a simple one table database.
To construct a new database is straightforward. You should use your copy of Guide AD03 which tells you how. The following is a step by step guide:
Open Access, Start Programs, OfficeXP, Access
Select at the start 'Create a new database using a Blank database'
Choose a suitable name, slaves.mdb seems a good idea.
Now you need to create the table, click on the Table tab and click on New, which is your only option at this stage
You should get the New Table design view. Begin entering your fields, with appropriate values.
When you have finished, save the table. Give it a suitable name, such as slaves
Allow Access to create a primary key, which will normally be a unique ID number field
Click on the table view symbol
to get your new table which might look like this:
You can now start entering your slave data. The table is a perfectly good way to do this, but you may want to consider using a Form, rather than the table. Forms are simply a better more user friendly way of entering data into a table.
To generate an Access Form, make sure your new table is open, then click on New Object Autoform button
. This should automatically generate a new form, which you should save with a suitable file name.
Now when you next open your database there should be a Slaves Table and also a Slaves Form. You can see the Slaves form when you click on the Form tab. To enter data, simply click in the next field or press the TAB or an arrow key.
Now I want you to enter all the slaves in William Harvey's Estate. You should then be able to calculate a frequency distribution of the ages of slaves, graph the value of slaves against their age in a scatter diagram, and work out answers to the questions:
What was the average value of female and male slaves? Answer 564.23076923 Click here for query design
What was the average value of slaves aged under 15 Answer 381.17647059 Click here for query design
What was the average value of female slaves over 18 Answer 629.16666667 Click here for query design
What was the average value of male slaves over 18? Answer 731.25
What was the total value of all the slaves held by William Harvey? Answer 22005
Count the frequency of all ages of slaves
Use Excel (Tools, Office, Analyze with Excel) to draw a chart showing the frequency of ages of the slave population
Probate Inventory for Estate of Myles Standish, 1656/1657
THOMAS HATCH PROBATE Probate June 1686
Appraisements and inventories of slaves in Macon County, Alabama
Estate Records of Jonathan Harper
Estate Records of Moses Harris
Estate Records of Narcissa A. Harris (contains age information)
Estate Records of Nehemiah L. Harris
Estate Records of William K. Harris (contains age information)
Estate Records of William Harvey (contains age information. This links to a copy of the original site)
Right Click, and Save Target As, here for a completed version of the Slaves database. Note that the sex fields have been converted from boy and girl to M and F