|I'm currently working with a historical society. They have much of their information in databases in the form of Access 2003 files. The problem is that these files have been duplicated, renamed, spread around a handful and different computers, and then independently updated. There are certain common tables that the majority of them have, but these tables are in 2 or 3 different forms of completeness. Furthermore, the more complete and up to date files have up to 22 tables in them, each of which is a different category. Many of these tables are input from specific forms that allow the proper information and identification numbers to be given to the various items in the various categories. What needs to be done is that all the information needs to be centralized in a single database, not spread out, because it needs to be all accessible. To compound the problem, not all the tables are in the exact same format, even though they mostly have the same fields. Is is possible to combine all the tables of the same from all these various databases together so that all the information is in one place, while in the process eliminating duplicates? I'm sorry if this is all very confusing. I also am thoroughly confused by the sorry state of these databases, not helped by the fact that I am a complete novice when it comes to Access.|
Thank you in advance.