Help...Best way to create a sales and invoice database

[firefighter17103]

Hi All,

I am new to MS Access 07, & do not know any VB, on a new business adventure. I am running Office07 on Vista Home Premium.

Basically what I would like to do is create a database that I can create quotes, bill out customers for security services and cctv products and installs as well as create purchase orders to my distributors being that I keep no inventory on hand. Also I would like to track payments such as deposits on equipment and so on. I have tried and been looking everywhere for help. Below is the tables I have already created. Any help or examples that anyone is able to provide would be greatly appreciated. Thank you in advance for help.

CUSTOMERS
CustomerID(Prim aryKey[AutoNumber]); CompanyName; Prefix(Look-up from "Prefix" Table); FirstName; LastName; Address; City; State(Look-up from "State" Table); Zip; PhoneNumber; Ext; CellNumber; FaxNumber; E-MailAddress; NewsLetter; Notes; CustomerSince; Referred; CustomerType(Lo ok-up list); TaxExempt(Look up from Yes/No Table)

DISTRIBUTORS
Distributor(Pri maryKey); Contact Name; Address; City; State(Look-up from "State" table); PhoenNumber; Ext; FaxNumber; CellNumber; E-MailAddress; Website; Notes(Memo field); Terms(Look-up from "Terms" table); Limit

PRODUCTS
Prouct#(Primary Key); Manufacturer(Lo ok-up from "Manufactur er" table); Distributor(Loo k-up from "Distributo r" table); Category(Look-up from "Category" table); CCD; Lens; IR(Look-up from "Yes/No" table); #ofLED's; MinLux[Color]; MinLux[B/W]; MinLux[Sens-up]; Resolution[Color]; Resoltion[B/W]; OpticalZoom; DisgitalZoom; Style(Look-up from "Style" table); Control; AutoIris(Look-up from "Yes/No" table); Varifocal(Look-up from "Yes/No" table); Motorized(Look-up from "Yes/No" table); Day/Night(Look-up from "Yes/No" table); OutDoor(Look-up from "Yes/No" table); Heater(Look-up from "Yes/No" table); Fan(Look-up from "Yes/No" table); VandalProof(Loo k-up from "Yes/No" table); Mount(Table contained look-up list); CH; HDD; FPSRec; Format(Look-up from "Format" table); Media(Look-up from "Media" table); LAN(Look-up from "Yes/No" table); USB(Look-up from "Yes/No" table); AddtionalInfo(M emo field); SpecSheet(Attac hment); Disontinued(Yes/No check box); MSRP; OurPrice; Cost; WorksWith(Look-up from "Product#" query)

Employees
UnitID(PrimaryK ey); FirstName; LastName; CellNumber; DC#; NYSecID#; ExpDate

I also have the following tables which are pretty much self-explanatory:
"State", "Prefix", "Yes/No", "PayType", "Terms", "Category", "Style", "Format", "Media", "Mount"

I have also created some forms for add/modify products; view products. I currently have 16 Product Categories, so not all of the fields on the Products Table will always be filled out. I apologize if this is to much info posted; if anyone would like to see my database please let me know I will be more than happy to send it. Once again I would like to thank everyone in advance for any help you can provide.

Joe M

[NeoPa]

Joe,

I don't want to prejudice anyone giving help on this thread at all, but I have to say that the scope of this project seems to be far too big for a novice.

Projects of this size and complexity can often be sold for profit as their creation is such a large undertaking. I can't help feeling that you would be better advised cutting your teeth on something a little less ambitious. As for the need for the database / software - I would look out in the marketplace to see what you can pick up that's already available.

Welcome to Bytes!

[firefighter17103]

NeoPa,

I have a couple of obsticales that are preventing me from doing that...One is that the databases I have seen won't allow me to include specific details. Another is a money issue..as of right now all incomming money is going to insurance, equipment and such. I am pretty good at figuring stuff out. I am just looking for some guidence/help.

Thanks,
Joe

[NeoPa]

Ok Joe. You're welcome to leave this here in the hope of something more helpful.

We don't generally encourage questions of such large scope though (Check out the guidelines). What you really need to be looking at if possible, is to break down your requirements into more easily manageable chunks.

[firefighter17103]

Ok Joe. You're welcome to leave this here in the hope of something more helpful.

We don't generally encourage questions of such large scope though (Check out the guidelines). What you really need to be looking at if possible, is to break down your requirements into more easily manageable chunks.

Please Close this topic I have reposted with a clearer description of what I would like help with.

[NeoPa]

It's very unusual to close live threads - even when resolved. However, I can't see a problem this time as long as I link across to the other thread (Help Creating an Order Form/Invoice). Anyone interested can express themselves there.