Hope College CSCI 140

This video describes the process of creating queries that can relate two or more records in the same table to each other, such as "Find all the actors who appeared in a movie with Kevin Bacon"

This video describes how to create queries that compute aggregate functions, such as SUM, AVERAGE, and COUNT

This video reviews single table queries in Access, describes the use of the LIKE operator, and then discusses how to create queries that use multiple tables.

This video outlines the process of creating single-table queries in Access using equality and between criteria

This video gives an overview of database technology, and talks about the advantages of the relational model versus a single table view of a database.

This video outlines the use of the Goal Seek and Scenario tools, used for What-if analysis in Microsoft Excel

This video discusses what an Excel macro is, what security issues exist with macros, and then describes how to create, run, and edit macros.

This video shows the solution to completing steps 2 through 6 of Tutorial 8, Case 3.

This video gives solutions to the practice exercises on COUNTIF, SUMIF and AVERAGEIF

This video contains an overview of the COUNTIF, AVERAGEIF and SUMIF functions which are covered in Tutorial 7.3