Database of Han Officials

Title slide: Database of Han officials, by Miranda Brown, University of Michigan.
Slide 'Background to database': currently in Access 2003 and downloadable, with two University of Michigan URLs.
Screenshot 'First view in the Database': the Access objects window listing tblPerson, tblPersonEvent, tblPersonOffice, tblPlace, tblSources and lookup tables.
Screenshot 'Main menu': the frmMainMenu form with People buttons, Places/Sources buttons, and Management buttons for events, genres and offices.
Screenshot 'Query person; ex: Xianyu': a search form with radio buttons for surname, hui and self-styled name in pinyin or Chinese, and ten Xianyu results.
Screenshot 'Results (pt 1) of Query': the record for Xianyu Huang, style name Bo Qian, with year fields, genre and source lists, book name KSS 2.156 and notes.
Screenshot 'Results of Query, pt. 2': relationship rows (son, paternal grandfather) with office and source, an employment table, and an appointment event.
Screenshot 'View of the tables': the same Access table list with tblPersonOffice selected.
Screenshot 'Person table (n = 5915)': rows of surname and hui in pinyin and Chinese, self-styled and shi names, and flourish-year columns.
Screenshot 'Persons are joined to Sources': tblPersonSource with index, person ID, source string such as Tai wei Yang Zhen bei or HHS, lineage and GUID.
Screenshot 'Sources table (n=475)': tblRelatedPersons with person A and B, relationship type (enemy, brother, father, colleague), office, flag and source.