Access tech questions?

[General Fear]

Does anyone in this forum know of tech questions for an Access
programmer? I have not been able to find a good web page with Access
tech questions.

I am interviewing Access programmers and want to conduct some tech
tests.

...

[Jason Lepack]

I'll give you some good ones if you're willing to interview me, and
you're in the Eastern Ontario area, prefereably close to Ottawa. ;)

On Jun 13, 5:57 pm, General Fear <[e-mail]:

Does anyone in this forum know of tech questions for an Access
programmer? I have not been able to find a good web page with Access
tech questions.

I am interviewing Access programmers and want to conduct some tech
tests.

..

[Steve]

Have you considered hiring a consultant on an as-needed basis? Could be less
costly than hiring a full time employee.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com


"General Fear" <ri*******@earthlink.netwrote in message
news:11**********************@j4g2000prf.googlegro ups.com...

>
Does anyone in this forum know of tech questions for an Access
programmer? I have not been able to find a good web page with Access
tech questions.

I am interviewing Access programmers and want to conduct some tech
tests.

..

[Tom van Stiphout]

On Wed, 13 Jun 2007 14:57:30 -0700, General Fear
<ri*******@earthlink.netwrote:

One thing you could do is open this forum, and have them respond to
the last 20 issues raised. You typically have enough answers to know
if they know their stuff.

One smart client of ours hired us to do the tech interviews. They did
the softer HR-style interview, and if candidate passed that, they
would send them to us for technical evaluation.

-Tom.

>
Does anyone in this forum know of tech questions for an Access
programmer? I have not been able to find a good web page with Access
tech questions.

I am interviewing Access programmers and want to conduct some tech
tests.

..

[Gary Floam]

If you are not an Access programmer, you won't be able to tell a good one from
a fourflusher or from a person who just thinks he/she is better than they are.
It's easy for a person to think that they "know" Access when they are just
beginners.

Gary

"General Fear" <ri*******@earthlink.netwrote in message
news:11**********************@j4g2000prf.googlegro ups.com...

>
Does anyone in this forum know of tech questions for an Access
programmer? I have not been able to find a good web page with Access
tech questions.

I am interviewing Access programmers and want to conduct some tech
tests.

..

[missinglinq via AccessMonster.com]

Amen to that, Gary! Judging by here and the other 4 forums I visit daily,
about 80-90% of all questions are posted by people who apparently took Access
101 in school and then told the boss they "knew" Access!

If it was me and I had zero knowledge of Access myself, I go thru an IT
personnel agency that provides people on an temp-to-hire basis. They have the
expertise to do all the vetting, if the programmer doesn't work out, you know
before you actually hire them.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200706/1

[Keith Wilby]

"missinglinq via AccessMonster.com" <u28780@uwewrote in message
news:73ab05bf622fe@uwe...

about 80-90% of all questions are posted by people who apparently took
Access
101 in school and then told the boss they "knew" Access!

I'd say that a good 30% of questions I read could be answered by a quick
visit to the help. Case in point: my suggesting "have you tried filter by
form?" was once answered by "what's that?".

Keith.
www.keithwilby.com

[Tim Marshall]

Keith Wilby wrote:

I'd say that a good 30% of questions I read could be answered by a quick
visit to the help. Case in point: my suggesting "have you tried filter
by form?" was once answered by "what's that?".

Since my apps usually rewrite recordsource SQL and then requery
according to a user's choices on various forms, I would also answer
"what's that?" 8)

I think it's very difficult to answer specific questions. Often the
questions that are crafted for such an interview are based more on the
interviewer's personal preferred practices that may not be the only way
to tackle a particular problem.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me

[Keith Wilby]

"Tim Marshall" <TI****@PurplePandaChasers.Moertheriumwrote in message
news:f4**********@coranto.ucs.mun.ca...

Keith Wilby wrote:

>I'd say that a good 30% of questions I read could be answered by a quick
visit to the help. Case in point: my suggesting "have you tried filter
by form?" was once answered by "what's that?".

