Hi Everyone, I am currently converting our collections management database from DOS based proprietary software to MS Access and I would like to know if there is anyone who has been down the same road with any recommendations of works on relational systems design and data modeling. I am aware of the risks and disadvantages of doing it ourselves with generic database software rather than using proprietary software, but it was felt that it was worth having the control and flexibility that this option would provide.
I have had a good deal of previous experience with Access but I feel that I need more knowledge of relational systems design. I would like to know if there are museum professionals who are not programmers who took courses on this subject, and if so was it helpful? Also, are there any reference books on the subject which anyone would recommend? Searching on the internet I found a few books on database design but I am not sure which ones would be appropriate for some one with no programming experience. I looked for these books in a couple of large book stores in Toronto and only found reference books specific to particular software. Does anyone have any recommendations? Thanks in advance, David Farrell, Collections Assistant Peel Heritage Complex 9 Wellington Street East Brampton, ON L6W 1Y1 (905) 791-4055 ext. 2108 (905) 451-4931 fax www.region.peel.on.ca/heritage/index.htm ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.Region.Peel.On.Ca **********************************************************************
