Did you gain your Access knowledge through books, trial-error/courses....or internet?

[Brianwarnock]

Len I think that was a bit of an over reaction, I never said it was all trial and error and gave an example of when it can be, nor did I suggest that trial and error does not require some knowledge and some logical thought, if you don't know the syntax and have nobody or no documentation to tell you , then you have to try, and if you don't get it right first time that's an error thus trial and error, admittedly some people just ask the forum.

brian

 

[MrsGorilla]

Oh, and everything I know about the world I learned on this forum too, from Rich and Col.

You poor thing.

 

[Jacob Mathai]

I was a Query user (QMF) in in IBM VM environment. It's is the mirror image of DB2 in MVS in evironment. I learned about tables and queries. Back in the 1980's I learned the BASIC language and especially arrays. Our IBM machies went away and we are now using SQL Server and Oracle. I work for a big company. Combining my QMF knowledge and BASIC knowledge, Iwas able to do MS ACCESS. We use ACCESS 2003. I like VBA. It is a rapid delelopment environment great for dept or function level activities.

I really enjoy using MS ACCESS. I am not great with EXCEL. Since I can do everything with MS ACCESS, I am happy with it.

This forum had been a great help for me. I have a sample data base where I have saved a lot of techniques I got from this forum. I still use arrays to save Record sets for easy manipulation and speed.

 

[Len Boorman]

Brian

Yup got carried away a bit . I have a bit of a thing about skills, that's the problem. I find that people with skills very frequently underestimate their own but recognise skills in others. We refer to trial and error fairly frequently and it can be interpreted as a very hit and miss affair. Frequently the skilled person's hit and miss is a very structured approach breaking new ground in an uncertain environment.

Basically then I agree trial and error is a valid development tool but the definition of trial and error is far from a random attempt to get a result.

hmmm getting a bit serious isn't it.

Back to the whisky

Len

 

[frozbie]

Everything, but primarily driven by need to know

For me, the easiest way to learn has been faced with a project that needed completing and having to find any means of getting it done.

There are some great books out there, Mastering Access 2000 Development by Alison Balter is the number one book on Access; Books on Excel VBA have also been useful as the programming concepts translate well.

Forums such as this one are extremely useful but can take some time to find those nuggets of gold, still, that in itself can be valuable as one comes across items that prove useful later on...

I did an HNC in Computing which covered Access 2000. But, by the end of the course I was asking questions my tutor couldn't answer and finding solutions myself, primarily because I was at the same time working on a project for work that HAD to be completed on time.

Being able to ask friends is great but to be honest, all of my friends glaze over when I talk about coding...

Mark

 

[Len Boorman]

.... finding solutions myself....

Mark

Means you reached the "critical mass" of knowledge that will enable you to teach yourself basically. Also to be able to take "nuggets" and develop them yourself and used them in ways that were never intended.


Then things get really interesting and you find yourself getting really involved

Yeah people do glaze over when you start talking about really interesting things. Found that myself

L