473,573 Members | 4,115 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Just how good are you really?

Tim
Dear Developers,

Firstly, I'm not sure where this post should go so I apologise if this
is in the wrong group or area. I'm currently interviewing for a vb.net
developer who doesn't mind prototyping the client requirements using
MS Access. We've not had much luck in finding many suitable people
through agencies and those that I have interviewed are not scoring
very high on my little test which is the reason for my post.

Please have a go and send me an email with your answers, I'll happly
mark them and return the results to you! <tpodonnell at plls.co.uk>

Cheers,

Tim

p.s. Any developers interested in moving to .net from ms access then
drop me a line if your intersted in a position in Bristol ... good pay
and good security.

---------------------------------------------------------------------------
**These next two question assumes that you can see a database diagram
and question two has been omitted due to it's reference to this
diagram**
Question 1

The above diagram of figure 1.1 illustrates a diagram of the
organisational database system, what is meant by the term "E.R.D." in
the illustration description?

Question 3.

Assuming that this diagram is being viewed within SQL Server
Enterprise Manager, what do the * symbols indicate next to the table
names on the diagram.
Question 4.

The SQL statement detailed below is used within the above system, can
you describe what you think the developer is trying to achieve.

CREATE PROCEDURE [DBO].[SP_CURRENTUSER_ DATA]

@USER_NAME CHAR(30) OUT,

AS

SET @USER_NAME = TRIM(@USER_NAME )

SELECT TBL_PERSONNEL.P K_PERSONNEL_ID,
TBL_PERSONNEL.F K_ORGANISATION_ REF,
TBL_PERSONNEL.F K_MANAGER_REF,
TBL_PERSONNEL.F K_SECRETARY_REF ,
TBL_PERSONNEL.F K_TITLE_REF,
TBL_PERSONNEL.F ORE_NAME,
TBL_PERSONNEL.S URNAME,
TBL_PERSONNEL.D IRECT_PHONE,
TBL_PERSONNEL.M OBILE,
TBL_PERSONNEL.D IRECT_FAX,
TBL_PERSONNEL.E MAIL,
TBL_STAFF_INFO. PK_STAFF_ID,
TBL_STAFF_INFO. PASSWORD,
TBL_STAFF_INFO. PASSWORD_DATE,
TBL_STAFF_INFO. USER_NAME,
TBL_STAFF_INFO. ORGAN_ADMIN
FROM TBL_PERSONNEL,
TBL_STAFF_INFO
WHERE TBL_PERSONNEL.P K_PERSONNEL_ID =
TBL_STAFF_INFO. FK_PERSONNEL_RE F
AND TBL_STAFF_INFO.[USER_NAME] = @USER_NAME
GO

Question 5.

Do any errors exist within the above SQL statement?

Question 6.

Assuming that any errors are fixed what would you expect to happen if
you ran the above within MS Query Analyzer?

Question 7.

What would you add to this stored procedure to aid development within
a team environment?

Question 8.

What keyword(s) would you use when declaring a class to ensure that
you are able to catch any events that are triggered by the class after
it has been instantiated?

Question 9.

What are the two main advantages of Object Orientated Programming over
standard procedural languages?

Question 10.

Below there is a short snippet of code taken from one of our VB.NET
systems. Assuming that all external variables and classes have been
instantiated correctly, what do you think the main function of this
code is? Note: "opcAdditionalP roducers" is a class that has been
written specifically for the interaction of producer information and
GetAdditionalPr oducerInfoStatu s returns the DataRowState of a specific
row held within a local data-table within this class.

Private Sub PopulateProduce rListview()

Try
Dim ProducerLimit As Integer =
CType(opcAdditi onalProducers.C ountAdditionalP roducers, Integer)
Dim ProducerCount As Integer
Dim intIndex As Integer = 0

lstvwAdditional Producers.Items .Clear()

Do Until ProducerCount = ProducerLimit
If opcAdditionalPr oducers.GetAddi tionalProducerI nfoStatus(intIn dex)
<> DataRowState.De leted Then
lstvwAdditional Producers.Items .Add(opcAdditio nalProducers.Ge tAdditionalProd ucerAsListViewI tem(intIndex))
ProducerCount += 1
End If
intIndex += 1
Loop

If lstvwAdditional Producers.Items .Count > 0 Then
lstvwAdditional Producers.Items (0).Selected = True
End If

Catch excep As System.Exceptio n
'CATCHES ALL ERRORS
MessageBox.Show ("Message: " & excep.Message)

End Try
End Sub
Question 11.

