Access Useful database creation? Help

  • Thread starter Thread starter nathanh
  • Start date Start date
N

nathanh

Access Useful database creation? Help

Ok i can just about get by in excel.

I have a time sheet template that i use. it has each sheet is based o
a week for each employee. So it has there name the hours they hav
worked in the week the dates and rate (depending on hours). now i a
having trouble keeping up with al the workbooks i have saved on m
computer. having a sheet a week for each employee is a labrious tas
plus i have to save it all in folders for each employee for each month
the worst part is when i need a summary of the employye for the month
etc.
Ok so im sure there are easier ways out there to do these things.

A friend mentioned Access and that i could have a database that woul
save all the timesheets on it and call them up in summary reports....

SO i TRIED and failed miserably. I have no idea how to create this as
want to use my form i already have in excel. i just want a simple wa
to store it and recall it.

Can anyone help or point me in the right directon. Or even tell m
where i can pay to have someone help me create this?

I know what i need to do and have the plans set out.................
just cant create them.

Any help would be mostly apprciated as i seem to be truly novice.



Many thanks
 
Access Useful database creation? Help

Ok i can just about get by in excel.
Click to expand...

Excel is a spreadsheet, an excellent one. Access is a relational
database. THEY ARE DIFFERENT. Applying spreadsheet logic to a
relational database is NOT going to work.
I have a time sheet template that i use. it has each sheet is based on
a week for each employee. So it has there name the hours they have
worked in the week the dates and rate (depending on hours). now i am
having trouble keeping up with al the workbooks i have saved on my
computer. having a sheet a week for each employee is a labrious task
plus i have to save it all in folders for each employee for each month.
the worst part is when i need a summary of the employye for the months
etc.
Ok so im sure there are easier ways out there to do these things.

A friend mentioned Access and that i could have a database that would
save all the timesheets on it and call them up in summary reports....

SO i TRIED and failed miserably. I have no idea how to create this as i
want to use my form i already have in excel. i just want a simple way
to store it and recall it.
Click to expand...

There isn't, and again, attempting to treat Access as if it were "a
big spreadsheet" will get you nothing but grief. The entire STRUCTURE
of the data will need to change. "You can drive nails with a crescent
wrench, but that doesn't make it a hammer!"
Can anyone help or point me in the right directon. Or even tell me
where i can pay to have someone help me create this?
Click to expand...

Learn about "Normalization". There's an introduction at

http://support.microsoft.com/?kbid=209534

and a webcast that you can link to. Design your table structures first
- you'll need one table of Employees, a second table of Hours (NOT!!!
a different table for each employee; again, spreadsheets are NOT
tables, tables are NOT spreadsheets). You can use Queries to pull out
and summarize the hours, grouping by employee and by month, among many
other things.
 
Nathan,

Email me a copy of your Excel file and your plans of what you want the database
to do and I will get back to you.
 
Back
Top