Please Scroll Down to See Forums Below
napsgear
genezapharmateuticals
domestic-supply
puritysourcelabs
UGL OZ
UGFREAK
napsgeargenezapharmateuticals domestic-supplypuritysourcelabsUGL OZUGFREAK

Microsoft Access

wutangnomo

New member
Anyone know anything about this program? What is its main use? How easy is it to learn to use? How useful is it? Can you point me to a good site where I can learn to use it? Thanks.
 
Access is pretty easy to learn IMO, at least the basics. Guess it's a bit different if you creating a huge database. Powerful tool though. Most business are still stuck using excel pivot tables
 
The purpose of Microsoft Access is to put money in Bill Gates' bank account. It runs on a desktop and fools people into thinking they have a "real" database, but it promptly chokes and dies as soon as you try to use it like one, meaning with more than one user. It's not bad for single-user applications or doing a proof of concept but I haven't met a manager yet who can resist the urge to take that toy demo and put it into production instead of doing it over on a real database. The results are depressingly predictable. :anvil:

For the same amount of effort you can learn MySQL or Postgres, and you'll have a database that stands up well enough to support a few hundred users for free. There are also web-based frontends to those that give you the drag and drop and the clicky-clicky which is the "productivity" part of Access, which is just a thin shell over the database...

They actually bought SQL Server from Sybase, and they were careful to make DAMN sure that you buy Microsoft SQL Server (the full server package) to get the capability you need for serious work, not just Access the pretty front end.

End of rant.
 
LOL@ Digger Tell us how you really feel man! hehe

I'm just getting started on all this database know-how, so would Access be a good place to start?
 
digger said:
It's not bad for single-user applications .....

Most small office applications are just that - small database apps that don't need heavy iron behind it. Access has its place.

I've seen WAAAAAAAAAAAY too many database apps that don't need the expense (or complexity) of MS SQL Server. Having a db server that isn't maintened and updated isn't the brightest idea.
 
Top Bottom