DB guide
in [Tables]
|
Prev: "Hexidecimal" Index
Next: "Normalizing" imported data
From: TotallyConfused on 13 Dec 2009 22:40 First time I have inherited a db with no documentation and which I am having trouble figuring it out. Which or how is the best way to figure someone else's db??? Thank you.
From: Fred on 14 Dec 2009 08:31 Is it documented (or obvious) what the table, link and field definition are? This will determine whether or not it actually contains truly databased data. Is this DB successfully in use? I f the answer to both of the above questions is "no", you have to consider the possibility that you inherited a piece of junk rather than a viable database. That said: I'd first peruse the "relationships" view and the tables. Try to figure out (and write down) - Define the entities that each table/record represents? - Define what goes into each field - Define what type of relationship any linkages records. After that, start figurign out what is shown in (and the data source[s] for) each form and report, Well, there a few ideas to start.
From: Jeff Boyce on 14 Dec 2009 08:52 To what end? Why do you need to? How may depend on what you want to do with it? What level of experience do you have with "normalization" and "relational database design"? What level of experience do you have with MS Access? ... with graphical user interface design? How you interpret what you find will depend on what you are familiar with... More info, please... -- Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "TotallyConfused" <TotallyConfused(a)discussions.microsoft.com> wrote in message news:CDA6C67E-613D-4E30-AAAD-361C53967521(a)microsoft.com... > First time I have inherited a db with no documentation and which I am > having > trouble figuring it out. Which or how is the best way to figure someone > else's db??? Thank you.
From: Steve on 14 Dec 2009 10:18 I have done what you are asking numerous times for customers. I provide fee-based help with Access, Excel and Word applications. My fee to help you would be very modest. I would provide you a map of the tables that shows all the tables in your database and for each table would show all the name of the table and a list of all the fields in each table. Primary and foreign keys would be shown and all relationships would be shown. For each relationship, the type of relationship would be shown. The map would generally show the flow of information in the database. Finally, a narrative describing and analyzing the database would be provided. If you are interested in having me help you with your database, contact me. Steve santus(a)penn.com "TotallyConfused" <TotallyConfused(a)discussions.microsoft.com> wrote in message news:CDA6C67E-613D-4E30-AAAD-361C53967521(a)microsoft.com... > First time I have inherited a db with no documentation and which I am > having > trouble figuring it out. Which or how is the best way to figure someone > else's db??? Thank you.
From: BruceM via AccessMonster.com on 14 Dec 2009 13:26
I will advise the OP against any consideration of hiring you. As you should understand by now, this newsgroup is for free peer-to-peer support. It is not your personal advertising forum. That you have not yet grasped this basic fact does not speak well of your potential ability to handle a more complex situation such as would arise in Access. On top of that, the OP already has a database. Presumably it has tables, and maybe even relationships, so your offer to provide a list of tables and fields is redundant at best, but more likely indicates you either did not read or did not understand the question. Either way, it should serve notice that the OP should head in almost any other direction than the one you propose. Steve wrote: >I have done what you are asking numerous times for customers. I provide >fee-based help with Access, Excel and Word applications. My fee to help you >would be very modest. I would provide you a map of the tables that shows all >the tables in your database and for each table would show all the name of >the table and a list of all the fields in each table. Primary and foreign >keys would be shown and all relationships would be shown. For each >relationship, the type of relationship would be shown. The map would >generally show the flow of information in the database. Finally, a narrative >describing and analyzing the database would be provided. If you are >interested in having me help you with your database, contact me. > >Steve >santus(a)penn.com > >> First time I have inherited a db with no documentation and which I am >> having >> trouble figuring it out. Which or how is the best way to figure someone >> else's db??? Thank you. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1 |