Topic 5: Database Processing

The Human Face of Big Data is a 60 minute film that showcases how big data are everywhere in our lives today (the entire film is streamed from Chatham. Click the link to watch it.)

Relational database, and more recently, NoSQL, is the principal foundation of modern data infrastructure. Through several hands-on exercises, we explore the basic principles of relational database concepts, and how a relational database is distinguished from spreadsheets.

Learning Aims

1. Define relational databases and its key attributes
2. Explain why relational databases are useful for modern organizations
3. Define NoSQL

Theory

Introduction to Relational Databases (Stanford University) (14 minutes)

Introduction to Database Fundamentals (Microsoft Enterprise Consortium)

The Relational Model (Stanford University) (9 minutes)

Data Model (Microsoft Enterprise Consortium)

Relationships (Microsoft Enterprise Consortium)

Defining Relationships (Microsoft Enterprise Consortium)

Practicals

Microsoft Access: Beginning from a template (2 minutes)

Importing Excel data into Access

Data types in Acces

Designing tables in Access

Creating relationships in Access

Creating queries in Access

Creating tables in Access

Creating forms in Access

Building a menu in Access

Creating expressions using The Expression Builder

Creating formulas in Access

Creating a graph in Access

Explore these Atomic Learning training modules (available for free from Chatham)

Section D "Creating a Database" of the Atomic Learning Access Training Collection (20 minutes)

Section E "Creating a Table" of the Atomic Learning Access Training Collection (20 minutes)

Section F "Working with a Table" of the Atomic Learning Access Training Collection (35 minutes) 

Physical Design Part 1 (Microsoft Enterprise Consortium)

Microsoft Access 2013 Training on Table Relationships - Part 1

Physical Design Part 2: Relationships (5 min) 

Physical Design Part 3 :Primary Key, Unary One-to-Many Relationship, Binary One-to-One Relationship (5 min)

Physical Design Part 4 :Many-to-Many Relationship (5 min)

Physical Design Part 5 :Multivalued Attribute (5 min)

Microsoft Access 2013 Tutorial on relationship - Part 2 (8 min) 

"Understanding Referential Integrity" from Guide to Table Relationships in Access (by Microsoft Office) 

NoSQL for unstructured data processing
NoSQL Overview: MapReduce, Hadoop, etc (27 minutes) 
Introduction to NoSQL (free registration required, 10 minutes) 

Examples of MS Access applications for accounting
Aging accounts receivable

Refining the sales report

Creating a grouped report

Using VBA to modify a cross-tab query

Enhancing a menu

Stacked column chart to track monthly sales by category

Calculating running sums to track monthly data