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.
- University Students from Tier 1 Departments
- Further details regarding eligibility criteria are available here
Number of sessions: 2
| # | Date | Time | Venue | Trainer |
|---|---|---|---|---|
| 1 | Tue 2 Mar 2021 14:00 - 18:00 | 14:00 - 18:00 | SSRMP Zoom | Natalia Mora-Sitja |
| 2 | Tue 9 Mar 2021 14:00 - 18:00 | 14:00 - 18:00 | SSRMP Zoom | 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
To pass the module students will need to complete two workbook assignments, usually completed in class.
- 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).
Moodle is the 'Virtual Learning Environment' (VLE) that the SSRMP uses to deliver online courses.
SSRMP lecturers use Moodle to make teaching resources available before, during, and/or after classes, and to make announcements and answer questions.
For this reason, it is vital that all SSRMP students enrol onto and explore their course Moodle pages once booking their SSRMP modules via the UTBS, and that they do so before their module begins. Moodle pages for modules should go live around a week before the module commences, but some may be made visible to students, earlier.
For more information, and links to specific Moodle module pages, please visit our website: https://www.ssrmc.group.cam.ac.uk/Key-Information/moodle-vle
Booking / availability