Trying to work out how to design an equipment booking system via /r/learnprogramming


Trying to work out how to design an equipment booking system

I'm trying to come up with an equipment booking system for my department. I'm not proficient in coding and programming yet, hopefully I'll be learning as I try and build something.

I'm trying to come up with a way of managing equipment. I need a way of booking equipment, that works using some sort of calendar system, using times and dates.

The issue is that we have multiple quantities of a piece of equipment. So say we have 10 of 'generic training equipment'. We might have two different teaching sessions, both who require the arms, but I need a way of deducting the quantity, so if anyone in the future tries to book the equipment 'within the same time period specified', it will tell them that all the equipment is currently in use and unavailable for the time and date they have requested.

What would be the best methodology for designing such a system? Would it be accomplished in Microsoft Access?

Cheers

Submitted July 13, 2017 at 04:48AM by ScrumpTheDoll
via reddit http://ift.tt/2uUosrj

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s