Where do I go to get an estimate for an Access DB

  • Thread starter Thread starter KPerry
  • Start date Start date
K

KPerry

I schedule for a camp.
The staff we schedule receive very customized schedules based on their skills and requests, for which we need reports. There are over 100 people on staff. There are 6 periods in each day for five days per week. Periods 1 through 4 are usually 1.5 hours long. Sometimes they are 3hrs, 4hrs, 8hrs, or overnight, they don't always start at the same times. Periods 5 and 6 are special assignments, not everyone has one each day.
The way I schedule is using a large chart with pockets. I have activities, based on location as the columns, and days and periods as the rows. Each staff have cards that I plug into the board. Scheduling is easy. It is all the forms involved that make it difficult.
The staff need weekly schedules. The campers get to sign-up for the activities they want, for this we need sign-up sheets. They sign-up for a week at a time. Each activity specialist, say arts & crafts director, wants a report to state who has been assigned to their activity each period. We have some one on patrol that makes sure all instructors are at their activities. This person needs a report each period. I constantly make changes, a staff member may become sick, their activities need to be covered. I have to create notes to inform people of changes in their schedules. I also need forms to show what activities are open. The kids are allowed to change their activities throughout the week up to twice a day. Some of the assignments I give to the staff are not activities campers can sign-up for, ex. office assistance or bunk inspection. I also need a report of when I have sent people off the ranch when they need to be with their bunk, ex. lunch time, I am responsible for making sure every child has supervision. If I sent a staff member on an overnight their bunk needs to be covered by a cabin counselor with a co-counselor who is also on the ranch during those times. I am sure you have questions. Feel free to email me.

Thank You
Kathy Perry
 
Only the person who will design and implement the database can provide
anything close to an accurate estimate. You will likely get some replies
offering services, but the technical newsgroups are not really the place to
seek paid assistance. How would you verify the qualifications of anyone who
applies?

If you are really lucky, someone will see this and respond to you about
having already done such a database for their own camp / organization and
offering to share it with you.

Larry Linson
Microsoft Access MVP



I schedule for a camp.
The staff we schedule receive very customized schedules based on their
skills and requests, for which we need reports. There are over 100 people on
staff. There are 6 periods in each day for five days per week. Periods 1
through 4 are usually 1.5 hours long. Sometimes they are 3hrs, 4hrs, 8hrs,
or overnight, they don't always start at the same times. Periods 5 and 6 are
special assignments, not everyone has one each day.
The way I schedule is using a large chart with pockets. I have activities,
based on location as the columns, and days and periods as the rows. Each
staff have cards that I plug into the board. Scheduling is easy. It is all
the forms involved that make it difficult.
The staff need weekly schedules. The campers get to sign-up for the
activities they want, for this we need sign-up sheets. They sign-up for a
week at a time. Each activity specialist, say arts & crafts director, wants
a report to state who has been assigned to their activity each period. We
have some one on patrol that makes sure all instructors are at their
activities. This person needs a report each period. I constantly make
changes, a staff member may become sick, their activities need to be
covered. I have to create notes to inform people of changes in their
schedules. I also need forms to show what activities are open. The kids are
allowed to change their activities throughout the week up to twice a day.
Some of the assignments I give to the staff are not activities campers can
sign-up for, ex. office assistance or bunk inspection. I also need a report
of when I have sent people off the ranch when they need to be with their
bunk, ex. lunch time, I am responsible for making sure every child has
supervision. If I sent a staff member on an overnight their bunk needs to be
covered by a cabin counselor with a co-counselor who is also on the ranch
during those times. I am sure you have questions. Feel free to email me.

Thank You
Kathy Perry
 
I am aware this is a tech group, but I was hoping I could get some referrals to places that could help me. Thank you for your concern.
Any ideas?



Only the person who will design and implement the database can provide
anything close to an accurate estimate. You will likely get some replies
offering services, but the technical newsgroups are not really the place to
seek paid assistance. How would you verify the qualifications of anyone who
applies?

If you are really lucky, someone will see this and respond to you about
having already done such a database for their own camp / organization and
offering to share it with you.

Larry Linson
Microsoft Access MVP



