skip to navigation skip to content
Tue 2 Mar, Tue 9 Mar 2021
14:00 - 18:00

Venue: SSRMP Zoom

Provided by: Social Sciences Research Methods Programme


Booking

Bookings cannot be made on this event (Programme is completed).


Other dates:

No more events



Register interest
Register your interest - if you would be interested in additional dates being scheduled.


Booking / availability

Microsoft Access: Database Design and Use

Tue 2 Mar, Tue 9 Mar 2021

Description

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.
Target audience
  • University Students from Tier 1 Departments
  • Further details regarding eligibility criteria are available here
Sessions

Number of sessions: 2

# Date Time Venue Trainer
1 Tue 2 Mar   14:00 - 18:00 14:00 - 18:00 SSRMP Zoom Natalia Mora-Sitja
2 Tue 9 Mar   14:00 - 18:00 14:00 - 18:00 SSRMP Zoom Natalia Mora-Sitja
Topics covered

Session 1: Introduction to relational databases: tables and queries

Session 2: Working with linked tables and data transformation

Aims
  • 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
Format

Presentations, demonstrations and practicals

Assessment

To pass the module students will need to complete two workbook assignments, usually completed in class.

Textbook(s)
  • 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
How to Book

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

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

Theme
Introductions to Software Packages

Booking / availability