Question Database Design for attached/ is it Possible ??

[nijopo]

Hi All

we use excel to run a small manufacturing factory.
it works OK, but is not at all clever or fancy.

it would be magic to have it in access to be able to change things quickly / run reports etc.
attached is a PDF of the excel sheet.
left columns are job number and customer/job details. top columbs are dates, figures in the cells are Hours in hours !.
then below is the names of fabricators and hours they can work.

i need some advice on data structure and date calculations ie working days not sundays ETC.

i tried with cross tabs but didn't get great results
any help is much appreciated,
thanks in advance

 

[jdraw]

How familiar are you with Access? Relational database is
very different than spreadsheet.
You posted a spreadsheet in pdf format. What did you expect a reader to do with that info?

Here is a tutorial that should help you with your tables and relationships design. You know your business and we don't, so we can not offer much in terms of design. Tell the readers more about your business to get more focused responses.

 

[nijopo]

i know access to a point, but have never tried to create this kind of database.

ill give a brief run down of "the business". we manufacture aluminum windows and doors

1)an order is received from a customer.
2)it is booked in and given a job number
3)our lead time is always approx 4 - 6 weeks (depending on the usual holiday, sickness lack of parts from suppliers)
4) if no delivery date is supplied from cutomer we will work to the next available date, this is achieved by looking at the spreadsheet to see when enough hours are available.
5) when enough hours are found (this can be over a number of days/weeks) depending on how many items and what type of items are ordered order is entered on the system with the amount of hours anticipated to complete
6) the spreadsheet deducts the hours off the available hours column.
7)each day the production manager updates the schedule if orders are late in production for what ever reason.
8)once job is finished the schedule is useless - as know one knows about it !!!!
which is one of the reason Access would be great, to have completed jobs on a screen or a report run every day.

hope this helps identify the requirements

thanks

 

[jdraw]

Did you look at the tutorial? I think if you work through the tutorial, then apply the steps to your own list of requirements, you will have an answer to your question or more specific questions.

Good luck.