Web Development

Ask something
Discussion Locked

Database "Returns" Project

0 helpful
6 replies

by xpertdragon 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

6 replies

by xpertdragon

I am especially looking for specific web pages that have details on a similar project that has been done. White papers, guides, tutorials....all the above. WEB PAGES. THank you.

Paul

by sl-campbell

I prefer VB as opposed to ACCESS for medium to large projects. But, for the front-end portion, ACCESS may be your best choice under the conditions that you have described.
I would reccommend that if the database contains alot of data, especially with more than 3-5 concurrent users, that you use something like SQL Server as a back-end database. You could start with MSDE and as the number of users grow (5 or 6 +) then you can change to SQL server easily.

by xpertdragon

Thank you for your comments, especially the web site. I fyou can think of anymore database tips/info, please email me at:
paulmchavez@yahoo.com

Thanks,

Paul

This discussion is closed to new replies.