Introduction to Access Databases

Course Summary:
The database has become an essential a tool in archaeological research and investigation, so much so that today there are few projects that do not employ a database for the storage, control and analysis of archaeological data.

This course provides an introduction to the theory of database design, complimented by practical instruction in database creation. It will be of interest to all archaeologists who work with excavation or survey data, as well as those who compile and analyse catalogues of site or artefact data. It aims to teach archaeologists how to design conceptual data models and create them in Microsoft Access. There are no course prerequisites.

The course will benefit academic and professional archaeologists alike. Because databases serve as the foundation for a variety of other archaeological applications such as GIS and CAD mapping, this course can be taken as the first step in the learning more complex data-oriented approaches to the management of archaeological information. Each introductory course is two days. See the links above for detailed course outlines, and information on how to register.

Learning Outcomes:
At the completion of the course, participants will have obtained a conceptual overview of the use of databases in the study of archaeology, and how to apply this knowledge in the creation of databases to hold complex relational datasets.