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
# | Date | Time | Venue | Trainer | |
---|---|---|---|---|---|
1 | Tue 20 Nov 2018 14:00 - 18:00 | 14:00 - 18:00 | Titan Teaching Room 1, New Museums Site | map | Natalia Mora-Sitja |
2 | Tue 27 Nov 2018 14:00 - 18:00 | 14:00 - 18:00 | Titan Teaching Room 1, New Museums Site | map | Natalia Mora-Sitja |
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).
Booking / availability