How do I set up a records/file management system in Access 2003?

[LH62]

How do I set up a records/file management system in Access 2003?

 

[bhicks11 via AccessMonster.com]

Hi LH,

That's a pretty broad question hon. First you open a database, create the
tables, forms, queries, macros, etc. Access is pretty powerful/flexible so
you would have a learning curve.

Bonnie

http://www.dataplus-svc.com

 

[WD Rudman]

To add my two cents:

The RMS system I have worked with in the past grew fairly large, fairly
quickly. And was accessed by many users simultaneously. Depending on the
size of your user base, you may be better off using SQL server as your
back-end. And you may consider building the front-end in Visual Studio.
Though I suppose you could do it in Access.

There's a reason companies get tens of thousands of dollars for such systems.