Desktop Product Inventory Database Inquiry (How To Make Customer Returns)

[Razor34]

Hello,

I am very new to Microsoft Access. I downloaded a template called Desktop Product Inventory Database and I was trying it out whether I could make use of this for my business.



Anyway, I was trying to see if I can make customer returns but unfortunately, if I am right, this functionality is not available.

Can anyone help me out with this?

I'd be glad to discuss this further in details if it is ok with you. I use teamviewer on my computer and we can chat via skype(abtan32), google talk(abtan34), yahoo messenger(abtan32) or aim (abtan33).

Feel free to add me.

Thanks in advance!

Bernard

[burrina]

Unfortunately as you have found out Templates are seldom able to suit your needs. Inventory is a beast of a project if done correctly.
You can Google for Inventory samples like Allen Brownes.

Good Luck!

[orange]

Bernard,
I agree with burrina
-- inventory databases are not trivial; some people have made careers out of these.
-- templates may be a start; usually quite general but rarely are they complete without customization.

Since you are new to database, I recommend that you work through this tutorial to learn some basics of database design.
Also I recommend you watch some of these videos.

Principles of relational Design http://forums.aspfree.com/attachment...2&d=1201055452
Entity Relationship Diagramming http://www.rogersaccesslibrary.com/T...lationship.zip

Video tutorials:


http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

Complete set of tutorials on Acc2010.
https://www.youtube.com/playlist?lis...FoilxbUY0yUqZP

A standard list of helpful items for new developers:
A good data model is the first step to realizing any database and Database Answers (free models) has several free models on which to base a business concept for getting some ideas to match what may closely compliment your business model.

The concepts of database building are best conceived when thoroughly planned . . .

• Database planning tutorial Part I
• Database planning tutorial Part II
• Argeedblu's FAQ on Design Strategies

And the following links on normalization cannot be stressed enough . . .

• Noah's FAQ on Normalization
• Roger's Blog on Normalization
• Jerry's FAQ on Normalization
• GroverParkGeorge's PDF on Normalization
• MSKB 283878: Description of the database normalization basics

Good luck with your project

[Razor34]

Alright. Thanks for all your reply. I have no background in programming at all and I'm just an end user but I will try to learn it. Thanks again.