The Forest Service has the capability to access data residing in Oracle and other databases with Office 2000. Microsoft Access is part of the Office 2000 suite and has a strong ability to “link” to tables in other databases including Oracle. The purpose of this paper is to explain how to configure a PC for the linkage and illustrate how to make the connection. The primary benefit of using Access to manipulate data is its rich interface to quickly design queries, reports, and forms for data entry.
Read the rest of this entry »