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.
Describes the use of Microsoft SQL Server Integration Services to transfer a table from MS Access 2003 to Postgres on EnterpriseDB. Some of the problems are discussed.