Event box

Moving Beyond Excel: An Introduction to Databases for Complex Data

In the world of big data and automated data collection, data sets are larger and more complex than ever before. Yet oftentimes, we don’t have the skills necessary to manage this data, so we resort to our old, familiar friend… Microsoft Excel. While Excel is a great program for many things, it is slow for very large data sets and was not designed to handle multi-dimensional data sets. In this two-hour workshop, we will introduce you to general concepts of databases using Microsoft Access. We will learn how to import tables from Excel into Access, how to create relationships between tables, and how to generate basic queries using both the Query Design Wizard and manually writing the command in SQL language. No prior experience with databases or MS Access is necessary.

Meets in Library's First Floor Classroom, 120.

Date:
Tuesday, November 14, 2017
Time:
12:30pm - 2:30pm
Location:
Main Library
Campus:
University of Idaho - Moscow campus
Presenter:
Carrie Roever
Categories:
DDS NKN
Registration has closed.

Upcoming Workshops

Nov
29
12:30pm - 3:30pm, The MILL @ UIdaho Library, University of Idaho - Moscow campus.
Nov
30
12:30pm - 1:30pm, The MILL @ UIdaho Library, University of Idaho - Moscow campus.
Dec
6
12:30pm - 3:30pm, The MILL @ UIdaho Library, University of Idaho - Moscow campus.
Dec
11
12:30pm - 3:30pm, The MILL @ UIdaho Library, University of Idaho - Moscow campus.
Dec
13
12:30pm - 3:30pm, The MILL @ UIdaho Library, University of Idaho - Moscow campus.