Database Design Question

[AccessNewBiegr]

Hi to all, i am at the first step (design) of a project. and i have some issues...
i must manage a Warehouse of paper forms.

The problem is that i have 6 different kind of paper forms and each paper form has a unique number on it and i have to manage these paper forms with their unique numbers.



At the moment i keep all the data in excel and work well but i must do something more secure and professional.

in excel i have one sheet for each paper form with the following columns :

DATE | CLIENT | NUMBERS (FROM - TO) |IMPORT | EXPORT | BALANCE



I hope to understand what i mean.

Any suggestion is welcome

Thanks

[NTC]

It depends. You don't ask an explicit question. Neither the dates, nor the clients are in sequential order. So the right approach in a database will somewhat depend on whether these are to be approached as inventory on the shelf that would be exported in random order - - or whether one would export in sequential order. Also what role do you want the db to play - as you mention security....and what aspect of doing things with excel is not working well. One kind of needs this additional info to give directional advice.

Sorry to not be more helpful.

[orange]

I agree with NTC -- Is there a problem/issue? What is it?