MS Access Tutorial...

Anyoen know a good site on learnign to use it. i can do basics with it but want to learn it better. Also a site for SQL would be great

 

Jet SQL is a bit different from SQL server SQL and you don't need to really learn MS-Access for the apps you're building with D7. What you need to do is learn how to design a schema.

www.sqlmag.com for sql stuff. good site. But don't forget that we are here to and I do this stuff all the time. Though I'm always learning new things and I'm no super duper expert genius like some peopl out there. I can build 'em pretty solid.

 

Hmm i think what i can do is check each entry when entered for a duplicate, If duplicate exists i'll prompt to overwrite, else i'll have it just enter
that way it won't get duplicate dates for the same Employees, sounds smart?
Oh and i have it set up in three tables now
First has Week, DayID, Employee ID
Second is Employee ID, DayID, Start, End
Thirs IS Employee ID and Week.
First is where i can check if you have hours entered for that day.
Second is where i store hours for days
Third is where i can generate my list for Week selection

EDIT: Adding fourth tables Employe Name, Employee ID, Employe Wage. To use it i'll have user Enter a name. I generate an employee ID for them. After that they jus tenter their Name And it can recall their ID and Wage