Em Andamento

Closed beds tracking Access app

Need Access 2003 database to capture ongoing information. In our hospital we close beds for staffing issues for blocks of time. The database would capture what beds were closed, for how long and by whom. Reports would be needed for weekly, monthly, quarterly,? and yearly? totals, and queries would allow users to look at what units had the most closed beds, and what directors were most likely to close them.

There would be 2 forms, one for bed closures for staffing reasons and one for maintenance reasons.

## Deliverables

I will provide the list of units that the user will pick from and the list of directors that will be closing beds, and another list of the person filling out the form. I'll need to be able to update this info as staff comes and goes and units open and close.

The reports will need to do some basic calculations. For instance if a unit closes 3 beds for 8 hours, and another unit closes 6 beds for 4 hours the report will need to be able to handle the math.

Also in the form the user will enter the closed date and time (need a calendar control for these fields) and a projected reopen date and time, as well as a actual reopen date and time. If the user did not fill in the actual reopen date and time the reports would reflect the projected date and time as the amount of time closed.

The canned reports would show the length of time beds were closed, sorted by units and with options to pick weekly, monthly, quarterly, and yearly.

There needs to be? robust query options so a user could slice and dice the data in a variety of ways.

There will be approx 30-40 units with approx 10 directors and approx ten staff using the form.

Habilidades: Engenharia, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Gestão de projetos, Arquitetura de software, Teste de Software, Word

Ver mais: time tracking project management, slice dice data, project calendar app, dice database, access staffing, access information management, time tracking app, robust control, project management access, math basic, capture fill, access app, project tracking access database, hospital database management project, app calendar list, tracking database access, php project hospital, update form access, app information needed, hours access database, app list calendar, open close control, access control database, time beds, hospital management access database

Acerca do Empregador:
( 7 comentários ) United States

ID do Projeto: #2976342

Premiar a:

fastudiovw

See private message.

$119 USD em 14 dias
(731 Avaliações)
7.5

10 freelancers estão ofertando em média $144 para este trabalho

customizedata

See private message.

$85 USD in 14 dias
(115 Comentários)
6.0
Robotapps

See private message.

$157.25 USD in 14 dias
(94 Comentários)
5.4
VedAlek

See private message.

$59.5 USD in 14 dias
(54 Comentários)
5.3
hanyelmehy

See private message.

$85 USD in 14 dias
(19 Comentários)
5.3
edreamzinc

See private message.

$510 USD in 14 dias
(24 Comentários)
5.1
rcnvw

See private message.

$110.5 USD in 14 dias
(16 Comentários)
4.6
longlostviking

See private message.

$63.75 USD in 14 dias
(11 Comentários)
2.7
Monir1234

See private message.

$82.45 USD in 14 dias
(9 Comentários)
2.5
jodes23

See private message.

$170 USD in 14 dias
(0 Comentários)
0.0