Create a DB for tracking equipment availabilty by shift

Create a DB in SQL or even MS Access, track availability of manufacturing assets (production lines). Current method tracks 6 mfg lines running three shifts, at shift handoff would like to report status, running, not scheduled, unavailable. Reasons for Unavailability, 6-8 different reason s in a pull down. then a comment section for reasons on unavail. This tool will track data inputs across three shift, qualified users, time of entry. needs to deployed for simple users, use of radio buttons/ pull down menus is encouraged. Summary report by date range will include page by mfg line, then date with color coded ABC, green yellow red.- mthis could run down teh left side page on right side list of reasons in date order descending seperate list