Ditutup

Roster Application

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.

Kemahiran: Excel, SQL, Visual Basic untuk Aplikasi

Lihat lebih lanjut: shift manager, microsoft excel VBA, end vba, email temp, application vba, microsoft contract database, schema sql, gui vba excel, status list excel, vba add excel, Vba sql, modifications excel, employee excel vba, excel contract database, excel gui vba, vba provide, add tables sql, frontend backend database, vba excel add, track email excel, excel list holidays, state region list excel, email database region, list status excel, gui backend

Tentang Majikan:
( 0 ulasan ) United Kingdom

ID Projek: #4044877

11 pekerja bebas membida secara purata $253 untuk pekerjaan ini

Krusche

We had implemented a very similar Excel + external SQL DB application before. Based on the previous experiences the implementation takes a bit of time, especially the set up of the database on the external server. Chec Lagi

$960 AUD dalam 14 hari
(21 Ulasan)
5.2
adim

Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.

$199 AUD dalam 7 hari
(6 Ulasan)
3.6
rajanlengde

Programming EXCEL VBA from Year 2000. This can be done. Need morw discussion on detailes of functionality required. Please see PMB.

$250 AUD dalam 15 hari
(2 Ulasan)
2.5
salih0vicx

Dedicated expert in programming to include VBA ready to take care of this Project ...

$98 AUD dalam 7 hari
(2 Ulasan)
2.0
seharsuleman

looking forward to work on this project

$150 AUD dalam 10 hari
(1 Ulasan)
1.4
kevinross100

Hi, I have looked at your project and have similar experience in my previous job where I built a shift tracking system using a SQL backend and had the front end in Access as that was the only tool available. I wonde Lagi

$250 AUD dalam 20 hari
(2 Ulasan)
1.1
faheem29

I am interested to develop this application. I have vast experience for VBA.

$200 AUD dalam 15 hari
(4 Ulasan)
0.7
atech49

hi, i have developed employee management system earlier and ready to start this please check your pm to start.

$250 AUD dalam 7 hari
(0 Ulasan)
0.0
neel1311991

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...

$250 AUD dalam 7 hari
(0 Ulasan)
0.0
rrivas

Ready for the Work

$150 AUD dalam 15 hari
(0 Ulasan)
0.0
iqrarahmed

hello sir i am best for this

$30 AUD dalam 10 hari
(0 Ulasan)
0.3