Access database basics (Northwind database)

9/19/00


Click here to start


Table of Contents

Access database basics, including the relationship of Excel Filter commands and Excel lists (soon to be explored in 810:022).

Customers Table and records and the 91 tuples it contains.

Table in Design View instead of Datasheet View.

  1. What is the Datasheet view used for?
  2. What else can be used for the same thing instead of Datasheet view of a table?
  3. When is the Design view of Tables typically used and what for?
  4. What are the three types of transactions that occur for database records (and table records)?
  5. What parallels to this exist when working with Excel lists?
Author: Mark Jacobson

Email: jacobson@cns.uni.edu

Home Page: http://www.cns.uni.edu/~jacobson/c022.html

Other information:
This slide show will be understandable AFTER we have our first hands-on class in Wright 112. Do not worry if you don't understand it all until then. It should be studied in conjunction with Lesson 1 and Lesson 2.