Recommendations

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

I am new to Access and would like to know if the
following questions below are possible with ACCESS- (A
simple yes or no will be appreciated) and if so a
recommendations regarding a book to purchase for ACCESS
and VBA programming or whatever I need to complete this
project.

Currently we are entering our payroll data into access.
We would like to be able to:
A)Print out two week calander's for each person with
their respcetive hours for each day that has been
entered.
B) We would also like to develop a report that sums all
of the hours by Job# and PhaseType on each Job,and have
it multiply each person's hours by their hourly rate to
get an accurate cost for each phase of each job. The JOB#
and PhaseType data is entered into the hours table at the
same time the hours worked are entered. The persons hours
worked are in the Hours Table, the WageRate is in the
SubCon table.
C) A report that sums all hours for each person during
the two week interval and multiplies it by the wage rate,
subtracting any deductions(Insurance, advance etc.) or
adding any reimbursements. The deductions will come from
the SubCon table and the DedReimb Table. I would like to
be able to export this file in CSV format, and print it
on paper also.

Thanks for your time.
Ben
 
Simple Yes/No answers inline below...

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp



Ben said:
I am new to Access and would like to know if the
following questions below are possible with ACCESS- (A
simple yes or no will be appreciated) and if so a
recommendations regarding a book to purchase for ACCESS
and VBA programming or whatever I need to complete this
project.

Currently we are entering our payroll data into access.
We would like to be able to:
A)Print out two week calander's for each person with
their respcetive hours for each day that has been
entered.
YES

B) We would also like to develop a report that sums all
of the hours by Job# and PhaseType on each Job,and have
it multiply each person's hours by their hourly rate to
get an accurate cost for each phase of each job. The JOB#
and PhaseType data is entered into the hours table at the
same time the hours worked are entered. The persons hours
worked are in the Hours Table, the WageRate is in the
SubCon table.
YES

C) A report that sums all hours for each person during
the two week interval and multiplies it by the wage rate,
subtracting any deductions(Insurance, advance etc.) or
adding any reimbursements. The deductions will come from
the SubCon table and the DedReimb Table. I would like to
be able to export this file in CSV format, and print it
on paper also.
Click to expand...

YES

Now, for the more complicated answers. We would need to know a lot more
about your data and the structure of your tables to give you more, but I see
no reason why all of your requirements can't be met -- especially if you
have followed basic Normalization Rules in designing your database.

I would recommend that you obtain a copy of F. Scott Barker's Access
(Version) Power Programming.
 
Ben,

Absolutely yes on all accounts!

At this point, you have a couple options available to
you. Your 1st option is if you prefer to do this yourself
(big learning curve, timely venture to learn and produce,
etc), Barnes & Noble has many books available for Access -
depending on the version of Access (95, 97, 2000, XP,
etc). Any book by Alison Balter would be very helpful for
a beginner.

Your 2nd option would be to contract out. I would be
happy to help and I'm not expensive.

v/r

RSB
Calvary Software Solutions
 
Lynn,

Thank you!

Ben
-----Original Message-----
Simple Yes/No answers inline below...

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq
..asp





YES

Now, for the more complicated answers. We would need to know a lot more
about your data and the structure of your tables to give you more, but I see
no reason why all of your requirements can't be met -- especially if you
have followed basic Normalization Rules in designing your database.

I would recommend that you obtain a copy of F. Scott Barker's Access
(Version) Power Programming.


.
Click to expand...
 
RSB,

Thank you. I am interested in getting a quote if you
want to take the time. I will email you at cox.net

Thanks

Ben
 
Not only is the answer yes, but if you look around you may be able to
find a template that will get you started and do much of the work for you.

The hard part is the learning curve of Access. It is a great program,
but it does take a while to get to the point where you can start using it.
It takes a life time to really know it.
 
Thanks.

Ben
-----Original Message-----
Not only is the answer yes, but if you look around you may be able to
find a template that will get you started and do much of the work for you.

The hard part is the learning curve of Access. It is a great program,
but it does take a while to get to the point where you can start using it.
It takes a life time to really know it.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math





.
Click to expand...
 
Back
Top