Regi said:
Hi,
I am a self taught begining Access user. I would like to learn more. What
should I concentrate on? VBA, SQL, both, something else?
Thanks for your advise.
PS I LOVE this discussion board and it has helped me alot.
There is the number of things I would consider. First, I would get a good
book on VBA and access. The one I have sitting on my shelf I think is almost
ten years old now, it was really an excellent investment. it had one chapter
with I think what 80 pages just on menu bars alone. the book I have was from
the unleashed series, and was actually called "visual basic for
applications".
There is a list of goods suggested books here:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html
another thing to do is to start considering using some of the more advanced
software features of the VBA. For example, have you tried using class
objects in access?
I explain when, how, and even why you should use class objects in access
here:
http://www.members.shaw.ca/AlbertKallal/Articles/WhyClass.html
and, the other area doesn't hurt to do any learning is to continue to get
better at and learn the structured query language (sql). of anything I've
ever learned in computer software, the investment of time and learning SQL
was likely the best investment I ever made. Even if you're not using access
any more, if you use oracle, you go off and learn.net, FoxPro or anything
else you use, virtually all of these information management systems will
continue to use sql. I was first exposed to SQL in 1991, when I was doing
some work in FoxPro. While FoxPro as a programming language for me is a
distance memory, I still today use SQL. if you go off and design a web site,
or just about any other piece of software with any platform, you're likely
still going to be exposed to SQL.
I've written software using assembler, I've written payroll systems from
scratch in Pascal, I've worked on D3, and IBM "Universe" multi-valued
database systems. So, I learned and used a good number of programming
languages over the years. The one constant, and the ONE thing that I still
the use all the time is SQL.
So I highly recommend to continue to learn and use SQL, as it is a common
means by which you who will grab data from a database. You use sql with MS
access, Microsoft SQL server, MySql, or even Oracle etc.
Learning database technology is a good in vestment of your time. Along with
sql, TOP OF MY list is to continue to improve your ability to normalize your
data. Thus, good data normalizing skills is the TOP thing I look for in a
developer. So keep learning SQL, and keep improving your skills in
normalzing your data.
I also wrote an article a number of years ago about converting an
application from an old mainframe system into MS access. suggest you read
the following story and process that I used for tihs project here:
http://www.members.shaw.ca/AlbertKallal/Articles/fog0000000003.html
In the above artcile I speak of certain criteria, and certain skill sets
that I believe are necessary as developer to complete the task.