Week 7 Assignment: Querying CBDB in Microsoft Access
- Test your skills of building customized queries by completing the following exercise. Download KinshipAndPostings v1_Tables Only.accdb from Moodle (click here). Create a query that reports who held which office(s) when and where. Export your query results into a csv file.
- Open the Microsoft Access edition of the China Biographical Database (CBDB). Complete the following queries. The CBDB User’s Guide provides detailed instructions that help you complete this assignment. The Appendix in the User’s Guide also gives instructions on how to install the database properly (i.e., how to manage linked tables).
- Find all persons who entered government service through the jinshi examination [i.e., “examination: jinshi (general)”] AND were from Chengdufu Lu [N.B. Lu means “circuit”]. Click the “Save to GIS” button to save your results. (Section A in Chapter 3 of the User’s Guide provides detailed instructions.)
- Find all persons who held “Grand Councilor Offices” in the Song dynasty. Click “Save People to GIS” button to save your results. (Section C in Chapter 3 of the User’s Guide provides detailed instructions, which uses the “Vice Grand Councilor” as an example to illustrate the procedure.)
After you finish, you will have one csv file and two .tab files. Compress them into one zipped file. Submit it the drop box on Moodle.