Assume that the function "CountAdditiona lProducers" returns the total
number of rows that do not have a DataRowState of "deleted" from the
local data-table held within the opcAdditionalPr oducers class.

If this function returns a value of 15 and there are 10 rows within
the data-table that are have a DataRowState of "deleted" and 2 rows at
have a DataRowState of "modified", how many times would you expect the
"do loop" to cycle?

Question 12

The code detailed below has been taken from a standard MS Access
database application. Unfortunately the code will not compile
correctly, can you highlight any area(s) where you think an error is
present. Assume cnnLocal is a global connection to the local database.

Private Sub UpdateBordereau ()

Dim rst As New ADODB.command

If cnnLocal.State = adStateClosed Then Call OpenConnection

rst.Open "SELECT * " & _
"FROM TBL_BORDEREAUS " & _
"WHERE PK_BORDEREAU_ID = " & intBordereauID, cnnLocal,
adOpenKeyset, adLockOptimisti c

With rst
.Fields("MONTH" ) = cmbMonths.ItemD ata(cmbMonths.L istIndex)
.Fields("SUPPLI ED_DATE") = CDate(txtSuppli edDate)
.Fields("EXCEL_ DATA_LOCATION") = txtExcelFileLoc ation
.Fields("EXCEL_ ORIGINAL_LOCATI ON") =
txtOriginalFile Location
.Fields("TOT_NE W_CONTRACTS") = CInt(Nz(txtNewC ontracts,
0))
.Fields("TOT_CA NCELLATIONS") = CInt(Nz(txtCanc ellations,
0))
.Fields("TOT_EX CEPTIONS") = CInt(Nz(txtExce ptions, 0))
.Fields("TOT_FR OM_PREVIOUS_MON TH") =
CInt(Nz(txtPrev iousMonth, 0))
.Fields("TOT_EN ROLLED") = CInt(Nz(txtEnro lled, 0))
.Fields("TOT_RV ") = CCur(Nz(txtTota lRV, 0))
.Fields("TOT_GR OSS_PREMIUM") = CCur(Nz(txtGros sPremium,
0))
.Fields("TOT_BR OKER_COMMISSION ") =
CCur(Nz(Me.txtG rossPremium * Nz(txtCommissio n, 0), 0))
.Fields("TOT_NE T_PREMIUM") = CCur(Nz(txtNetP remium, 0))
.UpdateTableRow
End With

rst = Nothing
cnnLocal.Close

End Sub
Nov 13 '05 #1
25 1880
tp********@plls .co.uk (Tim) wrote:
I'm currently interviewing for a vb.net
developer who doesn't mind prototyping the client requirements using
MS Access.


Why continue on to VB.NET? Why not build the system in MS Access? Be a lot faster
thus cheaper.

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
Nov 13 '05 #2
"Tim" wrote
Dear Developers,

Firstly, I'm not sure where this post should go so I apologise if this
is in the wrong group or area. I'm currently interviewing for a vb.net
developer who doesn't mind prototyping the client requirements using
MS Access. . . .
p.s. Any developers interested in moving to .net from ms access then
drop me a line if your intersted in a position in Bristol ... good pay
and good security.


Dear Tim,

I'm sure Bristol is nice, and the pay is good, but surely you are aware that
advertising, including employment solicitation, even if disguised as a
"test", is prohibited in USENET newsgroups unless the charter specifically
permits it. You can view the charter of comp.databases. ms-access at the FAQ
site, http://www.mvps.org/access/netiquette.htm to veryify that it does NOT
specifically permit ads.

That FAQ information is only posted here every single day, but perhaps you
missed it in spite of its frequency?

Thanks for your consideration in not violating the USENET rules and the
charter of the newsgroup again in the future.

Larry Linson
founding member of comp.databases. ms-access
Nov 13 '05 #3

Tim:

Looks like you won. We owe you $20 for catching both morons.

Dr. John,
Founding Member,
The Pretentious A-Hole Club
Nov 13 '05 #4
> Larry Linson
founding member of comp.databases. ms-access


Larry Linson is a senile old liar. I am THE founding father of
comp.database.m s-access. Here is my original post from April 1st 1993,
followed by the RFD sent to news.announce.n ewgroups on April 6th of that year.
It was MY idea. Period.

Yours,

Mau Napolean

Newsgroups: comp.windows.x. apps
From: ma*@herky.cs.ui owa.edu (Mau Napoleon)
Subject: CREATION OF ACCESS NEWSGROUP
Message-ID: <19************ ******@news.uio wa.edu>
Sender: ne**@news.uiowa .edu (News)
Date: Thu, 1 Apr 1993 19:18:49 GMT
Reply-To: ma*@herky.cs.ui owa.edu (Mau Napoleon)
Nntp-Posting-Host: herky.cs.uiowa. edu
Organization: U of Iowa, Iowa City, IA
Lines: 16
Hi
I would like to know if there are enough people interested in the creation
of a newsgroup dedicated to access.
Say comp.database.a ccess

