Welcome to the Small Business Ideas Forum! We are a community of over 100,000 small business folks with over 163,000 posts for you to browse. We pride ourselves on being the friendliest forum you will find and we'd love to have you as a member of our community. Please take a moment and register for a free account. If you need any help, please contact Chris Logan.

Small Business Ideas Forum

Small Business Ideas Forum

A friendly place to share small business ideas and knowledge, ask questions, find help and encourage others that are involved in the small business industry. Topics include small business marketing, generating revenue and small business computing.

Go Back   Small Business Ideas Forum > Small Business Computing > Computer Software
Register Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
Old 24th April 2009, 09:25 AM   #1
hrdatamanager
Member
 

Join Date: Jul 2008
Location: Calaveras County California
Posts: 78
Default Which Desktop Database For Your Small Business

Well, I guess I should admit right away that I am biased. I have developed in MS Access for over ten years while I worked with FileMaker for a few years for a client project.

There has been quite an argument between the PRO-FileMaker crowd and the PRO-Access crowd.

So, Which one is better? In my experience, that depends on what is needed and the level of experience of the person developing the database. FileMaker is geared toward people with no programming experience and is extremely easy to get started with. I personally find it to be somewhat limited in its scripting language, but is a great tool for many users. MS Access includes Visual Basic for Applications (VBA), a full programming language that gives the programmer a great deal of control.

While FileMaker is great for the database novice, I would use MS Access for any serious desktop database development.

Regardless of which desktop database system you use, any database that is not properly designed (relationships, normalization etc.) is likely doomed to failure.

Which one do you prefer and why?


__________________
Mark - Software Developer
www.hrdatamanager.com
hrdatamanager is offline   Reply With Quote
Register or log in to remove this ad.
Old 28th April 2009, 11:26 PM   #2
uyytuyt
Member
 

Join Date: Aug 2008
Posts: 42
Default

I would like to mention a more powerful desktop database Mysql, it is widely used on the internet web sites too, best of all, it's free.


Last edited by uyytuyt; 28th April 2009 at 11:39 PM.
uyytuyt is offline   Reply With Quote
Old 28th April 2009, 11:40 PM   #3
hrdatamanager
Member
 

Join Date: Jul 2008
Location: Calaveras County California
Posts: 78
Default

A quick note on MySQL, it is a great server based database and is Free as mentioned in the last post.

It is not however a desktop database that will allow a novice to easily build an entire solution including tables, views/queries, forms and reports from within one application as Access or FileMaker does. My SQL has become very popular on the web for use with PHP based web sites.

__________________
Mark - Software Developer
www.hrdatamanager.com
hrdatamanager is offline   Reply With Quote
Old 13th June 2009, 05:38 AM   #4
Elizabeth01
Member
 
Elizabeth01's Avatar
 

Join Date: Mar 2009
Posts: 84
Default

I think Intel Core will be the good choice for Desktop Database for small business.

______________
Bill management

Elizabeth01 is offline   Reply With Quote
Old 18th June 2009, 08:55 AM   #5
certifypers
Member
 

Join Date: Jun 2009
Posts: 27
Default

I think MS Access can be used for desktop database and I can think of any desktop today that will do this things for small business. However, MySQL can be set-up to be used to work with VBAs as part of a desktop application software.

certifypers is offline   Reply With Quote
Old 5th November 2009, 08:35 AM   #6
ashok
Member
 

Join Date: Oct 2009
Posts: 1
Default Open Office Base is the open source alternative to MS Access

Mark is right. MySQL is not an open source alternative to MS Access. It doesn't have views/queries, forms and reports from within one application as Access or FileMaker does. It is not packaged for the business user on the desktop.

The open source alternative to Access is Open Office Base.

If you check it out, let us know how it went!

ashok is offline   Reply With Quote
Old 12th November 2009, 03:54 AM   #7
InternetFilter
Member
 

Join Date: Nov 2009
Posts: 2
Default

Hi all,
As above discussion some of them saying that Intel core and MS Access is best for small business. I agree with these little bit. But as of my experience MySql is the best one for small business. I tried all these. But I struggled with these Intel and Ms Access. But I am comfortable with MySql.

InternetFilter is offline   Reply With Quote
Old 16th November 2009, 11:39 PM   #8
smartmind
Member
 

Join Date: Nov 2009
Posts: 38
Default

Hello fellows:
I come to know about the discussion going in this forum. I would like to advise you that Microsoft Access is the best database software for your desktop.

smartmind is offline   Reply With Quote
Old 1st December 2009, 03:32 AM   #9
rlane
Member
 

Join Date: Nov 2007
Location: Buffalo, NY
Posts: 20
Default

MySQL is a great database but it is not and end-to-end solution as it lacks the UI tools that MS Access provides such as Forms, Reports, etc. For desktop applications Access is the way to go.

On the flip side, I have seen some companies try to use Access as an enterprise storage solution which is not really what it was designed for. This is where MySQL comes into play.

rlane is offline   Reply With Quote
Old 14th January 2010, 08:09 AM   #10
Agur
Member
 

Join Date: Jan 2010
Posts: 8
Send a message via Skype™ to Agur
Default

I would suggest to try Oracle Database 10g Express Edition. It is made by the biggest database software creator in the world and it is free. It has also easy to use graphical user interface like an usual webpage. Very convenient. Give it a try.

Agur is offline   Reply With Quote
Reply   

Bookmarks


Similar Threads
Thread Thread Starter Forum Replies Last Post
newbie needs help: sole proprietership vs partnership shellies General Small Business Issues 5 12th January 2010 04:03 AM
Small Business Forum Update | March 12, 2008 Logan Archived Newsletter Threads 0 12th March 2008 02:07 PM
100 Small Business Audio Podcasts sannwood Small Business Trends Forum 4 24th August 2007 10:25 AM
Eshwar - Small Business Consultant And Business Support Services Provider eshwar New Member Introductions 6 13th November 2006 01:52 PM



Thread Tools

Get Updates
RSS Feeds:
RSS Feed for Computer Software RSS for this Category Only: Computer Software

RSS Feed for Small Business Ideas Forum RSS for Entire Forum
Forum Rules


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
Forum Jump


Small Business Ideas Forum


 
At Your Business - Small Business Directory
Free Business Forms - Prewritten Documents
 
Search Engine Guide
Small business guide to search marketing

 
Small Business Brief
Fetching the Best Small Business Info


Free Links - Free Advertising
Free Guide - Online Directory



Advertise your business here
Contact us for more details!


Semantic Juice
Register now to access free Quick SEO service!


Rocket Lawyer
Sign up for free 7 day trial. Boost your biz!


Buy UPC Codes
Get your products listed online!




All times are GMT -5. The time now is 06:11 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004 - 2018 - Privacy