Understanding Database Structure
Provides an overview of the concepts of field, record, and table, as a foundation to querying the database.
Creating
One-Table Queries with Query Builder
Includes choosing specific columns of information and limiting rows using criteria.
Creating Multiple-Table Queries
with Query Builder
Explains the four types of joins between tables and how to use column aliases.
Manipulating the Data
Introduces concepts beyond the Query Builder, such as concatenation, calculations, and conditional output
Sorting and Grouping the Data
Introduces the ORDER BY clause and using aggregate functions
Shelby Reporter Options
Explains options such as changing the output display, importing/exporting queries, and more.
