skip to navigation skip to content
Tue 20 Nov, Tue 27 Nov 2018
14:00 - 18:00

Venue: University Information Services, Titan Teaching Room 1, New Museums Site

Provided by: Social Sciences Research Methods Programme


Booking

Bookings cannot be made on this event (Event 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 20 Nov, Tue 27 Nov 2018

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.
Sessions

Number of sessions: 2

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

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.

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).


Booking / availability