Of the people on this forum that use the Access section how many have actually taken a class in Access?

I have not.

By "take a class" do you mean taught a class?

Col

Back in 1997 I got to go to 40 hours of on-hours training for Access (Tables, Queries, Forms, Macros and Reports) at Boeing. That got me my initial push into the world of Access. I then bought several books to use, but I didn't start learning VBA until 3 years later.

While at Group Health Cooperative in about 2000, I also took an official Microsoft class - MS1300 Mastering Access 2000 Programming so that I could get the ADO programming info I desired at the time.

The rest has been either from books, websites, this forum, or trial and error.

By "take a class" do you mean taught a class?

Col

Yeah taught. I guess Online classes would count and if an experience friend throughly taught you.

I've never done any Access teaching

Col

I've never done any Access teaching

Col

That was never the question..

Basically found relational databases viz Access during M.Sc course and basically got hooked.

Done a couple of other courses Open University, Leaning Tree... but of course experience and the people on this Forum have been the best training.

I have tried and am still trying to educate people where I work but some are being persistently thick and cannot see what Access and databases have to offer. Hmmmm mainly Senior Management it seems... maybe they believe that I (being so old) am not up to date with my ideas....or maybe I can di it and they cannot is the problem

I tried a number of variations - inhouse training, online training, books etc.

This is the most useful source because of the give and take. Most training courses (including the Microsoft online examples) are by their nature generalizations. These forums teach more effectively because they answer specific questions.

Never took an Access class. What I know, I know from doing.

However, I took classes in other DB products - ORACLE (you've heard of them) and SHAREBASE (now defunct). Plus at least a smidgen of set theory and some independent studies in interrogatory logic. (I.L. = The logic of whether an answer and a question when taken together are TRUE, i.e. does the answer really satisfy the requirements of the question?) You should know that SQL depends on this type of logic, whether consciously or not.

That was never the question..

In the UK, if you say "have you ever taken a class" means have you ever taught a bunch of people - as a teacher.

If you mean going to classes yourself - in the UK we say something like "have you had access training in a night school or college" or something similar

Which is why I asked "By "take a class" do you mean taught a class? " you said yes - taught, so I said I have never done access teaching. Now you say that wasn't the question.

What exactly is the question?

Col

Well I guess we both read into it our own ways. You said

By "take a class" do you mean taught a class?

I took it as, Yes, TAUGHT a class. Meaning someone TAUGHT you. You were thinking of it as "did you TEACH a class."

All in all I mean "have you had access training in a class." Forgot about the language barrier on this forum.

Attended may be the better word. When you start using taught it's no wonder there's confusion. When you answered Col's question it seemed explicit to me that you were asking if anyone had lectured rather than attended a class.

Attended may be the better word. When you start using taught it's no wonder there's confusion. When you answered Col's question it seemed explicit to me that you were asking if anyone had lectured rather than attended a class.

Yeah sorry about that, but if you read my first post I think I was pretty apparent with what I was asking. I also should've asked if they had any other database/programming experience. Anyway lets get more voterS!!!

Yeah sorry about that, but if you read my first post I think I was pretty apparent with what I was asking.

If it was pretty apparent, I wouldn't have asked for clarification.:rolleyes:

The rest of the world doesn't share the USA's wierd way of saying things (thank god)

Col

I learned VB, Access, C, Cobol and Oracle in college. I first worked with VB since I wasn't very good with databases and C and Cobol were obsolete, but there was more work with databases than pure programming. Since Access was closer to VB than Oracle, I followed that path. I started visiting this forum to get better and, now, I am starting to like it. I do VB has a hobby, Access for money and websites and hardware for extra money when I have the time. When I have more time for myself, I'd like to learn Java.

I've never taken a class, but I have taught one.

Back in 1978 I had a class in BASIC... that was it for formal computer training :)

...as an ado I was a proof reader for my father before that helping to debug FORTRAN COBOL APL and RPG, he paid me a whole dollar for a days work which was excellent money for a kid back in the day :D ...

BASIC? He he, I remember that too, high school in the early 80's, IF THEN ELSE GOTO, not to mention saving programs on tape casettes, woo...only Access training I've had was as part of an Office XP class I took in '03. Any additional help I've gotten was online, no offence to this forum but for Access questions I ask at MDBMakers :cool: , excellent advice to be had there and not as heavily trafficked as this forum. I post as kauchen there in case anyone's checking...

no offence to this forum none taken here, different preferences rule for each person.
but for Access questions I ask at MDBMakers
I don't like the format and I can find posts here and answer posts much easier, at least in the presentation. So, my preference is the vBulletin style and others, including MDBMakers, UtterAccess, and the MS forums, just don't do it for me. But, hey - that's MY preference.

