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:



Service Tag


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


Under Person the following fields are required:



Employee ID

Phone Number


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

en 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é à:


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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(75 Commentaires)

6 freelance font une offre moyenne de $193 pour ce travail


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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)

Ready to start.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)

Sir, Plz see your pmb for more detail.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)