Project 5 Lecture/Demonstration

Creating a List with a Lookup Function

The following files are in the avi format. This means that when you click on the link a dialog box will open up and ask you whether you want to open the file or to save the file to your computer. If you elect to run the file, your default avi player (realplayer or Microsoft Media Player) will open and the file will play.

CAUTION: Two of these files are very large and depending on your connection speed may take awhile to download and play. Once the files have been downloaded and your player goes on, you may easily advance or go back to review content.

Part 1 - List with lookup function

Part 2 - Hiding rows and columns using keyboard commands

Part 3 - Using a data form to update list data

Part 4 - Using a data form to find records by specifying criteria

Part 5 - Sorting a List

Part 6 - Using Advanced Filter