Microsoft Access: Database Design and Use

These two sessions will provide a basic introduction to the management and analysis of relational databases, using Microsoft Access and a set of historical datasets. The workshops will introduce participants to the following:

• The use of Access’s menus and tool bars
• Viewing and browsing data tables
• Creating quick forms formulating queries
• Developing queries using Boolean operators
• Performing simple statistical operations
• Linking tables and working with linked tables
• Querying multiple tables
• Data transformation.

Number of sessions: 2

Session 1: Introduction to relational databases: tables and queries

Session 2: Working with linked tables and data transformation

• To learn to use Access menus; tool bars; viewing and browsing tables
• To create quick forms; develop queries using Boolean operators
• To perform simple statistical operations

Presentations, demonstrations and practicals

There may be a test provided at the end of the module consisting of two workbook assignments, completed in class. For most students, the test is not compulsory.

• Hemingway, V. (1994). Using and Designing Databases for Academic Work: a Practical Guide. Newcastle
• Coppock, T.(ed.) (1999). Information Technology and Scholarship Applications in the Humanities and Social Sciences. Oxford

Click the "Booking" panel on the left-hand sidebar (on a phone, this will be via a link called Booking/Availability near the top of the page).