General discussion

Locked

Database "Returns" Project

By XpertDragon ·
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

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Database "Returns" Project

by XpertDragon In reply to Database "Returns" Projec ...

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

Collapse -

Database "Returns" Project

by sl-campbell In reply to Database "Returns" Projec ...

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.

Collapse -

Database "Returns" Project

by sl-campbell In reply to Database "Returns" Projec ...

Here is a pretty go out-line explaining the differences between Jet, MSDE, and SQL Server

Collapse -

Database "Returns" Project

by sl-campbell In reply to Database "Returns" Projec ...

Here is a pretty good out-line explaining the differences between Jet, MSDE, and SQL Server:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdeforvs.asp

(Remove any spaces in the URL)

Collapse -

Database "Returns" Project

by XpertDragon In reply to Database "Returns" Projec ...

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

Collapse -

Database "Returns" Project

by XpertDragon In reply to Database "Returns" Projec ...

This question was closed by the author

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums