I have been using Access 2000 for programming and want to transfer everything into SQL and learn coding. What class should I take?
I have been using Access 2000 for programming and want to transfer everything into SQL and learn VB coding. I am not sure how all these things are related. What class should I take?
- answers

Hi Sylvia,
Glad to help. Your right hiring someone to do the conversion would probably be a lot easier and maybe more cost effective. You could then take you time learning how to program for a SQL server. You might look into a few freelance websites where you can hire a SQL programmer to do that work. You might look at: http://www.elance.com, http://www.scriptlance.com, or even craigslist.com.


Hi Sylvia,
You should probably start by brushing up on SQL server programming and learn how to properly configure SQL servers. SQL databases and servers are used by over 60%-70% of today's websites. This is a platform that is not going anywhere for sometime. For example this very website is powered by a mySQL database. I would look into the following courses for your to learn more about database programming.
This first course is a very good intro course that will teach you to manage users and security, automate basic database tasks, import and export data.
http://www.distance-education.org/Courses/SQL-Server-169/Administering-Microsoft-SQL-Server-2000--SQL--978.html
If you want to learn further, this next course will go a step further and teach you all skills needed to administrater and program sql server. This online course comes with Microsoft SQL certification so you can obtain a Microsoft Certified Database Administrator (MCDBA) Certification.
http://www.distance-education.org/Courses/SQL-Server-169/SQL-Server-2000-Complete-Course-1604.html
I would start with those first few online SQL classes to help educate yourself on switching from Access to SQL.
- related questions
Can I take an online course in real estate approved by the State of West Virginia?
I have graduated from overseas with B.S. and M.S. of Mechanical Engineering. I am working in Electronics company at USA. How I can upgrade and what courses I need to take for Electronics and where? Does my cources from overseas are transferable?
What college has a PhD for business?
If I checked my application status for college and it says "UG application processed waived" what does that mean?