Database Updates in Access

Abstract

Many of the Accounting Information Systems (AIS) courses now include database technology as an integral part of the course. In most cases this technology is implemented using a relational database, and in most cases Microsoft Access is used as a vehicle for instruction on this topic. After a quick overview/review of Access, this paper focuses on the different meanings of the term update, and more importantly, looks at how one can update a field in a record such as items on hand or a customers balance that most if not all current texts fail to describe. An Access Basic Event handling procedure that is contained in a form will be used to accomplish the update.