I am in the progress of setting up the Access table and need some advise before I expand it.
1) I have at least 13 products and each product has its own sheet in Excel. I was thinking should I just combine them in one Access table? Does any disadvantage or concern I need to take note of?
2) Almost all the fields contained the same information except 1 or 2 fields calculation will be different based on the product groups (A, B or C group), can Access handle this portion?
3) Is it possible if I create a Main Menu with the individual product buttons, so when the button was clicked, it goes into a sub-menu for data entry and the product name (based on the name of the button) will auto added into the table (product field)? and the calculation will auto take place base on product name? Thanks.
1) I have at least 13 products and each product has its own sheet in Excel. I was thinking should I just combine them in one Access table? Does any disadvantage or concern I need to take note of?
2) Almost all the fields contained the same information except 1 or 2 fields calculation will be different based on the product groups (A, B or C group), can Access handle this portion?
3) Is it possible if I create a Main Menu with the individual product buttons, so when the button was clicked, it goes into a sub-menu for data entry and the product name (based on the name of the button) will auto added into the table (product field)? and the calculation will auto take place base on product name? Thanks.