Link to home
Start Free TrialLog in
Avatar of Michael Franz
Michael Franz

asked on

MS Access 2010 Form Building

Hello,

The end goal is to hook Tableau up to the database and start reporting head count stats. Eventually,

Stats such as;
  • How many FT vs PT employees.
  • How many employees
  • FTE
  • By Department
  • by Group

also trend because I'm adding a hire date and a term date....

So here is the help needed......

  1. I need a form that can be used for "Employee Entry" where 3 pieces of data will be entered. (Short Name, Last and First)
  1. I need a form that can be sued to take the employee that is entered and attach the department, group, hire date etc.... to it. This table is set up called Employee_Reporting
  1. How do I incorporate a "changed" date into this. Because there have been times enployees go from FT to PT or vis versa?

Greatly Appreciated

Michael
-Employee-Reporting.accdb
Avatar of PatHartman
PatHartman
Flag of United States of America image

The experts here give advice and answer questions.  If you want someone to actually build the app for you, the best option is to use Gigs or to directly contact one of the experts who is available for contract work.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Michael Franz
Michael Franz

ASKER

Thanks for the assistance and direction.