A Quick Microsoft Access 2000/2002 Tutorial
By Charles W. Neville, © Charles W. Neville, March 2001, with modification by Leith Chan,
Verbatim copying and redistribution of this tutorial are permitted in any medium provided this notice and the
copyright notice are preserved.
This tutorial is intended for computer science students who need a quick introduction to Microsoft Access, but
it will be useful to anyone needing such an introduction. To get the full benefit of this tutorial, you will need a
computer running one of Microsoft Windows 95 or higher, Microsoft NT 4.0 or higher, or Microsoft
Windows 2000. You will also need to have a copy of Microsoft Access 2000/2002 installed.
An Access Database Open And Ready For Use
Though Microsoft Access is NOT synonymous with database systems, there are more copies of Microsoft
Access in use than any other database system. It therefore behooves computer science students to be at least
superficially familiar with MS Access. This tutorial will guide you through some of the basic point-and-click
stuff, and will even show you how to issue complex SQL (Structured Query Language) queries. You will
open the Northwind Microsoft sample database and query it in various ways. This is a HANDS ON tutorial; it
gives you step-by-step directions for carrying out simple tasks in Access. As you read, you should have a
copy of the Northwind database open in Microsoft Access 2000/2002, and you should carry out the tasks
yourself, exactly as directed.
First, a few words about what Microsoft Access 2000/2002 is and isn't. People who don't really understand
what a relational database system is, and some people who don't actually understand what Access 2000/2002
is, will tell you that Microsoft Access is not a fully relational database system. In the database world, not
being fully relational is very bad. Don't worry, the people who tell you that are like the people who try to tell
you that linux is not a 32 bit operating system. Access 2000/2002,