Access Skills for Job Interview

[James]

Hi there, I have a job interview next week and they will be assessing my
technical skills (just through discussion I believe). The job involves using
Access but I haven't used Access properly for over a year as I have been
studying Oracle 9i and SQL*Plus.

I would like to ask what Access skills should I revise/learn for next week?
I appreciate that there isn't a lot of time but I think having at least some
knowledge of the main Access features used by a business would be
advantageous.

Further info: The company uses it's Access DB with Visual Basic and SQL
Server (as well as ASP I believe). The company doesn't use .NET though.

Any opinions or info would be great. Thanks.

[Steve Jorgensen]

If you will be using Access from ASP, then make sure you're up to date on
classic ADO and the MS JET syntax as used via ADO. The skills it sounds like
they would be expecting to see in the Access environment itself would be table
design, query design, and use of the relationships window. They'll probably
expect to see some just trivial form and report design skills, but nothing
obscure.

On Thu, 20 May 2004 16:14:41 +0000 (UTC), "James" <no************@yahoo.com>
wrote:

Hi there, I have a job interview next week and they will be assessing my
technical skills (just through discussion I believe). The job involves using
Access but I haven't used Access properly for over a year as I have been
studying Oracle 9i and SQL*Plus.

I would like to ask what Access skills should I revise/learn for next week?
I appreciate that there isn't a lot of time but I think having at least some
knowledge of the main Access features used by a business would be
advantageous.

Further info: The company uses it's Access DB with Visual Basic and SQL
Server (as well as ASP I believe). The company doesn't use .NET though.

Any opinions or info would be great. Thanks.

[XMVP]

"James" <no************@yahoo.com> wrote in message
news:c8**********@sparta.btinternet.com...

Hi there, I have a job interview next week and they will be assessing my
technical skills (just through discussion I believe). The job involves using Access but I haven't used Access properly for over a year as I have been
studying Oracle 9i and SQL*Plus.

I would like to ask what Access skills should I revise/learn for next week? I appreciate that there isn't a lot of time but I think having at least some knowledge of the main Access features used by a business would be
advantageous.

Further info: The company uses it's Access DB with Visual Basic and SQL
Server (as well as ASP I believe). The company doesn't use .NET though.

Any opinions or info would be great. Thanks.

Just tell them you studied under Larry Linson!

[Salad]

James wrote:

Hi there, I have a job interview next week and they will be assessing my
technical skills (just through discussion I believe). The job involves using
Access but I haven't used Access properly for over a year as I have been
studying Oracle 9i and SQL*Plus.

I would like to ask what Access skills should I revise/learn for next week?
I appreciate that there isn't a lot of time but I think having at least some
knowledge of the main Access features used by a business would be
advantageous.

Further info: The company uses it's Access DB with Visual Basic and SQL
Server (as well as ASP I believe). The company doesn't use .NET though.

Any opinions or info would be great. Thanks.

I would hang out here for the next week and read the new messages. Most
job interviews...sometimes they want to see you 2 or 3 times...is to get
a measure of your skill set and what you can offer. Are you comfortable
with VBA? Hightlight that. Are you a wizard when it comes to creating
queries? Hightlight that. Do you create visually appealing forms and
reports? Mention that. Have you interfaced any apps with other apps
(Word/Excel)? Hightlight that. Will the job be maintenance work?
Highlite times you worked on and improved exisiting systems. Good at
designing systems from scratch? Highlight those projects. Mention you
are a great team player, eager and ready to go to work and hope for the
best.

BTW, how far did you get in Oracle, etc. Study only or have you done
any real work? That will help if they are using SQL server.

[Larry Linson]

"XMVP" <ac***********@hotmail.com> wrote

Just tell them you studied under Larry Linson!

Thanks for the vote of confidence, Don.

[James]

"Salad" <oi*@vinegar.com> wrote in message
news:jg*****************@newsread1.news.pas.earthl ink.net...

James wrote:

Hi there, I have a job interview next week and they will be assessing my
technical skills (just through discussion I believe). The job involves using Access but I haven't used Access properly for over a year as I have been
studying Oracle 9i and SQL*Plus.

I would like to ask what Access skills should I revise/learn for next week? I appreciate that there isn't a lot of time but I think having at least some knowledge of the main Access features used by a business would be
advantageous.

Further info: The company uses it's Access DB with Visual Basic and SQL
Server (as well as ASP I believe). The company doesn't use .NET though.

Any opinions or info would be great. Thanks.

I would hang out here for the next week and read the new messages. Most
job interviews...sometimes they want to see you 2 or 3 times...is to get
a measure of your skill set and what you can offer. Are you comfortable
with VBA? Hightlight that. Are you a wizard when it comes to creating
queries? Hightlight that. Do you create visually appealing forms and
reports? Mention that. Have you interfaced any apps with other apps
(Word/Excel)? Hightlight that. Will the job be maintenance work?
Highlite times you worked on and improved exisiting systems. Good at
designing systems from scratch? Highlight those projects. Mention you
are a great team player, eager and ready to go to work and hope for the
best.

BTW, how far did you get in Oracle, etc. Study only or have you done
any real work? That will help if they are using SQL server.

I have only studied it I'm afraid. I have looked at object DB's and all of
the fundamentals (stored functions, procedures, etc. PL/SQL, Distr. DBs).

Thanks for the excellent replies so far. I will definately use a lot of the
advice.