En cours

Asset Management with Receipt

I need a solution for Asset Management and Equipment Audits.

We are currently using manually generated Equipment Receipts and then a physical tick sheet during monthly audits.

The database would be similar to the Asset Tracking database template.

Features required are the ability to import assets such as laptops and monitors as well as import personnel from a XLS spreadsheet.

Under Asset the following fields are required:

Make

Model

Service Tag

Description

Location (matched to personnel if on issue or manually input for a particular room)

History

Under Person the following fields are required:

FirstName

LastName

Employee ID

Phone Number

Posistion

The ability to Issue equipment to a person using a barcode from their employee card to the barcode on asset. Once Issued the database needs to generate a hand receipt for the item which they sign and then scanned into the database against the asset, also keep a hard copy for audit purposes. If possible the Receipt would be a xls document which can be changed by myself for a particular logo and look and feel.

Under reports, the ability to scan every item on the shelf and on the floor and compare it against the entire asset register for items not located to enable the completion of a 100% monthly audit. As well as the ability to generate a 20% audit where the program will generate a random pick of 20% of assets on request.

The ability to print a report on assets issued to a particular client is also required.

Just to clarify on the monthly and weekly asset audits, the ability to switch to a "Audit Mode" where you can use an attached USB Barcode Scanner to walk around and scan items and then the associated asset would be checked off in the audit as being sighted. Or something similar?

I am tired of walking around with a clip board and pen and ticking off laptops and monitors then going through pages of a folder looking for issued items.

Project would need to be completed within 7 days.

Compétences : Microsoft Access

Voir plus : database reports receipt, receipts asset management, service report template, random logo, person management, need a audit person, microsoft project template, microsoft project import, microsoft phone number, microsoft access scanner, microsoft access barcode scanner, logo generate service, employee required, employee needs, audit program, audit needs, assets receipts register, asset management hand receipts, microsoft project management template, microsoft access logo, barcode template, need an audit, audit program template, walking, shelf

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #1065603

Décerné à :

schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

250 $ USD en 7 jours
(75 Commentaires)
6.2

6 freelance ont fait une offre moyenne de 193 $ pour ce travail

mars8246

Hello. How are you? I have techniques and many experiences of Access programming including forms, querys, importing, exporting from/to other office apps( such as excel ) and from/to other database systems( such as S Plus

200 $ USD en 3 jours
(3 Commentaires)
3.9
guevanjr

Ready to start.

100 $ USD en 3 jours
(5 Commentaires)
3.1
proitagent

Hi there, I am a London based professional database developer and can easily do the job and can start right away. Regards

220 $ USD en 1 jour
(1 Commentaire)
1.7
muhammadibaad

Sir, Plz see your pmb for more detail.

290 $ USD en 7 jours
(0 Commentaires)
0.0
ZhiZhang

hi I have ten years experience on MS Access. I have done serven Access DB for client in 2009 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Let us start now. look f Plus

100 $ USD en 5 jours
(0 Commentaires)
0.0