This is a question for all Database, and or Data warehousing gurus. I am about to start a medium size database project that entails tracking “Returns” data for a manufacturer (My employer). I am looking for all and any suggestions and resources that will help me get this project off on the right foot. The data is currently in Excel, and will later need to be transfered over to Access 2000 (that is not a problem). However, the Database I assume will need Forms and Report cababilties to track Customer returns of Products that will be returned for various reasons by the consumer (Don’t want, Broken, Wrong Product ID #/SKU, Etc.)
This Database, and its information will be shared among a group of 5+ that will want all those pretty reports and queries.
#1 Question: What is the best means/approach to inputing data into the database with the easiest to use interface for a user that has little to no database or computer experience? (Access TAB forms, VB forms?)
Thanks for any information you can send my way. I am looking to get a lot of input on this question.
Paul M. Chavez
