Hi,
Im trying to build a new database out of what we've got at the moment we have a big database of 6000 retail stores divided into 4 divisions, 21 regions and 110 areas with each of them managed by a divisional, regional, and area managers. Each store holds a number of fields of information. all this is kept in one excel sheet, so 6000 rows down, therefore i'm not happy with it and trying to find ways of improving. im thinking splitting database in smaller parts and linking them together in access, however i am not sure what an efficient way of making changes to stores would be. i.e a regional managers wants to move some of his/her stores from one area manager to another,in excel that could be done using vlookup to filter relevant stores, but how can this be done in access? should i still keep an excel database for convenience of changing multiple stores? Im new to databases so any help is appreciated and sorry if my question is ambiguous, will give more details if needed. and would the best practice of moving, creating database be?
Thanks
Bookmarks