Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 11-24-2011, 06:19 PM   #1
In Runtime
 
atomichybrid's Avatar
 
Join Date: Apr 2007
Posts: 174
Default Looking for a user-friendly database software

Hi there fellas,

I'm in need of a database software that is easy to use. My intentions for using that software is to build a student database with names, contact details, guardian info, subjects and so forth. I would prefer the software to operate offline since the work place has no internet. I'm currently using excel and its not very good since the typing and placing the order is such a hassle. If you can name some software that I can venture that would be great, free software is preferable but if there is a paid that does a real good job then I don't mind buying.

Cheers.
__________________

__________________
|ASUS N56VG|i7-3630QM@2.40 GHz|8GB DDR3 RAM|NVIDIA Geforce GT 650M 4GB|512 GB Crucial M500 SSD|1TB HDD|
atomichybrid is offline   Reply With Quote
Old 12-16-2011, 12:46 AM   #2
..m.0,0.m..
Site Team
 
iPwn's Avatar
 
Join Date: May 2010
Location: USA
Posts: 3,870
Default

I've looked for free solutions myself and didn't find anything of interest. I did, however, find FileMaker. It's a little pricey so if you download the free version, don't put too much work into a database unless you're willing to purchase the software. The reason I never went for that software was that the file format is proprietary and you can't really do anything with the file once you create the database... at least you can't in the free version.
You said that you're already using excel... why not upgrade to a version of Office that includes Access? The new version, with all it's wizards, can be pretty easy to use. You can create the database, forms to view/search the database and create links to Excel files that export reports for use in charts, graphs, etc.
__________________

__________________
Me: You'd think as the dominant species we wouldn't be so effing stupid.
J: We're just intelligent enough to be completely effing stupid.
iPwn is offline   Reply With Quote
Old 12-16-2011, 08:05 AM   #3
Daemon Poster
 
Dngrsone's Avatar
 
Join Date: Nov 2006
Location: 'Murica
Posts: 951
Default

There's no such thing as a user-friendly database. Excel is the closest thing to that I have found. I use Open Office Base because it is free.

We have Filemaker at work-- pile of crap. At least it is the way my company uses it-- central database with one computer running the DB and others acting as remote clients; the database crashes on a regular basis, it takes forever to load on the computer and you can't do anything else because the splash dominates the window.
__________________
Civility, Substance, Subtlety, Style: Success
Dngrsone is offline   Reply With Quote
Old 12-17-2011, 11:46 PM   #4
..m.0,0.m..
Site Team
 
iPwn's Avatar
 
Join Date: May 2010
Location: USA
Posts: 3,870
Default

Quote:
Originally Posted by Dngrsone View Post
We have Filemaker at work-- pile of crap. At least it is the way my company uses it-- central database with one computer running the DB and others acting as remote clients; the database crashes on a regular basis, it takes forever to load on the computer and you can't do anything else because the splash dominates the window.
Interesting... I never really made a large enough database with access to 'stress test' the program. Good to know.
__________________
Me: You'd think as the dominant species we wouldn't be so effing stupid.
J: We're just intelligent enough to be completely effing stupid.
iPwn is offline   Reply With Quote
Old 12-21-2011, 02:47 AM   #5
Beta Member
 
Join Date: Dec 2011
Location: USA
Posts: 4
Default

I think the MySql can be declared as the most friendly data base software.I did not find any better data base soft ware better than MySql.But the choice is yours but this one is quite awesome and best.
Malcom is offline   Reply With Quote
Old 12-21-2011, 10:40 AM   #6
Golden Master
 
Tommy Boy's Avatar
 
Join Date: Jul 2004
Location: USA
Posts: 8,463
Send a message via Yahoo to Tommy Boy
Default

Give Openoffice a try, it's free so if you don't like it you can just get rid of it and try something else.
__________________
When all else fails...Ham Radio!

I still have the same old HP DV9700T laptop I've had for years...still kickin'
Tommy Boy is offline   Reply With Quote
Old 12-22-2011, 05:44 AM   #7
Site Team
 
root's Avatar
 
Join Date: Mar 2004
Posts: 7,999
Default

I think I know your problem.

Excell isn't database software.

try using Access.
__________________
I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
root is offline   Reply With Quote
Old 12-23-2011, 05:43 AM   #8
Beta Member
 
Join Date: Dec 2011
Location: india
Posts: 5
Default Re: Looking for a user-friendly database software

Both SQL Server and Mysql are compatible and user friendly. You can get any one of them. If you dont want to spend few more bucks on database then you can opt for Mysql because it is pen source database and you can easily get it from online.
jaspertailor is offline   Reply With Quote
Old 12-25-2011, 04:17 AM   #9
In Runtime
 
atomichybrid's Avatar
 
Join Date: Apr 2007
Posts: 174
Default Re: Looking for a user-friendly database software

Quote:
Originally Posted by root View Post
I think I know your problem.

Excell isn't database software.

try using Access.


Yep I know that Excel is not a database software its more of a data analysis software and I use it quite often, the only reason why I'm using it is, its got the cells that you can fill like a form and I do want to get a better software to take over it. Its just currently for temporary use.

---------- Post added at 08:17 PM ---------- Previous post was at 08:01 PM ----------

I've tried the filemaker trial and I must say it does work but the whole interface looks confusing and there seems to be no way to work around it so I immediately ditched it.

I have heard of OpenOffice, a friend recommemded it for me and it seems to work nicely but I do feel that I need some tutorials for it. I would like to know does Access have better features than OpenOffice? because the price for the package with access is exorbitant and there is no point in buying the upgrade if theyre merely the same, other than that I would stick to OpenOffice and look for tutorials for now.

I also had a look on MySQL and it seems simplistic but I feel its more internet based than offline. Im not sure if thats the case im basing it on reviews and screenshots since its on a web browser and like what I said in the begining theres no internet at the work area since it was opened for a few weeks and the internet signup has been delayed and I would need to process some student information.
__________________
|ASUS N56VG|i7-3630QM@2.40 GHz|8GB DDR3 RAM|NVIDIA Geforce GT 650M 4GB|512 GB Crucial M500 SSD|1TB HDD|
atomichybrid is offline   Reply With Quote
Old 12-25-2011, 08:03 AM   #10
Daemon Poster
 
Dngrsone's Avatar
 
Join Date: Nov 2006
Location: 'Murica
Posts: 951
Default Re: Looking for a user-friendly database software

I am not a DBA or anything, and my experience in programming databases is limited to hacking existing DBase3, DBase4 and Access DBs and building my own using ooBase (the Access equivalent data base component of Open Office.org suite).

Both ooBase and Access have similar capabilities; MySQL is more powerful, but it is unlikely that you will need that much power for what you want to do.

In my opinion (being more of a hardware guy than programmer), none of it is easy, but there are plenty of tutorials out on the web for ooBase.
__________________

__________________
Civility, Substance, Subtlety, Style: Success
Dngrsone is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 06:38 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0