Since I think that a minimum of 100 votes are needed, I would not like to
start the process of creation if enought people are not interested.
If the vote for the groups creation fail then we must wait for 6 months
before we can try again.

If you are interested please send me e-mail. If there are enough people
interested I will start the process.

Thanks
Napoleon
ma*@herky.cs.ui owa.edu

////////

From: ma*@herky.cs.ui owa.edu (Mau Napoleon)
Newsgroups:
news.announce.n ewgroups,news.g roups,comp.data bases,comp.os.m s-windows.apps,co mp
..os.ms-windows.misc,co mp.os.ms-windows.program mer.misc
Subject: RFD: comp.databases. access
Followup-To: news.groups
Date: 6 Apr 1993 12:31:14 -0400
Organization: UUNET Communications
Lines: 25
Sender: ta**@rodan.UU.N ET
Approved: ta**@uunet.uu.n et
Message-ID: <1p**********@r odan.UU.NET>
NNTP-Posting-Host: rodan.uu.net
Oganization: uiowa.edu
This is an official RFD for the creation of a new newsgroup for the
general discussion of the Microsoft Access RDMS.

NAME: COMP.DATABASES. ACCESS

MODERATION: UNMODERATED. At this time, no need for a moderator has been
assertained. Future evaluation will determine if one is needed.

PURPOSE:
Access is a new RDBMS for the Windows Operating System. It includes WYSIWYG
design tools for easy creation of tables, reports, forms and queries and a
database programming language called Access Basic.
THe purpose of the group will be to provide help to people who use Access's
WYSIWYG design tools to create simple databases as well as to people who use
Access Basic to create complex databases.

RATIONALE:
Eventhough Access is a new RDBMS, it is very popular because of its Graphical
Development enviroment and its initial low price.
Been a version 1.0 product means that all Access users are Novices.
For that reason a newsgroup is needed where Access users can discuss
their experiences with the product and answer each other's questions.
--
Napoleon
ma*@herky.cs.ui owa.edu

Nov 13 '05 #5
Larry Linson wrote:
"Tim" wrote
Dear Developers,

Firstly, I'm not sure where this post should go so I apologise if
this is in the wrong group or area. I'm currently interviewing for a
vb.net developer who doesn't mind prototyping the client
requirements using MS Access. . . .
p.s. Any developers interested in moving to .net from ms access then
drop me a line if your intersted in a position in Bristol ... good
pay and good security.


Dear Tim,

I'm sure Bristol is nice


Just don't go there at chucking out time. :)

Oh and Tim, slap on hand, no advertising. If you're serious I can't believe
you find it hard to get a good developer. I work in London and hired
someone to help me out with no problems. Admittedly I got lucky first time
but I'm surprised it's got to the stage you have to break this groups
charter in the hope of snaring someone.
Nov 13 '05 #6
"Larry Linson" <bo*****@localh ost.not> wrote in message
news:0U******** *********@nwrdd c03.gnilink.net ...
"Tim" wrote
Dear Developers,

Firstly, I'm not sure where this post should go so I apologise if this
is in the wrong group or area. I'm currently interviewing for a vb.net
developer who doesn't mind prototyping the client requirements using
MS Access. . . .
p.s. Any developers interested in moving to .net from ms access then
drop me a line if your intersted in a position in Bristol ... good pay
and good security.
Dear Tim,

I'm sure Bristol is nice, and the pay is good, but surely you are aware

that advertising, including employment solicitation, even if disguised as a
"test", is prohibited in USENET newsgroups unless the charter specifically
permits it. You can view the charter of comp.databases. ms-access at the FAQ site, http://www.mvps.org/access/netiquette.htm to veryify that it does NOT specifically permit ads.

That FAQ information is only posted here every single day, but perhaps you
missed it in spite of its frequency?

Thanks for your consideration in not violating the USENET rules and the
charter of the newsgroup again in the future.

Larry Linson
founding member of comp.databases. ms-access

Nov 13 '05 #7
"Larry Linson" <bo*****@localh ost.not> wrote in message
news:0U******** *********@nwrdd c03.gnilink.net ...
Thanks for your consideration in not violating the USENET rules and the
charter of the newsgroup again in the future.

Larry Linson
founding member of comp.databases. ms-access


