Greetings,
I have to admit that I'm still a beginner in the database field, but I'm
actively studying, and this is why I will be utterly grateful for the
proper, accurate, and wise guidance to the right direction or specific
paths of database studies.
I simply want to make my first major database project a "personal
knowledge database" or a "personal encyclopedia", so to speak. By this I
mean that I want to gather diverse, multi-format bits of knowledge into
a single database divided into major categories, sub-categories, and so
on. For example, I want to scan collected articles from newspapers &
magazine and save them as images, type hand-written notes into the
computer and save them as MS Word or Text files, save audio files with
searchable keywords, even save searchable MS OneNote audio & text files,
all into directories & sub-directories. Then I want to be able to search
all these files for specific words or subjects; sort them according to
date, subject, etc; update, add to or append, edit, or even cut & paste
(within) any of those records in the database, which rely on easily
customizable formats like text & images (in contrast with audio files or
OneNote files, for example).
I also want to prevent wasting time in the future, by avoiding
repetitive, same-keywords typing for every non-text new entry, like an
image or audio file, by having a customizable keyword list open (by
right clicking for example), where one could mark all the relevant
keywords for the picture or audio file. Also have a short description
for each one of those entries when needed. And I want to be able to add
slick, good-looking graphics to the interface of the database and the
forms of the records.
Basically, my priorities include: saving time filling the database with
knowledge, quickly & accurately finding the future targets of any
search, presenting the search results in a highly comprehensible &
organized form, and a good looking interface & forms for every entry,
which are pleasing to the eye and encouraging to study.
I already use graphics applications for the "looks" part. So my question
is: what are the technologies or applications that I should learn by
heart and use in order to design such a database in the best way? Would
MS Access alone do it all for me? Or should I learn other technologies?
I'll be grateful for anyone taking the time to help. Thanks.
Sincerely,
Yasso
"Claiming that God does not exist because there are people suffering and
dying is like saying that barbers do not exist because there are people
with long hair! Truth is: they suffer because they did not find God or
do not go to Him, just like the others did not find a barber or do not
go to one."
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!