[FONT="]Maintenance Database [/FONT]
[FONT="]Important Variable – Time[/FONT]
[FONT="]Queries:[/FONT]
· [FONT="]Calculate and flag maintenance of machines after a 250-hour cycle.[/FONT]
· [FONT="]Create colored flags for each period, Green (between 0-100), Yellow (between 101-200) and Red (between 201-250).[/FONT]
· [FONT="]Auto generate 2 report cards to be printed (for each machine), Yellow meaning machine “may need to be maintained soon” (once hours reach 200), then Red meaning machine “needs to be maintained now” (once hours reach 250), allow Access to autosave reports as PDF for print out.[/FONT]
· [FONT="]Calculate Fuel usage (not very important) for all machines[/FONT]
· [FONT="]Link Employee working hours (as the maintenance depends on how much they have used the machines, all employees work 8 hour shifts daily. There are two shifts; Day shift starts at 6:30am and ends at 15:30pm, Night shift starts at 16:00pm ends at 1:00am, auto deduct 1 hour (mandatory break/lunch) before calculating the machine working hours or cycle. Allow an extra hour for overtime.[/FONT]
[FONT="]Forms: [/FONT]
· [FONT="]Mainframe/application (which should be the default menu after opening the Access File) must include buttons for entering data such as Name/Last Name, Machine they use - both datafield’s must be in a form of a drop down menu that should restrict picking of machines except to the available one’s, any Employee can pick any machine to use, other datafield’s for input are the working hours or shift periods, that will help queries auto calculate machine working cycles but all this data is for ongoing dates, meaning it should continue and not be set backwards. [/FONT]
· [FONT="]An extra field may the one for fuel usage, where a user can just input how much fuel was bought for said machine for the day or any date when it was done, this field can help the fuel usage be calculated by month (for each then all machines in a report card) then maybe generate a report card (which can only be if requested). This is not very important as it easy to deal with cause user only has to enter total amount of fuel added on said date or time[/FONT]
· [FONT="]Form must restrict users from adding or altering data except said and required data.[/FONT]
[FONT="]Reports Cards: [/FONT]
· [FONT="]Cycle reports that depend on the hours mentioned above ONLY, which can be daily depending on whichever machine is being used. These are the reports that should be auto generated then saved into PDFs for later forwarding[/FONT]
· [FONT="]Monthly report that calculates amount of fuel being used. Reports depend on user request – not important at all.[/FONT]
· [FONT="]Monthly report that calculates hours or employee performance.[/FONT]
· [FONT="]Report card that shows machine usage before maintenance by all users, also good in determining which employee uses said machine or machines a lot.[/FONT]
[FONT="]Important Variable – Machines Available (10) and Employee/Workers usually work 180 hours per month, up to 45 hours a week (including overtime – not mandatory), only 8 hours a day (excluding the deductible lunch/break time), 9 or 10 hours depending on overtime.[/FONT]
[FONT="]Important Variable – Time[/FONT]
[FONT="]Queries:[/FONT]
· [FONT="]Calculate and flag maintenance of machines after a 250-hour cycle.[/FONT]
· [FONT="]Create colored flags for each period, Green (between 0-100), Yellow (between 101-200) and Red (between 201-250).[/FONT]
· [FONT="]Auto generate 2 report cards to be printed (for each machine), Yellow meaning machine “may need to be maintained soon” (once hours reach 200), then Red meaning machine “needs to be maintained now” (once hours reach 250), allow Access to autosave reports as PDF for print out.[/FONT]
· [FONT="]Calculate Fuel usage (not very important) for all machines[/FONT]
· [FONT="]Link Employee working hours (as the maintenance depends on how much they have used the machines, all employees work 8 hour shifts daily. There are two shifts; Day shift starts at 6:30am and ends at 15:30pm, Night shift starts at 16:00pm ends at 1:00am, auto deduct 1 hour (mandatory break/lunch) before calculating the machine working hours or cycle. Allow an extra hour for overtime.[/FONT]
[FONT="]Forms: [/FONT]
· [FONT="]Mainframe/application (which should be the default menu after opening the Access File) must include buttons for entering data such as Name/Last Name, Machine they use - both datafield’s must be in a form of a drop down menu that should restrict picking of machines except to the available one’s, any Employee can pick any machine to use, other datafield’s for input are the working hours or shift periods, that will help queries auto calculate machine working cycles but all this data is for ongoing dates, meaning it should continue and not be set backwards. [/FONT]
· [FONT="]An extra field may the one for fuel usage, where a user can just input how much fuel was bought for said machine for the day or any date when it was done, this field can help the fuel usage be calculated by month (for each then all machines in a report card) then maybe generate a report card (which can only be if requested). This is not very important as it easy to deal with cause user only has to enter total amount of fuel added on said date or time[/FONT]
· [FONT="]Form must restrict users from adding or altering data except said and required data.[/FONT]
[FONT="]Reports Cards: [/FONT]
· [FONT="]Cycle reports that depend on the hours mentioned above ONLY, which can be daily depending on whichever machine is being used. These are the reports that should be auto generated then saved into PDFs for later forwarding[/FONT]
· [FONT="]Monthly report that calculates amount of fuel being used. Reports depend on user request – not important at all.[/FONT]
· [FONT="]Monthly report that calculates hours or employee performance.[/FONT]
· [FONT="]Report card that shows machine usage before maintenance by all users, also good in determining which employee uses said machine or machines a lot.[/FONT]
[FONT="]Important Variable – Machines Available (10) and Employee/Workers usually work 180 hours per month, up to 45 hours a week (including overtime – not mandatory), only 8 hours a day (excluding the deductible lunch/break time), 9 or 10 hours depending on overtime.[/FONT]