skip to navigation skip to content
Tue 26 Nov, Tue 3 Dec 2019
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 in the past).


Other dates:

No more events

[ Show past 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 26 Nov, Tue 3 Dec 2019

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.

NOTE: Strike action is taking place between 25 November and 4 December 2019. If the strike goes ahead, this module will be affected. Please see the 'latest news' section on the home page of the SSRMP website for more information.

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 26 Nov 2019   14:00 - 18:00 14:00 - 18:00 University Information Services, Titan Teaching Room 1, New Museums Site map Natalia Mora-Sitja
2 Tue 3 Dec 2019   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).

Theme
Introductions to Software Packages

Booking / availability