By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,666 Members | 1,909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,666 IT Pros & Developers. It's quick & easy.

Path to a "personal knowledge database"

P: n/a
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!
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
If you are looking for something easy to start with, MS Access is
probably a good place to start. You will be able to find a google
group with plenty of help for this. Also, have a look at
www.mvps.org/access as this is where I learnt a lot of my MS Access
development and I recommend it very highly.

Yasso Picasso <ya**********@hotmail.com> wrote in message news:<3f***********************@news.frii.net>...
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!

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.