Average time to build relational dbase

S

SoulVoyager

What is the average time to build a relational dbase in Access with 4 tables,
data entry forms, queries and reports. I want to hire someone to build a
dbase for me and need to know how long this should take to build it.
 
J

John Spencer

Some place between Forever and an hour.

What is the design of your database?
How do you know you only need four tables?
What fields are you going to need in the database?
How many reports do you think you will need?
What is the purpose of the database?
How much growth do you foresee in the data?
and so on and so on.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
G

Gina Whipp

SoulVoyager,

Okay that's kinda like... "Mr. Builder, I want to build a house, how long
do you think it will take?" question. The answer really depends so many
factors and that doen't even take into account the Builder. You could lose
a day to a month just building an Application Profile and Data Model.

The better approach MIGHT be, this is what I want and this is when I need it
by... then interview, check refrences of potential candidates and go from
there. (You might even check Microsoft's site for the free templates, you
might find what you need there.) I have never quoted anyone a 'fixed' price
and never will. I won't even take a contract if it's a fixed price because
in the end both I and the Client suffer.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
J

John... Visio MVP

Steve said:
If you want to hire someone to build a database for you, I can build it
for you for a very reasonable fee. I would be happy to quote you my fee if
you email me the specifics of what you want the database to do. I provide
help with Access applications for a very modest fee.

Steve
(e-mail address removed)
Click to expand...

If you want to waste time and money, then take little stevie up on his
offer

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

A few gems gleaned from the Word New User newsgroup over the Christmas
holidays to show Stevie's "expertise" in Word.


Dec 17, 2008 7:47 pm

Word 2007 ..........
In older versions of Word you could highlght some text then go to Format -
Change Case and change the case of the hoghloghted text. Is this still
available in Word 2007? Where?
Thanks! Steve


Dec 22, 2008 8:22 pm

I am designing a series of paystubs for a client. I start in landscape and
draw a table then add columns and rows to setup labels and their
corresponding value. This all works fine. After a landscape version is
completed, I next need to design a portrait version. Rather than strating
from scratch, I'd like to be able to cut and paste from the landscape
version and design the portrait version.
Steve


Dec 24, 2008, 1:12 PM

How do you protect the document for filling in forms?
Steve


One of my favourites:
Dec 30, 2008 8:07 PM - a reply to stevie
(The original poster asked how to sort a list and stevie offered to create
the OP an Access database)
Yes, you are right but a database is the correct tool to use not a
spreadsheet.
Click to expand...


Not at all. If it's just a simple list then a spreadsheet is perfectly
adequate...




John... Visio MVP
 
S

SoulVoyager

Thanks for all the responses. Ok, here is more information. I can build this
myself I just dont have the time and it's been years since I've worked in
Access.

A student is truant. A case is created. From there a hearing is created.
From there a workshop is created. There is a workshop designed to help
students get back on track.

First Table: Student personal info. primary key is personID

Second Table: Case information. This contains how many unexcused absences,
when the student was dismissed from school. When the school filed a petition
with the court. Primary key is Case Number. Table connected to person.ID
relationally

Third Table: Event information. This is the hearing date for when student
will go to court and court paperwork information. Primary key is eventID.
Table connected to Case Number relationally.

Fourth Table: Workshop information. Primary key is WorkshopID. Table
connected to Case Number relationally.

The dbase is relational. There can be one case to many events and one case
to many workshops.

Forms:
enter a new student
enter a new event related to a specific case
enter a new workshop related to a specific case

For forms and queries, hypothecially speaking, however many queries needed
for the forms and an average of 10 simple queries to build 10 simple reports.

With this information, can you give me a ballpark range of time it would
take to build this? If I had the time I would build this myself. Thanks so
much for your input!
 
S

SoulVoyager

Hi Gina,
I left more information after John Spencer's reply. Thanks for your input
and with more information provided maybe you could give me a ballpark time
frame that it might take. It's a fairly simple dbase.

Thanks again
 
J

John Spencer

OK, so how long do you think it would take you to build the database?
You could use that as a rough estimate.

Again, I can't tell you, but extremely rough estimates (including
design, test, and documentation).

Build a table - examine the data, pick out the elements of data, figure
out the relationships to other tables, populating a minimal set of test
data (4 hours each)

Build entry forms - (2 to 4 hours each)

Build reports - (1 to 4 hours)

The above includes creating minimal data for testing.

It does not include:
Custom menu bars
Additional support tables (Lookup tables - for instance Schools table to
ensure consistent entry of school names, or workshop types, or workshop
locations, etc.)
Switchboard(s) or other interface forms - for instance, selecting which
report to execute and applying parameters to the report

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
R

Ray

Hi,
I will second Gina's response about not taking a flat fee job unless there
is a VERY detailed specification. I have had customers ask me to revise
reports upwards of 10 times just because they can't decide what font looks
best or want constant tinkering with column spacing. Most customers are
pretty reasonable...as are most developers. But like anything else...there
are a few out there that make life difficult for everyone.

Having said that, I'm betting her 1 day estimate is on the low side. You
mentioned some 10 reports, which means at least 10 queries. I typically
figure 2-4 hours per table and screen depending on complexity, and another 2
hours per report. That would put my "ballpark estimate" at about 2 days.
And like John, that assumes no frills.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

200KB versus 35MB 0
Export an Access Table as an dbase III file 8
Imorting to a relational dBase 1
Using Access offline and then syncing back into main dbase 5
3 variable data in MS project file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
splitting dbase in a different network drive 1
VBA to look for more than 1 key word and highlights 8

Top