Any help is appriciated

[nik707]

Hello all,

Sorry for being new and asking alot of questions. I see alot of helpful people here so hopefully someone might be able to help me out.

I am a research student and during the upcoming semester, I have to scan newspaper articles (using OCR - they read the text and save as word documents)

Then I have to take about 10 bits of information from those articles (such as Date, Author, Publication, Concerned Geographic Area, Sector and so on) and input them in to a database.

This database should be searchable using all those 10 fields and the proff requires to import this to a website where other users can also search using the 10 fields.

Remember, I really don't need to search the documents themselves, just the 10 fields I input.

(1) Which database is best for this? I understand Access is one of the best however, (2) is there a way I can design a form from where the proff can do a search? (I know from forms you can input data in to the database but can you do searches?)

(3) Is it possible to click an executable file and it will open up this form, where a normal end user can search the database?

Any suggestions are also welcomed!

Thank you very very much in advance!
Cheers,
Nik

 

[namliam]

1) Access generaly speaking is not the best for online purposes, better to use MySQL or SQLServer or somesort...

2) Yes you can, have a search on the forum, many examples should be available.

3) No executable, but why need the DB, when you have the online version?
You can however (if you like) make the DB open the form "on startup"

 

[nik707]

thank you very much! that cleared up alot!!