Theatre Design & Technology - Summer 2013 - 65

The TimesheetID field is the primary key, assigned as an
auto number. We are also going to add a foreign key (FK), EmployeeID. It's considered a foreign key because this field links
to data in another table. In this case, it's linked back to the
EmployeeID field in the Employee_Table. Because this field
is linked, only the EmployeeID numbers that exist in the Employee_Table can be entered in the EmployeeID field in the
Timesheet_Table. For example, if you have four employees entered into the Employee_Table with an ID of 1-4 respectively,
then the database will not allow you to enter a 5 into this table,
because it does not exist in the Employee_Table. However, each
employee can have multiple records in the Timesheet_Table
indicating he or she has worked on multiple shows. This relationship is known as a one-to-many relationship and is very
common in relational databases. We will also create a foreign
key in the Timesheet_Table to establish a relationship with the
Show_Table.
Other fields in the Timesheet_Table include a simple date
field, an RT (regular time) hours field to track the number of
hours they worked, an OT (overtime) hours field to track overtime, a grade field to be used to give the overhire an overall
grade, and a notes field.
We're now done creating the three tables in our overhire
database. We link these tables together in MS Access with the
Relationships Tool. Simply open this tool (it's in the "Database
Tools" Tab) and click to show each of the three tables we created. Then click and drag the fields that need to be related.
When the line exists, double click the line, and make sure the
"Enforce Referential Integrity" field is selected. Your relationships table should look something like figure 11.
This database is extremely basic, but it is very easy to
customize for your own needs by adding additional fields and
tables. For example, if you wanted to track each employee by a
specific department in addition to his or her position, and then
sort labor information by that department, just create a Department_Table and link it to the Employee_Table. Or say you want
to track pay rates for full time employees who have worked with
the company for several years. Create a History_Table and link
it to the Employee_Table. The fields in this table would be Position and PayRate-moved over from the Employee_Table-as
well as StartDate and EndDate.

Conclusion
A well-planned Business Intelligence solution can provide valuable information quickly and easily. This information can help
managers make informed business decisions and can help them
spend less time behind their desks and more time collaborating with designers and directors. That said, planning and implementing a new system that will likely be used by many people
in the organization takes time, careful planning, and money. For
the Shakespeare Theatre Company, the time spent has really paid
off. But not every BI solution is right for every organization. If a
solution is created, but is not providing the useful information
needed, or is taking a longer amount of time to provide this information, then the process as a whole should be rethought, in-

Structured Query Language (SQL)
A database is useless without reports. The best way to gather up the information
you need in any report is to first create a Query, and then use a Report to format
the information in the Query.
There are several ways to create a Query. The easiest way in MS Access is to
use the Query Wizard. A pop up window asks what information you are looking
for and from where you would like to pull the data.
As a programmer, I prefer to just type my query statements directly using
Structured Queried Language (SQL). With this method, it is a little easier
to program exactly what information you want, as well as indicate specific
parameters you are looking for. SQL is a complex programming language
that can be used with many databases, including Access. I'll give just a couple
examples of what you can do with SQL.
In the overhire database, we can easily create a simple report of current
employees that includes their position and their pay rate using the following SQL
statement:
SELECT FullName, Phone, Email, Position, Rate
FROM Employee_Table
ORDER BY FullName;
This simple report could easily be generated using the Query Wizard.
However, with two additional SQL statements, we can tell the database that we
only want to see carpenters who earn more than $15/hour:
SELECT FullName, Phone, Email, Position, Rate
FROM Employee_Table
WHERE Position = "Carpenter"
AND PayRate >= 15
ORDER BY FullName;
Or we can create a complex query that gives us the total man-hours worked
on each production and the total labor cost based on rates:
SELECT Show, Sum(RTHours*PayRate) + Sum(OTHours*PayRate*1.5)
AS [LaborCost]
FROM Employee_Table, Show_Table, Timesheet_Table
WHERE Employee_Table.EmployeeID = Timesheet_Table.EmployeeID
AND Timesheet_Table.ShowID = Show_Table.ShowID
GROUP BY Show
ORDER BY Show;
You can save this query and every time you need this useful information as
more data is entered into the database, the report will automatically update itself.

cluding whether or not a BI solution should be incorporated.
For further reading on how to create an Access database,
I suggest Access 2010: The Missing Manual by Matthew MacDonald. This is a very detailed book that walks you through
planning a database, creating simple forms and queries, as well
as how to create complex reports and macros. v
Tim Kaufmann is the associate production manager
at the Shakespeare Theatre Company in Washington, DC.
He is a member of USITT's Management Commission and
serves on the Finance Committee. Most recently, he sat on
the panel for the "Excel Super User" session at the 2013
USITT Conference & Stage Expo.
s u m m e r 2013

theatre design

& technology

63



Table of Contents for the Digital Edition of Theatre Design & Technology - Summer 2013

Contents
Theatre Design & Technology - Summer 2013 - 1
Theatre Design & Technology - Summer 2013 - 2
Theatre Design & Technology - Summer 2013 - 3
Theatre Design & Technology - Summer 2013 - Contents
Theatre Design & Technology - Summer 2013 - 5
Theatre Design & Technology - Summer 2013 - 6
Theatre Design & Technology - Summer 2013 - 7
Theatre Design & Technology - Summer 2013 - 8
Theatre Design & Technology - Summer 2013 - 9
Theatre Design & Technology - Summer 2013 - 10
Theatre Design & Technology - Summer 2013 - 11
Theatre Design & Technology - Summer 2013 - 12
Theatre Design & Technology - Summer 2013 - 13
Theatre Design & Technology - Summer 2013 - 14
Theatre Design & Technology - Summer 2013 - 15
Theatre Design & Technology - Summer 2013 - 16
Theatre Design & Technology - Summer 2013 - 17
Theatre Design & Technology - Summer 2013 - 18
Theatre Design & Technology - Summer 2013 - 19
Theatre Design & Technology - Summer 2013 - 20
Theatre Design & Technology - Summer 2013 - 21
Theatre Design & Technology - Summer 2013 - 22
Theatre Design & Technology - Summer 2013 - 23
Theatre Design & Technology - Summer 2013 - 24
Theatre Design & Technology - Summer 2013 - 25
Theatre Design & Technology - Summer 2013 - 26
Theatre Design & Technology - Summer 2013 - 27
Theatre Design & Technology - Summer 2013 - 28
Theatre Design & Technology - Summer 2013 - 29
Theatre Design & Technology - Summer 2013 - 30
Theatre Design & Technology - Summer 2013 - 31
Theatre Design & Technology - Summer 2013 - 32
Theatre Design & Technology - Summer 2013 - 33
Theatre Design & Technology - Summer 2013 - 34
Theatre Design & Technology - Summer 2013 - 35
Theatre Design & Technology - Summer 2013 - 36
Theatre Design & Technology - Summer 2013 - 37
Theatre Design & Technology - Summer 2013 - 38
Theatre Design & Technology - Summer 2013 - 39
Theatre Design & Technology - Summer 2013 - 40
Theatre Design & Technology - Summer 2013 - 41
Theatre Design & Technology - Summer 2013 - 42
Theatre Design & Technology - Summer 2013 - 43
Theatre Design & Technology - Summer 2013 - 44
Theatre Design & Technology - Summer 2013 - 45
Theatre Design & Technology - Summer 2013 - 46
Theatre Design & Technology - Summer 2013 - 47
Theatre Design & Technology - Summer 2013 - 48
Theatre Design & Technology - Summer 2013 - 49
Theatre Design & Technology - Summer 2013 - 50
Theatre Design & Technology - Summer 2013 - 51
Theatre Design & Technology - Summer 2013 - 52
Theatre Design & Technology - Summer 2013 - 53
Theatre Design & Technology - Summer 2013 - 54
Theatre Design & Technology - Summer 2013 - 55
Theatre Design & Technology - Summer 2013 - 56
Theatre Design & Technology - Summer 2013 - 57
Theatre Design & Technology - Summer 2013 - 58
Theatre Design & Technology - Summer 2013 - 59
Theatre Design & Technology - Summer 2013 - 60
Theatre Design & Technology - Summer 2013 - 61
Theatre Design & Technology - Summer 2013 - 62
Theatre Design & Technology - Summer 2013 - 63
Theatre Design & Technology - Summer 2013 - 64
Theatre Design & Technology - Summer 2013 - 65
Theatre Design & Technology - Summer 2013 - 66
Theatre Design & Technology - Summer 2013 - 67
Theatre Design & Technology - Summer 2013 - 68
Theatre Design & Technology - Summer 2013 - 69
Theatre Design & Technology - Summer 2013 - 70
Theatre Design & Technology - Summer 2013 - 71
Theatre Design & Technology - Summer 2013 - 72
Theatre Design & Technology - Summer 2013 - 73
Theatre Design & Technology - Summer 2013 - 74
Theatre Design & Technology - Summer 2013 - 75
Theatre Design & Technology - Summer 2013 - 76
Theatre Design & Technology - Summer 2013 - 77
Theatre Design & Technology - Summer 2013 - 78
Theatre Design & Technology - Summer 2013 - 79
Theatre Design & Technology - Summer 2013 - 80
Theatre Design & Technology - Summer 2013 - 81
Theatre Design & Technology - Summer 2013 - 82
Theatre Design & Technology - Summer 2013 - 83
Theatre Design & Technology - Summer 2013 - 84
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2022winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2022winter_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2021fall_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2021fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2021summer_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2021summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2021spring_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2021spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2021winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2021winter_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2020fall_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2020fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2020summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2020summer_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2020spring_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2020spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2020winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2020winter_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2019fall_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2019fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2019summer_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2019summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2019spring_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2019spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/usitt_techexpoguide_2019_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/usitt_techexpoguide_2019
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2019winter_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2019winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2018fall_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2018fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2018summer_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2018summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2018spring_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2018spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2018winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2017fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2017fall_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2017summer_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2017summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2017spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2017spring_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/usitt_techexpoguide_2017_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/usitt_techexpoguide_2017
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2017winter_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2017winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2016fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2016summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2016spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2016spring_public
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2016winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2015fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2015summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2015spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2015winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2014fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2014summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2013winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2013summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2013fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2013spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2012winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2012fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2012summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2012spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2011winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2011fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2011summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2011spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2010winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2010fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2010summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2010spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2009winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2009fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2009summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2009spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2008winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2008fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2008summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2008spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2007winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2007fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2007summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2007spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2006winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2006fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2006summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2006spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2005winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2005fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2005summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2005spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2004winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2004fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2004summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2004spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2003winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2003fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2003summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2003spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2002winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2002fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2002summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2002spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2001winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2001fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2001summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2001spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2000winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2000fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2000summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_2000spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1999winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1999fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1999summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1999spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1998winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1998fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1998summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1998spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1997winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1997fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1997summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1997spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1996winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1996fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1996summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1996spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1995winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1995fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1995summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1995spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1994winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1994fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1994summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1994spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1993winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1993fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1993summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1993spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1992winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1992fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1992summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1992spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1991winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1991fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1991summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1991spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1990fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1990summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1990spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1989winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1989fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1989summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1989spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1988winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1988winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1988fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1988summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1988spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1987winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1987fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1987summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1987spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1986winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1986fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1986summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1986spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1985winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1985fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1985summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1985spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1984fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1984summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1984spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1983winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1983fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1983summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1983spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1982winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1982fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1982summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1982spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1981winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1981fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1981summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1981spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1980winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1980fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1980summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1980spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1979winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1979fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1979summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1979spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1978winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1978fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1978summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1978spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1977winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1977fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1977summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1977spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1976winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1976fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1976summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1976spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1975winter
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1975fall
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1975summer
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1975spring
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1974Dec
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1974Oct
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1974May
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1974Feb
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1973Dec
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1973Oct
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1973May
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1973Feb
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1972Dec
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1972Oct
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1972May
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1972Feb
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1971Dec
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1971Oct
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1971May
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1971Feb
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1970Dec
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1970Oct
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1970May
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1970Feb
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1969Dec
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1969Oct
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1969May
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1969Feb
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1968Dec
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1968Oct
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1968May
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1968Feb
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1967Dec
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1967Oct
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1967May
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1967Feb
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1966Dec
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1966Oct
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1966May
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1966Feb
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1965Dec
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1965Oct
https://www.nxtbook.com/nxtbooks/hickmanbrady/tdt_1965May
https://www.nxtbookmedia.com