Basic Asset Database with Check in/out form function (SQL/Access)
$30-250 AUD
Đã hoàn thành
Đã đăng vào gần 12 năm trước
$30-250 AUD
Thanh toán khi bàn giao
Please only bid if the expected completion is before 7th July.
I require a basic SQL database with a Access (or similar) front end for a simple check in check out system for assets(laptops).
There are only 5 or 6 columns on 1 table.
The scenario is that using a form, an asset is checked out/issued by entering in its MAC address (unique) and some personal details about the user it is being issued to. The Asset it then marked as 'Checked Out' and a timestamp applied.
When the asset is returned, it is simply marked as In Stock.
Requirement is SQL Database, 1 form for Issuing assets. 1 form for Returning assets and a report to see what assets have been issued and returned.
See attachment for screenshot titled [login to view URL] for the fields required for issuing assets and [login to view URL] for the form to return the asset.
Note the checkbox 'Reload Last' on lending page. This queries the previous Lend on click for the 'Collected by' 'Contact number' 'booth' and 'note' fields of the previous record. This is because multiple items/'mac addresses' can be issued to the same user and this saves retyping that information.
Ideally the work would be completed by Saturday 7th July.
Hi I am interested in your project. I have seven years of experience in development and designing of similar software like Inventory control,purchase system etc.
I can do this project before Friday(USA Time zone). I am ready to start the job right now
Looking for your positive reply please
Thanks
I ensure you that me and my team will provide you with a excellent done job in the required time. We are new on freelancer, so please give us a chance to show you our skills and expertise.
Dear Sir, i have understood your requirement .i am eager to work in this project and i am assuring you ,i can easily develop this kind of report to fulfill your basic asset database project.
I have been an Access Developer since 2003. Creating databases from the ground up. I have created front end databases for users also. Please let me prove my work. I am new to Freelancer.com