Relational Databases in MS Access, video III (queries)

This Relational Databases in MS Access course is designed as a practical skill course for MS Access 2016, but also provides a handle on relational database software in general. Although the course is geared towards archaeology, the demonstrated functionality is mostly generic.

A few timestamps have been added to jump to specific operations.

1:15 Queries & SQL
3:03 Query Design
3:49 Query Design Raster
4:25 Select Query
7:08 Adding Criteria
8:18 Sorting
9:07 Simple Edits
10:34 Save Query
12:08 Query Multiple Tables
17:50 Adding More Complexity
21:29 Join Types
22:00 Inner and Left / Right Outer Join
27:09 Group By Query (Aggregations)
28:26 Totals Field
30:46 Counting Records
32:56 Expressions
34:24 Mathematical Operators
35:57 Logical Operators
39:38 Build Expression Option
41:43 Is Null / Is Not Null
43:34 Query Types
44:26 Update Query
46:18 Run A Query
47:33 Delete Query
50:29 Append & Make Table Query
52:29 Crosstab Query
56:37 SQL Syntax View

With thanks to the Halos Project at ACASA, Amsterdam Centre of Ancient Studies and Archaeology, for providing the demo data for this course.