I schedule for a camp.
The staff we schedule receive very customized schedules based on their
skills and requests, for which we need reports. There are over 100 people on
staff. There are 6 periods in each day for five days per week. Periods 1
through 4 are usually 1.5 hours long. Sometimes they are 3hrs, 4hrs, 8hrs,
or overnight, they don't always start at the same times. Periods 5 and 6 are
special assignments, not everyone has one each day.
The way I schedule is using a large chart with pockets. I have activities,
based on location as the columns, and days and periods as the rows. Each
staff have cards that I plug into the board. Scheduling is easy. It is all
the forms involved that make it difficult.
The staff need weekly schedules. The campers get to sign-up for the
activities they want, for this we need sign-up sheets. They sign-up for a
week at a time. Each activity specialist, say arts & crafts director, wants
a report to state who has been assigned to their activity each period. We
have some one on patrol that makes sure all instructors are at their
activities. This person needs a report each period. I constantly make
changes, a staff member may become sick, their activities need to be
covered. I have to create notes to inform people of changes in their
schedules. I also need forms to show what activities are open. The kids are
allowed to change their activities throughout the week up to twice a day.
Some of the assignments I give to the staff are not activities campers can
sign-up for, ex. office assistance or bunk inspection. I also need a report
of when I have sent people off the ranch when they need to be with their
bunk, ex. lunch time, I am responsible for making sure every child has
supervision. If I sent a staff member on an overnight their bunk needs to be
covered by a cabin counselor with a co-counselor who is also on the ranch
during those times. I am sure you have questions. Feel free to email me.

Thank You
Kathy Perry
 
Try your local IT Consulting firms
I am aware this is a tech group, but I was hoping I could get some referrals
to places that could help me. Thank you for your concern.
Any ideas?



Only the person who will design and implement the database can provide
anything close to an accurate estimate. You will likely get some replies
offering services, but the technical newsgroups are not really the place to
seek paid assistance. How would you verify the qualifications of anyone who
applies?

If you are really lucky, someone will see this and respond to you about
having already done such a database for their own camp / organization and
offering to share it with you.

Larry Linson
Microsoft Access MVP



I schedule for a camp.
The staff we schedule receive very customized schedules based on their
skills and requests, for which we need reports. There are over 100 people on
staff. There are 6 periods in each day for five days per week. Periods 1
through 4 are usually 1.5 hours long. Sometimes they are 3hrs, 4hrs, 8hrs,
or overnight, they don't always start at the same times. Periods 5 and 6 are
special assignments, not everyone has one each day.
The way I schedule is using a large chart with pockets. I have activities,
based on location as the columns, and days and periods as the rows. Each
staff have cards that I plug into the board. Scheduling is easy. It is all
the forms involved that make it difficult.
The staff need weekly schedules. The campers get to sign-up for the
activities they want, for this we need sign-up sheets. They sign-up for a
week at a time. Each activity specialist, say arts & crafts director, wants
a report to state who has been assigned to their activity each period. We
have some one on patrol that makes sure all instructors are at their
activities. This person needs a report each period. I constantly make
changes, a staff member may become sick, their activities need to be
covered. I have to create notes to inform people of changes in their
schedules. I also need forms to show what activities are open. The kids are
allowed to change their activities throughout the week up to twice a day.
Some of the assignments I give to the staff are not activities campers can
sign-up for, ex. office assistance or bunk inspection. I also need a report
of when I have sent people off the ranch when they need to be with their
bunk, ex. lunch time, I am responsible for making sure every child has
supervision. If I sent a staff member on an overnight their bunk needs to be
covered by a cabin counselor with a co-counselor who is also on the ranch
during those times. I am sure you have questions. Feel free to email me.

Thank You
Kathy Perry
 
I am aware this is a tech group, but I
was hoping I could get some referrals
to places that could help me. Thank
you for your concern. Any ideas?

There used to be a couple of good websites for finding Access developers,
but they disappeared during the business lull a few years back, and none
have come along to replace them. I'm sorry that I don't have a suggestion of
a source for you.

Your best chance might be to look at people's answers here in the newsgroup,
check their website if they mention one, and send an e-mail inquiry to those
who seem to know their stuff and are in the consulting/contracting business.

Larry Linson
Microsoft Access MVP
 
Dear Kathy:

I agree with Larry, but I would like to add that you might want to be a bit
proactive and actually contact other camps that are similar to yours and see
if they have any ideas/solutions. You might get lucky and find that someone
has already created something you could use or modify...

By the way, I sympathize with your situation. Once, I had to hire a
programmer, and it didn't work out. He was a fine programmer, but we didn't
communicate well, or do enough planning, and while he delivered what I
*asked* for, it didn't turn out to be what I really *needed*, and in the
end, the software was not usable. Luckily it was a small scale project, and
it wasn't *my* money! ;)

HTH
Fred Boer

P.S. And, also luckily, it led me to try using Access to do it myself.. and
that has made all the difference! <g>
 
Aw, hiring a programmer instead of an analyst--I guess we all learn that the
hard way. (The flip side is the number of times a client has taken my
design and given it to the high school kid next door to implement. I
learned _that_ the hard way, too. Now I make sure I'm adequately
compensated for the design. I never liked programming much anyway, so I
only care if the kid next door wants technical assistance!)

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress
 
