Solved

Professional Advise

Posted on 2014-10-03
3
90 Views
Last Modified: 2014-10-04
Extremely high-brow question here:  I recently built a pretty complicated/sophisticated Access-based database for my job and I think it's fair to say that my managers were more than pleased and impressed with the improvements this program brought to our department.  The thing is that I have absolutely no (none, zero, zilch) experience in database design… but I was able to put it all together and make it work by using a combination of Access Training Books, YouTube Videos and of course this website (plus 6 months of grueling hard-work).  

In any event… I'm now pretty sure that I have the 'bug' for database design, programming and software development… and I'd like to take it to the next level.  I live very close to a major University who offers all sorts of Masters Degrees in Computer Science and Information Technology/Engendering.  Of course I am also aware that a 'trade' like this has other, less formal avenues of learning opportunities (Private or Industry educators).    

My question is… does anyone have any advice or guidance as to how someone like me should best approach additional education and training in this field?
0
Comment
Question by:mdstalla
3 Comments
 
LVL 23

Accepted Solution

by:
Eirman earned 250 total points
ID: 40360988
The thing is that I have absolutely no (none, zero, zilch) experience in database design
This is of course no longer true ... You are to a degree an experienced database designer.

You could continue along the self taught route which has been successful to date. For this to really work you have to be actually working on real projects, fulfilling other peoples requests and tweaking design and function. Given that you have probably exhausted database design at work, you will have to look at designing  for other organisations such as charities where this won't conflict with your present employee status. Charities are always interested in the integration of Access databases with Word for the production of mailshots.

So do you need a formal qualification in database design or become a Microsoft MVP .... It depend on your age and whether you are happy being self-employed. Certain jobs require a qualification regardless of your skill level.
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 40361124
I went the self-taught route, with a few college course scattered here and there. When I first started out, I created a database for my family's HVAC business, and that was when the bug bit me. I did some freelance work for charities and such, helped with a few organizations (a small police department in Texas, for example, needed a way to keep track of donations and such, and I volunteered my services for that), and created my own projects for things I enjoyed doing (tracking scores in the world of competition bbq, for example). Eventually I felt competent enough to begin seeking out work from others, and that's what I've done ever since.

That's not to say that a more formalized course of instruction is bad. It may be exactly what you're looking for, but it wasn't feasible for me at the time. Looking back, I probably could have gotten where I am a little quicker had I taken the college route, but that's water under the bridge now.

If it were me, I'd concentrate on database design and such. Learn how to properly store data, regardless of the platform, and you'll be much further ahead of the game. Don't get bogged down in this language or that - learn how to handle data correctly, and how to STORE data correctly.

As far as programming languages - Access isn't really a language so much as it is a development environment, so while you can take Access courses, they're geared more towards the power user, and day-to-day data entry person, than development. IMO you'd be better off learning one of the .NET languages, or Java, or perhaps concentrate on the mobile platform (which is HUGE right now).
0
 

Author Closing Comment

by:mdstalla
ID: 40361566
Great advise-- thanks for the feedback.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now