Databases for historians: Database Application

Course date(s): 
17 Aug 2017
Course tutor(s): 


This practical one-day workshop explores the construction of a 'database application' for use in historical research, principally in terms of the building of an interface to aid the data entry process.

Course details

Following on from Databases for Historians I, the aim of this course is to expand and develop the practical skills necessary for constructing and fully exploiting a database for use in historical research. Techniques for both speeding up and simplifying data entry, and also for maintaining the consistency and integrity of the entered data, are introduced: complex multi-table data entry methods; controlled vocabularies; quality assurance and data validation; and navigation controls are covered. A reasonable familiarity with data modelling and common database tools is required.

The course consists of 'hands-on' practical sessions in which students are provided with practical guidance on employing these techniques through the use of Microsoft Access. Familiarity with the basic concepts of database use is required: participants should be confident working with Microsoft Access, and should have some knowledge of working with data tables and simple queries.

The course is open to postgraduates, academics and all who are interested in using databases to organise or analyse historical data. Places are strictly limited and early application is strongly recommended. The course follows on from Databases for Historians I, and we would normally expect participants to have completed that course first. Database Application is a complete and self-contained workshop, but it will be complemented by the Databases for Historians: Research Analysis and Data Processing workshop, which runs at the Insitute on the following day, 18 August.