Newbie Question: Front Ends for MySQL

Okay...I've come to MySQL from a Microsoft Access background, where
it's easy to create data entry screens for users to easily enter
records. I have an understanding of how to set up MySQL databases and
using "Insert" to enter data.....yet I'm stumped about how I could
easily enter hundreds of records into the database.

Would I have to use something live Visual Basic to create a front end
to create data entry forms for the MySQL databse?

John:

> Would I have to use something like Visual Basic to create a front end
> to create data entry forms for the MySQL databse?

Yes, either that, or you make use of a MySQL data management tool like
PHPmyAdmin (which is not intended as an application for end users, of
course).

What would be your environment in which you have a MySQL-database?

--
Erick

On Jul 5, 8:58*am, John <slim...@gmail.com> wrote:
> Okay...I've come to MySQL from a Microsoft Access background, where
> it's easy to create data entry screens for users to easily enter
> records. *I have an understanding of how to set up MySQL databases and
> using "Insert" to enter data.....yet I'm stumped about how I could
> easily enter hundreds of records into the database.
>
> Would I have to use something live Visual Basic to create a front end
> to create data entry forms for the MySQL databse?

Take a look at http://microolap.com/products/database/mydbacentral/

Mikhail Oleynik schreef:
> On Jul 5, 8:58 am, John <slim...@gmail.com> wrote:
>> Okay...I've come to MySQL from a Microsoft Access background, where
>> it's easy to create data entry screens for users to easily enter
>> records. I have an understanding of how to set up MySQL databases and
>> using "Insert" to enter data.....yet I'm stumped about how I could
>> easily enter hundreds of records into the database.
>>
>> Would I have to use something live Visual Basic to create a front end
>> to create data entry forms for the MySQL databse?
>
> Take a look at http://microolap.com/products/database/mydbacentral/

why not start with this FREE product ?:
http://dev.mysql.com/downloads/workbench/5.0.html

--
Luuk

On Jul 5, 4:57*am, Luuk <L...@invalid.lan> wrote:
> Mikhail Oleynik schreef:


The front end/interface would not be Internet/web based. Basically,
our administrative assistants in the office would be used for data
entry and I need a nice, simple form that is linked to the MySQL
database. I would not want them to have to use cryptic (at least to
them) MySQL INSERT codes to enter the data.

I just checked out DBACentral for MySQL site and that seems to be a
viable solution (thanks).











>
> > On Jul 5, 8:58 am, John <slim...@gmail.com> wrote:
> >> Okay...I've come to MySQL from a Microsoft Access background, where
> >> it's easy to create data entry screens for users to easily enter
> >> records. *I have an understanding of how to set up MySQL databases and
> >> using "Insert" to enter data.....yet I'm stumped about how I could
> >> easily enter hundreds of records into the database.
>
> >> Would I have to use something live Visual Basic to create a front end
> >> to create data entry forms for the MySQL databse?
>
> > Take a look athttp://microolap.com/products/database/mydbacentral/
>
> why not start with this FREE product ?:http://dev.mysql.com/downloads/workbench/5.0.html
>
> --
> Luuk

Uh, the free version of workbench doesn't support connection to a live
database. It would be VERY difficult to enter data into a package that
doesn't actually connect to a database.

Workbench community edition seems to be more demoware than a fully
functional open source database application.

"Luuk" <Luuk@invalid.lan> wrote in message
news:8kp3k5-ued.ln1@qqqqq.xs4all.nl...
> Mikhail Oleynik schreef:
>> On Jul 5, 8:58 am, John <slim...@gmail.com> wrote:
>>> Okay...I've come to MySQL from a Microsoft Access background, where
>>> it's easy to create data entry screens for users to easily enter
>>> records. I have an understanding of how to set up MySQL databases and
>>> using "Insert" to enter data.....yet I'm stumped about how I could
>>> easily enter hundreds of records into the database.
>>>
>>> Would I have to use something live Visual Basic to create a front end
>>> to create data entry forms for the MySQL databse?
>>
>> Take a look at http://microolap.com/products/database/mydbacentral/
>
> why not start with this FREE product ?:
> http://dev.mysql.com/downloads/workbench/5.0.html
>
> --
> Luuk

