Đang Thực Hiện

Basic Asset Database with Check in/out form function (SQL/Access)

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 [url removed, login to view] for the fields required for issuing assets and [url removed, login to view] 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.

Kỹ năng: Quản trị cơ sở dữ liệu, Electronic Forms, Microsoft Access, SQL

Xem thêm: access database check, check database, number function, function number, sql microsoft access, microsoft access sql, timestamp, sql queries, sql microsoft, sql database report, sql access, sql 2012, report sql, lending , in stock, database queries, check, access sql, check system, mac basic, basic user system, simple contact database, lending system access, contact access, contact form columns

Về Bên Thuê:
( 2 nhận xét ) Broadbeach, Australia

Mã Dự Án: #1733663

Đã trao cho:

rhomeu

MS Access expert here please have a look on my profile. thanks!

$200 AUD trong 1 ngày
(39 Đánh Giá)
6.5

17 freelancer đang chào giá trung bình $170 cho công việc này

MattThrower

Over 8 years of MS Access experience.

$180 AUD trong 3 ngày
(15 Đánh Giá)
5.1
shmai

have a glance at PM. regards, shmai

$199 AUD trong 4 ngày
(21 Đánh Giá)
5.0
Krusche

Our solution offering starts with the development (multiuser environment) and ends with the back-end DB (MSSQL/MySQL)running securely on your server.

$480 AUD trong 3 ngày
(7 Đánh Giá)
4.9
neoconcepts

php/mysql team

$250 AUD trong 2 ngày
(3 Đánh Giá)
4.5
VNikcevic

Hi, sorry for the initial milestone request, freelancer wouldn't let me submit a bid without it. My bid is in your personal mailbox.

$70 AUD trong 4 ngày
(2 Đánh Giá)
4.0
PerfectSquare

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 Thêm

$150 AUD trong 3 ngày
(20 Đánh Giá)
3.9
chetanraj81lx

I have understand this project Please check my message in your PMB,

$250 AUD trong 7 ngày
(0 Đánh Giá)
0.0
NatashaPl

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.

$200 AUD trong 3 ngày
(0 Đánh Giá)
0.0
debanjancse26

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.

$75 AUD trong 4 ngày
(0 Đánh Giá)
0.0
punshar71

pls see IM.

$100 AUD trong 2 ngày
(0 Đánh Giá)
0.0
Verdo

will do the access DB and windows app for easy of use.

$200 AUD trong 2 ngày
(0 Đánh Giá)
0.0
DaddyWarbucksEsq

My name is George Panko, dba The Immaculate Collection. I am relatively new to Freelancer.com, but am well-established on Guru.com. Since 2001, I have specialized in designing, developing, and maintaining MS Access da Thêm

$75 AUD trong 3 ngày
(0 Đánh Giá)
0.0
PITHYD

please check your personal mail box

$30 AUD trong 2 ngày
(0 Đánh Giá)
0.0
Logytics

Is that fine if we use MS Access 2010 or you need it in some earlier version?

$100 AUD trong 4 ngày
(0 Đánh Giá)
0.0
AlQurashi

Very simple and i have worked with this type of projects before.

$70 AUD trong 2 ngày
(0 Đánh Giá)
0.0
Rvestal

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

$257 AUD trong 4 ngày
(0 Đánh Giá)
0.0