Kathy -

Contact me at my private email. Just remove "this is not real" from my reply
email address. I am interested in discussing this project with you.

--

Ken Snell
<MS ACCESS MVP>



I schedule for a camp.
The staff we schedule receive very customized schedules based on their
skills and requests, for which we need reports. There are over 100 people on
staff. There are 6 periods in each day for five days per week. Periods 1
through 4 are usually 1.5 hours long. Sometimes they are 3hrs, 4hrs, 8hrs,
or overnight, they don't always start at the same times. Periods 5 and 6 are
special assignments, not everyone has one each day.
The way I schedule is using a large chart with pockets. I have activities,
based on location as the columns, and days and periods as the rows. Each
staff have cards that I plug into the board. Scheduling is easy. It is all
the forms involved that make it difficult.
The staff need weekly schedules. The campers get to sign-up for the
activities they want, for this we need sign-up sheets. They sign-up for a
week at a time. Each activity specialist, say arts & crafts director, wants
a report to state who has been assigned to their activity each period. We
have some one on patrol that makes sure all instructors are at their
activities. This person needs a report each period. I constantly make
changes, a staff member may become sick, their activities need to be
covered. I have to create notes to inform people of changes in their
schedules. I also need forms to show what activities are open. The kids are
allowed to change their activities throughout the week up to twice a day.
Some of the assignments I give to the staff are not activities campers can
sign-up for, ex. office assistance or bunk inspection. I also need a report
of when I have sent people off the ranch when they need to be with their
bunk, ex. lunch time, I am responsible for making sure every child has
supervision. If I sent a staff member on an overnight their bunk needs to be
covered by a cabin counselor with a co-counselor who is also on the ranch
during those times. I am sure you have questions. Feel free to email me.

Thank You
Kathy Perry
 
Dear Rebecca:

I see the magic words "2nd Edition" in your sig. Is there *really* a second
edition/reprint of Designing Relational Database Systems available? I can't
find it on the Microsoft Press website, and only used copies appear to be
available at Amazon. (I tried buying used, but sellers didn't want to ship
to Canada, among other problems...)

(I am assuming, perhaps incorrectly, that the 1st Edition is the one that is
out of print...)

Thanks!
Fred Boer
 
Rebecca said:
Aw, hiring a programmer instead of an analyst--I guess we all learn
that the hard way. (The flip side is the number of times a client
has taken my design and given it to the high school kid next door to
implement. I learned _that_ the hard way, too. Now I make sure I'm
adequately compensated for the design. I never liked programming
much anyway, so I only care if the kid next door wants technical
assistance!)
It's far better to hire the college kid who lives next store and forget the
analyst.
He or she will start from scratch using the language from the last class
they took and may have a good start on it before the semester ends and they
go home.

This was epidemic in the early days where I live and it was very common to
see a shrouded computer in the corner of the office and pointless to suggest
that it could ever be of use for anything.
 
Well, let's hope that "announcements will be made in all fashionable
magazines and colour supplements" so we won't miss it! <g>

Fred
 
Well, let's hope that "announcements will be made in all fashionable
magazines and colour supplements" so we won't miss it! <g>

Maybe in all the Fashion magazines! <veg> (gd&r -- hiding from Rebecca)
 
Lynn, dear, don't forget that I know where your mother lives....<eg>

For the record, assuming I can make a Wednesday review deadline (I expect
to), the scheduled publication is 1/9/05. And it's not an MS Press book,
it's coming out from Addision-Wesley, because MS Press decided that it
wasn't worth re-printing. This despite the fact that it was selling for
$300 on eBay the day they made the decision. Don't know what those folks
are doing these days, but it doesn't appear to be making sound business
decisions....

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress
 
Rebecca said:
For the record, assuming I can make a Wednesday review deadline (I
expect to), the scheduled publication is 1/9/05.

Shame on you Rebecca; an Access MVP, and knowing the issues with ambiguous
date formats! :-)

Is that Jan 9 or Sept 1?
 
Shame on you Rebecca; an Access MVP,
and knowing the issues with ambiguous
date formats! :-)
Is that Jan 9 or Sept 1?

Or YY/MM/DD format: 2001 Sept 5. Just a day less than 3 years late.
Onmeohmyohmy!

YYYYMMDD format was used in a mainframe product I supported back in the last
century... it's a nice format for comparison without converting.
 
And it's not an MS Press book,
it's coming out from Addision-Wesley, because MS Press decided that it
wasn't worth re-printing.

Their loss, our (and A-W's, and your!) gain! Congratulations Rebecca,
looking forward to being able to post "Just get this book..." replies
to people who want to learn from the best.

John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top