How do I make this work?????

Guest · Oct 26, 2004

I started an online sales business about two months ago. When I began, it
was no big deal to track sales and profit on a spreadsheet. I had another
spreadsheet with contact information.
Now, however, with about 10 orders a day, tracking is getting HELLISH!!! I
am constantly switching between one spreadsheet, another spreadsheet,
outlook, and my web shop-cart program!!!
Now, I've installed access 2003, and built several tables with corresponding
forms (customers, products, suppliers, purchases, wholesale orders)
I understand how to actually create relationships, but I must be missing
what they do! I want to enter a new purchase, and with the e-mail address,
have the program auto-fill the rest of the associated fields/tables.
For example, I enter their e-mail, the program fills their first, last, and
e-mail in the same table. At the same time, it adjusts the total number of
inventory remaining. It also updates the "total purchases" and "current
purchase comments" in the customer table.
Is this possible? Or am I just dreaming that a program exists that will
actually make my life easier!!!!
Thanks for reading all of this, and thanks in advance for any help!
Kimberly

tina · Oct 26, 2004

sounds like your tables are probably not normalized. tables are the
foundation of the database; the time that you invest in making sure they are
properly structured and related *now*, will repay you a thousandfold over
the long haul as you use and expand your database to meet your business
needs. suggest you read up on table normalization (you can Google the term),
and/or buy a book to learn the principles. one good text is Database Design
for Mere Mortals by Michael Hernandez, and there are others on the market as
well.

hth

Guest · Oct 26, 2004

First there is no easy explination on how to accomplish what you are after.
I have used access to track my inventory and sales for approx. 6 years now.
I have in excess of 5000 part numbers and similar amount of customers. I
believe that I have been able to accomplish most of what you are after.
There is hope - of course it is not easy and there is no clear directions on
how to do it. I think you have a good start with the tables you have
created. The relationship between the tables is used as example to make sure
when you post a sale that the part number is limited to the list in your
products table. That way you do not have a bunch of misc postings. I then
created a inventory transactions table that uses information from the other
tables to fill in redundant info. Part # Customer Name etc. But I am able
to input unique info. like date, # sold, price sold, side marks and the like.
The part # and Customer infor is basically auto fill. The criteria is
narrowed as you are typing in the part number, I also have a drop down box
that i can select from. I can track sales history by part number or customer
name. I know I am not explaining how it is done but the first step is to
know it can be done. And, am I even on the rite track for what you are
after, Let me know if this helps

Guest · Oct 27, 2004

Hi Kimberly..

In my work place we have just started a new online business with the same
issues as you. However i found that on Microsoft Office online, one of their
templates was exactly what i wanted.... its the Inventory control database.
The joy i had once found. all i have had to do is rename and add a few extras
and it works like a dream (however was looking for link on microsoft page and
couldn't find it.... but it was in download section.

Its worth a look...... hope this is something...

cheers

gary

Brett Collings [429338] · Oct 28, 2004

I like Tina's explanation a lot - sums it up very well.

Here are some links that I believe will be invaluable ... if you have
time to read them between orders

sounds like your tables are probably not normalized. tables are the
foundation of the database; the time that you invest in making sure they are
properly structured and related *now*, will repay you a thousandfold over
the long haul as you use and expand your database to meet your business
needs. suggest you read up on table normalization (you can Google the term),
and/or buy a book to learn the principles. one good text is Database Design
for Mere Mortals by Michael Hernandez, and there are others on the market as
well.

hth

Cheers,
Brett

Access Stock In Hand query in access 2007	0	Aug 22, 2013
Designing Purchanses/orders/inventory Database help?	1	Dec 17, 2006
data not flowing properly	18	Oct 26, 2006
How do I add two fields together to make a third in a table?	2	Nov 28, 2005
how to best structure this?	3	Nov 9, 2009
Table design to enable desired report with sums.	3	Feb 25, 2005
Invoices with Sales Order & Purchase Order	1	Jun 26, 2009
Counting Missing values in a specific field.	1	Aug 9, 2009

How do I make this work?????

Guest

tina

Guest

Guest

Brett Collings [429338]

Ask a Question

Similar Threads