I Am New – Please Help

[drb]

Hello,

I am new to mysql. Not computer professional.

I would like to create and maintain a database of patient records. Can Sqlyog help to create such a database and also provide a nice GUI for user to input various items?

Is this different from microsoft access 2010? Which is easier?

Please help.

[peterlaursen]

Please detail: are you

1) Considering using MySQL versus Access as the database for storage?

2) Or considering Access versus SQLyog as a 'frontend' for MySQL?

In case of 1) we really cannot advice you here. That would depend on what kind of application (a web application or not for instance) and what programming language you want to use, whether it is a multiuser application or not, what platform you wnat to use (obviously you cannot use Access if you would ever deploy the database on a Linux server) etc.

In case of 2) I would clearly prefer a 'true' MySQL client with no dependency on ODBC and similar for most work. That does not exclude the option that from time to time you may connect to MySQL with Access for utilization of specific Access functionalities, like the Access 'report' feature (though I'd actually prefer OpenOffice/Base w. JDBC rather than Access w. ODBC in this particular scenario. The MySQL JDBC driver seems to me to work better and be better maintained than the ODBC driver).

[drb]

Thanks for the information.

[Author]

Posts