I need an aplication to be created solely in VBA(Excel) and Microsoft SQL.
Frontend need to be a few Forms with some minimal functionality in the excel sheet and all the backend database in MS SQL 2005.
It may be easier If I list the Backend Tables First (I will provide full schema once job is agreed which may require a few modifications):
• Employee (Id, NTLogon,Name, LocationID, Email, ManagerID, Perm/Temp/Contract, ISActive, etc)
• Location (LocationID, Location, Region)
• EmployeeCover (CoverID, Orignal_EmployeeID,Covering_EmployeeID, IsActive )
• State (StateID, StateName, StateDesc, IsApprovalRequired,Color,IsActive)
• ShiftPattern (PatternID, EmployeeID, StateLevelID, Start, End, DayOfTheWeek, ISActive)
• Shift (ShiftID, Start, End, EmployeeID, Status, Comment)
• YearlyHolidayAllowance(ID, Year, EmployeeID, StartDate, EndDate , Hours)
• Holiday(HolidayDate, Holidaydesc, Region)
• Admin(employeeID, IsActive) – This stores the IDs of the Admins.
Next, Let me clarify on the application purpose and GUI Components:
Main purpose is to track people’s shifts (Start/End) and allowing the Employee or the manager’s the ability to add holidays and then an Admin GUI to manage different aspects and also ability for the Employee or their Manager to be able to easily see the team availability.
11 freelancere byder i gennemsnit $253 for dette job
Just finished a project regarding a sales and customer management software...We are a team of 4 programmers, will deliver best quality for a reasonable cost...