I am looking for someone to design me a simple data base (I'd be happy with an off the shelf "library" type database which I thought would be easy to find but have been unable to do so). This is my first use of Freelancer so if I missing something you need please let me know. My apology too if my "skill" criteria is a little off as I am not an IT person.
I want to be able to use the data base myself so it should not require any specialist knowledge. I want it to store info on books and a wide range of documents (hard and soft copy) as well as on-line links which I use for research.
Once it is complete which will store at least the following information/fields and allow me to make basic changes (by addiing to the drop box fields).
Note, it will be used for thousands of documents / books and so needs to be able to carry that load. I have been told that because of this Microsoft Access will NOT do the job. Below is a summary of what I am seeking - attached is a more expanded description based on a database I had about 10 years ago which is no longer available (note - recommendations for enhancements are always welcome):
1. Category of information - drop box selection, ability to add new fields
2. Subject (this is a sub category but in a separate field)
3. Title of the document / data item
4. Date of the data - field must cater to options of Month and Year / or Year only / or Undated
5. Source - this relates to where the document comes from - government agency, consultant, etc
6. Publication type: - drop down - eg. seminar paper / journal article / book /presentation / court decision / opinion
7. Jurisdiction - i.e. to which the information relates - eg. National particular state or territory, Country
8. Quality- short field - drop down for a quick option - High, Medium, Low
9. Use - drop down for a quick option - Advice, Blog, Precedent, Background / Overview / Presentations - option to add fields
10. Location - this is for storage - drop box options to designate where the matter is filed - will supply some fields but also ability to add more and free text option also
11. Author
12. URL link for matters on the internet
13. Page count
14. Abstract - free text field
15. Keywords (used to increase search ability)
16. Soft copy - link option where a document is on my system
17. Organisation (to which the information relates) - eg this will be the name of a Govt department, company, association or individual
Plus Search across different fields, prepare reports and be able to print same.