 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2007Database design
A little while ago (on one of these NewsGroups) there was a thread about using Excel as a database and database design. I undertook to consolidate my thoughts (which were over several posts) on an information sheet. I have now done this and the first effort may now be seen at - http://1001solutions.co.uk/Designing_a_spreadsheet.pdf Regards. Bill Ridgeway Computer Solutions This is quite good. One suggestion: while it's possible to use Excel as a database, it is not really possible to have multiple concurrent users of the database, and so Excel's ability to serve as a database (as the word is generally understood) is rather limited. Given that caveat, looks good. Dave  SignatureA hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. > A little while ago (on one of these NewsGroups) there was a thread about > using Excel as a database and database design. I undertook to consolidate [quoted text clipped - 7 lines] > Bill Ridgeway > Computer Solutions Thanks for your response and encouragement Dave. I do say "Of course not everything included here is applicable to each use". In the scenario you highlight, most, if not all, the design 'features' should be just as applicable. They would get you there it's just that Excel is not the right bus for the journey. The piece is intended as a layman's (sorry, laypersons) guide and most laymen (laypersons) would probably be using Excel and would turn to Excel rather than Access in the first instance. Regards. Bill Ridgeway Computer Solutions > This is quite good. One suggestion: while it's possible to use Excel as a > database, it is not really possible to have multiple concurrent users of [quoted text clipped - 17 lines] >> Bill Ridgeway >> Computer Solutions Fair points. Dave SignatureA hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. > Thanks for your response and encouragement Dave. > [quoted text clipped - 32 lines] > >> Bill Ridgeway > >> Computer Solutions Dave F has written (on several occasions) "Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem." I would like to add another hint. It is sometimes best NOT to ask a closed question like "How do I use this function?" This is like standing in the middle of a town and asking "Where do I get the number 42 bus?" By doing so you've assumed that the number 42 bus is the only service between the two points. Asking an open question like "How do I get the computer to do this?" lets others advise on other (possibly better) routes to your destination. Regards. Bill Ridgeway Computer Solutions Yes, that's a good point. There's more than one way to skin a cat in Excel. Dave SignatureA hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. > Dave F has written (on several occasions) "Specific, detailed questions are > more likely to be answered than questions that provide no detail about your [quoted text clipped - 11 lines] > Bill Ridgeway > Computer Solutions I didn't know Excel would skin cats. How do you get it to do that, cuz I've got one very annoyingly sitting in front of my keyboard right now, and it's very hard to type! Rob > Yes, that's a good point. There's more than one way to skin a cat in > Excel. [quoted text clipped - 20 lines] >> Bill Ridgeway >> Computer Solutions Better that yours sits in front of the keyboard than to sit on the keyboard like mine do. SignatureJoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 >I didn't know Excel would skin cats. How do you get it to do that, cuz >I've got one very annoyingly sitting in front of my keyboard right now, and [quoted text clipped - 27 lines] >>> Bill Ridgeway >>> Computer Solutions I used to have one that would do that. She like the heat of the old laptop I have, so she'd curl up on the keyboard while I was away at lunch and I'd come back to find it beeping at her incessantly as she slept, and any number of oddities on-screen. Rob > Better that yours sits in front of the keyboard than to sit on the > keyboard like mine do. [quoted text clipped - 32 lines] >>>> Bill Ridgeway >>>> Computer Solutions |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.