How to creat a Library Database ?

[Tamer]

Hi all ,

I'm a new access user and i nead to know how can i creat a high secure
database for a college library . what kind of data i should putinto it and
how to make it as a programme (setup with a serial no.) ..

thank you

 

[Fred Boer]

Dear Tamer:

IMHO, creating a full-featured library system for a college library would be
a major project, even for an experienced Access professional. As you say you
are new to Access, I would suggest that you may wish to do some research
before you attempt this project. A quick Google search reveals many dozens
of vendors selling a wide variety of library management software. For
example, you might look at the following:

http://directory.google.com/Top/Reference/Libraries/Library_and_Information_Science/Software/

Or, you can find shareware library systems as well, with a search at
www.tucows.com, for example. Creating a library system yourself, from
scratch, could be a very costly business! You will probably find that a
professionally written commercial package would be much more cost effective.
I am a teacher-librarian for a small school, and I have created a library
system for my school in Microsoft Access. There were some valid reasons that
I did this, but I could never claim (at least not with a straight face! <g>)
that this was the most cost effective or efficient solution!

HTH
Fred Boer

 

[Duane Hookom]

You are asking a bit much in a single question. I suggest you back away from
the keyboard, get out pencil and paper, jot down some requirements and
specifications, start working on it a bit, and only then come back with some
questions.

If you truly need a highly secure system, consider moving to SQL Server.