Since my apps usually rewrite recordsource SQL and then requery according
to a user's choices on various forms, I would also answer "what's that?"
8)

No Tim, you'd search for "filter by form" in the help ;-)

Keith.

[Tony Toews [MVP]]

"Keith Wilby" <he**@there.comwrote:

>I'd say that a good 30% of questions I read could be answered by a quick
visit to the help. Case in point: my suggesting "have you tried filter by
form?" was once answered by "what's that?".

Yes but ... Quite often a person doesn't know what something is called. They know
what they want to do but they have no idea what the keyword is to look in help.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Tom van Stiphout]

On Thu, 14 Jun 2007 11:10:16 -0230, Tim Marshall
<TI****@PurplePandaChasers.Moertheriumwrote:

That may be true, and I do that as well. Companies often settle on
"best practices", and those questions are designed to gauge how much
remedial training an individual might need.
Also, you'd hope an all-round programmer has approached a particular
problem from different angles over time.
Also, you'd hope the candidate can at least defend his/her approach
even if it is not mine. For example I have on occasion disagreed with
David Fenton's suggestions, but I know they are not made casually and
I would enjoy the discussions.

-Tom.

>Keith Wilby wrote:

<clip>

>
I think it's very difficult to answer specific questions. Often the
questions that are crafted for such an interview are based more on the
interviewer's personal preferred practices that may not be the only way
to tackle a particular problem.

[Keith Wilby]

"Tony Toews [MVP]" <tt****@telusplanet.netwrote in message
news:lu********************************@4ax.com...

"Keith Wilby" <he**@there.comwrote:

>>I'd say that a good 30% of questions I read could be answered by a quick
visit to the help. Case in point: my suggesting "have you tried filter
by
form?" was once answered by "what's that?".

Yes but ... Quite often a person doesn't know what something is called.
They know
what they want to do but they have no idea what the keyword is to look in
help.

Well if someone suggested something to me I'd never heard of I'd check the
help first.

[Tony Toews [MVP]]

"Keith Wilby" <he**@there.comwrote:

>>>I'd say that a good 30% of questions I read could be answered by a quick
visit to the help. Case in point: my suggesting "have you tried filter
by
form?" was once answered by "what's that?".

Yes but ... Quite often a person doesn't know what something is called.
They know
what they want to do but they have no idea what the keyword is to look in
help.

Well if someone suggested something to me I'd never heard of I'd check the
help first.

That's not quite the situation I mean. And what if that person said something like
"Well, I saw something that worked like this." And this was whatever terminology
they felt comfortable with but wasn't on the list.

As an example I needed to open a second form from within VB 6.0 several years ago on
my Auto FE Updater utility. Which I'd never done before. Easy in Access. I spent
five minutes going through VB help and MSDN help. I finally hit Google newsgroups
help and had the answer on the second posting.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Chuck]

On Fri, 15 Jun 2007 16:10:18 GMT, "Tony Toews [MVP]" <tt****@telusplanet.net>
wrote:

>"Keith Wilby" <he**@there.comwrote:

>>>>I'd say that a good 30% of questions I read could be answered by a quick
visit to the help. Case in point: my suggesting "have you tried filter
by
form?" was once answered by "what's that?".

Yes but ... Quite often a person doesn't know what something is called.
They know
what they want to do but they have no idea what the keyword is to look in
help.

Well if someone suggested something to me I'd never heard of I'd check the
help first.

That's not quite the situation I mean. And what if that person said something like
"Well, I saw something that worked like this." And this was whatever terminology
they felt comfortable with but wasn't on the list.

As an example I needed to open a second form from within VB 6.0 several years ago on
my Auto FE Updater utility. Which I'd never done before. Easy in Access. I spent
five minutes going through VB help and MSDN help. I finally hit Google newsgroups
help and had the answer on the second posting.

Tony

In the process of trying to learn to program in VB6, it seems as though if you
don't know the answerer to your question, then you don't know how to phrase
your question. The help files in my version of VB6 are generic. That is they
cover C++, FoxPro, J++ and more. Only a small part is directly applicable to
VB6

Chuck
--