We've been down this road before, but I just get so irritated when I see
these sorts of responses. Who does a post like this actually hurt? And if
it helps someone in the group get a job, so what? Far better than the
hypocrites here who weasel their way around the rules with unimaginative,
insipid, two-line answers followed by a 10-line sig.

And it's not as if the admonishments actually have any effect. Adverts and
job solictations are no less prevalent here than they are in the sql server
groups, where these posts are just ignored. In fact the only thing the
"standard admonishment" actually accomplishes is to make cdma look like a
bunch of crybabies. That, and to have some people get so pissed off that
they start a low-level guerilla warfare campaign against the group.


Nov 13 '05 #8
"Dr. John" <DJ*******@hotm ail.com> wrote:
X-Abuse-Report: ab***@teranews. com


Please ignore the above posting and others which are somewhat bizarre.

Note to persons new to this newsgroup. One person, with many identities, is being
rather disruptive. If you see a bizarre posting it's probably the work of this
disruptive person..

Check the headers of the posting. If you see the following the posting likely can be
ignored. Of course, there will likely be other headers to be added to this list.

Comments: This message did not originate from the Sender address above.
It was remailed automatically by anonymizing remailer software.
or
X-Abuse-Report: ab***@teranews. com
or
Organization: Posted via Supernews, http://www.supernews.com
or
Organization: 100ProofNews.co m - Unlimited Downloads - $8.95/Month
or
X-Complaints-To: ab***@vnet-inc.com

You can also change your NewsReader program settings to ignore off-topic posts. See
http://www.hyphenologist.co.uk/killfile/ for more information.

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
Nov 13 '05 #9

"Tony Toews" <tt****@teluspl anet.net> wrote in message
news:3p******** *************** *********@4ax.c om...

< TA TA TA TONY TU TU TOEWS THE THE STUTTER >

Nov 13 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

72
4806
by: Herbert | last post by:
I'm still relativey new to stylesheets, so I'm hoping that the way I'm going about things can be seriously improved upon, i.e . I just haven't undersood something obvious about the 'cascading' nature of the coding, which I believe concerns the way attributes relate to one another when 'nested'... I think I can illustrate the nature of the...
99
6051
by: Jim Hubbard | last post by:
It seems that Microsoft not only does not need the classic Visual Basic developer army (the largest army of developers the world has ever seen), but now they don't need ANY Windows developer at a small or mid-sized business. ...
13
1366
by: Eric Pederson | last post by:
Raise your hand if you think the best technology wins! For those of you with your hands in the air, tell me: if Python is so good,why has PHP achieved such greater adoption and mindshare? Why do web scripters still cling to their Perl, even in corporate environments? Why hasn't Python made inroads against Java? Why is Ruby, and Ruby on...
16
1771
by: John Rivers | last post by:
http://www.15seconds.com/Issue/030812.htm?voteresult=1 poor guy worked his heart out, just to make a page control and then they published it ha ha ha ha ha to "help" others
9
1653
by: Leszek | last post by:
Hi. How can I get just one row from selected column and put it into html dropdown list I tried like this: function pobierz_wszystko($tabela,$kolumna) { $zapytanie="SELECT $kolumna FROM $tabela"; $wynik=mysql_query($zapytanie); while($wiersz=mysql_fetch_array($wynik,MYSQL_ASSOC))
12
1488
by: Jeff | last post by:
Looking for your highly subjective opinions (from those of you who have been working extensively with VS 2005). I have a client that needs/wants a complete rewrite of an existing application. I will be proposing a .NET Windows application with a supporting SQL Server database. It will likely take 4-5 months before we roll out the first...
9
321
by: Francois Grieu | last post by:
Consider this macro // check if x, assumed of type unsigned char, is in range #define ISVALID(x) ((x)>=0x20 && (x)<=0x7E) Of course, this can't be safely used as in if (ISVALID(*p++)) foo(); where p is a pointer ot unsigned char.
20
2199
by: kwikius | last post by:
As I understand it posts to comp.std.c++ shouldnt contain personal attacks. Since several of my posts on this to comp.std.c++ on this subject have now been simply ignored with out any reply by the comp.std.c++ moderators I'll repost it here for the record: And Fuck you too ... V
31
2888
by: Sam of California | last post by:
Is it accurate to say that "the preprocessor is just a pass in the parsing of the source file"? I responded to that comment by saying that the preprocessor is not just a pass. It processes statements that the compiler does not process. The good people in the alt.comp.lang.learn.c-c++ newsgroup insist that the preprocessor is just one of...
0
7789
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8037
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8215
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8086
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6432
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3737
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3743
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2227
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1048
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.