
Building a Database of Graphic Files Using Microsoft Access
http://www.stc.org/ConfProceed/2005/PDFs/0040.pdf
Lowe, Richard B.
STC Proceedings
2005
Abstract:
Many technical communicators manage large collections of graphic files and must keep track of which graphics are used in which deliverables. An effective tool for managing a collection of graphic files is a relational database management system (RDMS) such as Microsoft Access. Before the database can be built in Access, it is necessary to 1) create detailed functional requirements and 2) build a high-level conceptual model from which the database relations (tables) can be derived. A spreadsheet program can be used to build the conceptual model and generate the relations. Normalization checks should be performed on the relations before the database is implemented in Access.