Again, no offence to this forum, I wasn't even aware it existed until I'd followed a link on MDBMakers. Additionally, my dba responsibilities have shifted a bit in the last year, previously I was charged with taking an unworkable inherited Access db and making one that would work for producing program reports, and was quite successful in doing so if I may be so bold, with some assistance from the kind folks over at MDBMakers, which was at the time my primary source of online Access advice. Unfortunately program management has decided to go the route of using an off site provider for ongoing database needs, we're using an application which has a front end written in C+++ and a back end on SQLServer, and is primarily a case management rather than reporting tool, which also unfortunately doesn't work for s**t. Note to anyone looking at third party providers for your database needs, do not go with *ata *ystem *nternational's product *lient*rack (name obscured for privacy), the thing seems to have been designed by mediocre students. No referential integrity, no parallel structure in the setup of data elements, is incompatible with any version of IE more recent than 6.2, completely incompatible with FireFox, and the training and support, in a word, sucks. My joy in life is to admin the thing. I've killed a lot of free time designing an Access application that would generate the requested reports but so far have received no management support for implementing it, they'd rather keep throwing good money after bad I guess.

BASIC? He he, I remember that too, high school in the early 80's, IF THEN ELSE GOTO, not to mention saving programs on tape casettes, woo...only Access training I've had was as part of an Office XP class I took in '03. Any additional help I've gotten was online, no offence to this forum but for Access questions I ask at MDBMakers :cool: , excellent advice to be had there and not as heavily trafficked as this forum. I post as kauchen there in case anyone's checking...

saving programs on tape casettes wow you were spoiled by modern technology... we were using paper ticker tape for programs and cards for data...:)
just tried to look see at MDBMakers - looks very slick but definately NOT for those of us with dial-up speed...:eek:

Self-taught with A LOT of help from members of this board.
:)

none taken here, different preferences rule for each person.

I don't like the format and I can find posts here and answer posts much easier, at least in the presentation. So, my preference is the vBulletin style and others, including MDBMakers, UtterAccess, and the MS forums, just don't do it for me. But, hey - that's MY preference.

Again I would like to apologize for any implication I might have made that the help on MDBMakers was of any better quality than what is available here. I never meant to imply such, and did first become aware of this site while I was researching an issue I was having with exporting some data from Access to Excel in an acceptible format, a solution for which I found here but due to my organization's policies on downloading external applications, and my lack of advanced skills, I would have been unable to implement. Eventually I did receive coaching on a method I could accomplish over at MDBM.

I've been feeling like an ass for spending far too much time trying to debate with this forum's two resident trolls without actually checking out the available instruction on this site, and after spending some time following the technical threads I must state that the help available here is outstanding. Thank you (all of you here who take the time to help) for sharing the benefit of your skills and experience.

I've been feeling like an ass for spending far too much time trying to debate with this forum's two resident trolls

Who forced you to, was somebody holding a gun to your head, maybe there was something missing in your life?:confused: :rolleyes:

Who forced you to, was somebody holding a gun to your head, maybe there was something missing in your life?:confused: :rolleyes:

Nice to see you self identifying as a troll, Rich. Debating trolls is ultimately a futile exercise, but taking a stand against someone who is a racist, misogynist, homophobe, disrespectful of the sacrifices made by those who serve their country in the armed forces and is in general an all out tasteless, arrogant, incompetent, condescending fornicating rectum (please feel free to make use of dictionary.com to find the more vulgar and obscene synonyms for these last two words, I would not want to stand accused of not speaking down to your level, as Col suggests one must do in a debate) is just the right thing to do. I do hope that answers your question.

Nice to see you self identifying as a troll, Rich..

Where?:rolleyes:

Debating trolls is ultimately a futile exercise, but taking a stand against someone who is a racist, misogynist, homophobe, disrespectful of the sacrifices made by those who serve their country in the armed forces and is in general an all out tasteless, arrogant, incompetent, condescending fornicating rectumn
Who are you talking about?:confused:

Debating trolls is ultimately a futile exercise, but taking a stand against someone who is a racist, misogynist, homophobe, disrespectful of the sacrifices made by those who serve their country in the armed forces and is in general an all out tasteless, arrogant, incompetent, condescending fornicating rectum
Nah, don't put yourself down - you'll come through it, stick with us and we'll see you ok.

Col

Debating trolls is ultimately a futile exercise
This isn't written in composed English, is it? :rolleyes:

Nice to see you self identifying as a troll, Rich. Debating trolls is ultimately a futile exercise, but taking a stand against someone who is a racist, misogynist, homophobe, disrespectful of the sacrifices made by those who serve their country in the armed forces and is in general an all out tasteless, arrogant, incompetent, condescending fornicating rectum (please feel free to make use of dictionary.com to find the more vulgar and obscene synonyms for these last two words, I would not want to stand accused of not speaking down to your level, as Col suggests one must do in a debate) is just the right thing to do. I do hope that answers your question.

I guess he told it like it is :D :D :D :D :D :D :D :D

My only formal computer training was in college - a course on Fortran IV on an IBM 360 in 1968.

I am self-taught (books and forums) in both Excel and Access - perhaps it shows. ;)

My first Access project was literally trying things until they worked, then eventually having someone check and make recommendations. I went through five iterations of the project over the past six years. Each time starting from scratch. I finally had it working well (all iterations gave correct data in queries, just not efficient or well designed), and then the company hired outside vendor to host it on a web site for multiple points of access, meaning that Access was outgrown (I work for a Fortune 50 company with 60,000+ employees).
________
PLYMOUTH X2S HISTORY (http://www.dodge-wiki.com/wiki/Plymouth_X2S)

I have not. Although August 1, 2 I will be attending an advanced class - a first for me.