473,320 Members | 1,974 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

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(PrimaryKey[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(Look-up list); TaxExempt(Look up from Yes/No Table)

DISTRIBUTORS
Distributor(PrimaryKey); 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#(PrimaryKey); Manufacturer(Look-up from "Manufacturer" table); Distributor(Look-up from "Distributor" 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(Look-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(Memo field); SpecSheet(Attachment); Disontinued(Yes/No check box); MSRP; OurPrice; Cost; WorksWith(Look-up from "Product#" query)

Employees
UnitID(PrimaryKey); 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
Oct 22 '08 #1
5 3337
NeoPa
32,556 Expert Mod 16PB
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!
Oct 22 '08 #2
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
Oct 22 '08 #3
NeoPa
32,556 Expert Mod 16PB
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.
Oct 22 '08 #4
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.
Oct 23 '08 #5
NeoPa
32,556 Expert Mod 16PB
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.
Oct 23 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

18
by: Jeremy Weiss | last post by:
I'm trying to build a database that will handle the monthly billing needs of a small company. I'm charting everything out and here's what I see: table for customers sub table to track payments...
3
by: John | last post by:
Hi there - if anyone has a few spare minutes I could really do with some help please. I'm a student and have been given an exercise using MS Access to design a simple database for a fictional...
6
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...
10
by: pcthug | last post by:
Hi All, I am creating multi-tier app in vb.net using visual studio .net. I create a invoice.vb class file with properties, events and methods. This also has a line item collection class...
8
by: Fredrik Melin | last post by:
I have a "Inventory" Object that contains the product and all its fields. The problem is that I am getting soooooo many functions under main Inventory class so it becames impossible to initalize...
10
by: tranceport185 | last post by:
I have been banging my head on this one for 2 days I might just need a fresh set of eyes. This query lists all of the sales categories which are listed in POSCat, more specifically...
6
by: No Spam Man | last post by:
Hi, I am not a programmer and in the past have only created very simple, flat file databases. Although I'm a newbie, I think I could probably figure out basic Boolean logic and financial...
0
by: heidan | last post by:
Dear, I have a question of representing the relationship of sales invoice's posting date and post period into RDF. Let's say every sales invoice has a posting date which records when this...
4
by: sklett | last post by:
I've developed an ERP application that we use internally and works quite well. I receiving more and more requests from users to print various transactions, order forms, search results, etc. I...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.