After years of using Excel to store data, I decided to try out Access.
Last week my database got corrupt; and now, some questions have come to mind (so I've decided to "ask the experts"): First and foremost, what is the advantage of using an Access database? (I mean, if I put the same information into Excel, it seems I can always create a formula to define parameters that I might need; and an Excel file is a fraction of the size.) And of course, I need some pointers: In creating an Acceess database, should I put ALL my information into a 'master' sheet, and then create queries to filter for required information, or am I better off using several smaller tables. Initially this started out as a simple idea to record contact information of business. Then, a subform seemed logical to store additional information on employees of each individual business. What would be your suggestiions? Unfortuneately, the Access books that I've seen, concentrate on implimentation, and NOT practicality; so your recommendations are welcome. Thanks. ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hcjurlf/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1125015470/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
