Frustrated Access

[mbox204]

Hello,

I am trying to determine what my development times are in relation to
industy benchmark for Access development. Sometimes a form will take me 1
hour to design(including object coding) Or sometimes it may take a couple
hours(including object coding), it is not consistent and it become
frustrating for me when I attempting to establish a baseline for my personal
use.

Is there any guideline that is recognized as a baseline for an individual
creating forms and controls, reports and controls, queries and such. I just
cannot seem to get a handle of my time lines and think that if there is a
target value to aim for, I might be a little more targeted.

Thanks,

Frustrated.

 

[Allen Browne]

It might be better to relax, and just worry about achieving the goal rather
than constantly creating sress-inducing deadlines for yourself.

Maybe an hour is typical, but it varies so much. My current project has a
few forms that took 15 minutes, but they do nothing more than interface a
lookup table. At the other extreme, there is one form that represents a few
*days* worth of development time! This form lets the user select clients
based on literally millions of possible combinations of criteria, and works
by dynamically generating a SQL statement containing many subqueries (since
the search includes what is/is not in many related tables, each with their
own criteria) and also builds an explanation of the criteria to give
feedback to the user. It was worth the effort because the form is reused
four times in different parts of the application.

If your aim is to be as efficient as you can, you may give yourself a
running start by creating a couple of forms to use as templates. The forms
already have the appearance, behaviour, and event procedure skeletens you
are likely to need. For examples, see this article:
Setting up Default Forms and Reports
at:
http://allenbrowne.com/ser-43.html

Hope that helps you relax and focus on becoming a good developer.