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 lagi: 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


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)

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

$199 AUD dalam 7 hari
(6 Ulasan)

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)

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

$98 AUD dalam 7 hari
(2 Ulasan)

looking forward to work on this project

$150 AUD dalam 10 hari
(1 Ulasan)

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)

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

$200 AUD dalam 15 hari
(4 Ulasan)

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)

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)

Ready for the Work

$150 AUD dalam 15 hari
(0 Ulasan)

hello sir i am best for this

$30 AUD dalam 10 hari
(0 Ulasan)