John wrote:
> On Jul 5, 4:57 am, Luuk <L...@invalid.lan> wrote:
>> Mikhail Oleynik schreef:
>
>
> The front end/interface would not be Internet/web based. Basically,

Don't confuse a network with a tool. You can build very simple html
pages using PHP/MySQL to achieve the end goal. Think of IE/Firefox/etc..
as your application - and you can add it to their favorites making it
easy to access.

The only real difference is the VB/VC++/Access apps get installed on
every PC (or Citrix server) versus installing the app one time on a web
server, then all of your admins have access - even if they change
positions and move to a new desktop. And if you need to change the code
- you do it one time on the server.

You really don't have to spend weeks and months designing something that
needs to be purely functional - in fact - I prefer simple and
functional to whiz-bang in-your-face stuff all over my screen - most
sites today are designed with so much garbage, it makes finding the real
data very difficult.

The thing I have always liked about it is that I can mock up a
prototype, in most cases in < 1hr. If it is internal only - you can add
the whiz-bang links/functionality as necessary.

I once enabled one company to have access to weekly reports with ~10
lines cgi of code (before there was PHP/Python etc...) - this cut their
manual processing time by 80%. I have also replaced a "green-screen"
report viewer with a few more lines of code, but the end result was that
now, everyone that required access did not need to learn an out-dated
green-screen program. (Not that there is anything wrong with
"green-screen" - most car dealer service depts still use it...) This
particular project involved over 43,000 reports/month. The same "app"
gave them access to all of them with - really - very little effort. Then
I ported it from VMS/DCL to Perl -point/click (click,click) and they
have the results from the report - and not necessarily the entire
report. This also significantly reduced the time it took to get the
data required. (a side note: they never used the Perl version because
it would have cost them more than $1M to replace the running system to
get the same capability/throughput.



> our administrative assistants in the office would be used for data
> entry and I need a nice, simple form that is linked to the MySQL
> database. I would not want them to have to use cryptic (at least to
> them) MySQL INSERT codes to enter the data.
>
> I just checked out DBACentral for MySQL site and that seems to be a
> viable solution (thanks).
>
>
>
>
>
>
>
>
>
>
>
>>> On Jul 5, 8:58 am, John <slim...@gmail.com> wrote:
>>>> Okay...I've come to MySQL from a Microsoft Access background, where
>>>> it's easy to create data entry screens for users to easily enter
>>>> records. I have an understanding of how to set up MySQL databases and
>>>> using "Insert" to enter data.....yet I'm stumped about how I could
>>>> easily enter hundreds of records into the database.
>>>> Would I have to use something live Visual Basic to create a front end
>>>> to create data entry forms for the MySQL databse?
>>> Take a look athttp://microolap.com/products/database/mydbacentral/
>> why not start with this FREE product ?:http://dev.mysql.com/downloads/workbench/5.0.html
>>
>> --
>> Luuk
>

John <slimick@gmail.com> wrote in news:02aded1a-fcf0-49ec-854d-
c54af2e8708d@d77g2000hsb.googlegroups.com:

> Okay...I've come to MySQL from a Microsoft Access background, where
> it's easy to create data entry screens for users to easily enter
> records. I have an understanding of how to set up MySQL databases and
> using "Insert" to enter data.....yet I'm stumped about how I could
> easily enter hundreds of records into the database.
>
> Would I have to use something live Visual Basic to create a front end
> to create data entry forms for the MySQL databse?

Hi, I'm a HUGE fan of Navicat, which is a great GUI, and offers several
"converter" tools to import/export data. Plus, there's a free trial.

http://www.navicat.com/