Building a Database of Graphic Files Using Microsoft Access  

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.

Lowe, Richard B. STC Proceedings (2005). Articles>Information Design>Databases>Microsoft Access

Work with XML in Microsoft Access 2003

If you are a Microsoft Access user, you'll be happy to know that you can export Access 2003 data as XML.

O'Reilly and Associates (2005). Articles>Information Design>Databases>Microsoft Access

Transferring a Table in a MS Access 2003 Database to PostGres Using SQL Server Integration Services  

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.

Krishnaswamy, Jayaram. SSWUG (2009). Articles>Information Design>Databases>Microsoft Access