First steps

  • Thread starter Thread starter RT
  • Start date Start date
R

RT

Hi
I am just starting with Access (Office 2000 under Win 98)

I am quite familiar with Excel and I have fooled around in Access a little

What I want to do is to set up a database which will allow me too
Customer names and info
Products name and pricing etc
Create invoices
Calculate profites

I played with the templates but, unless I missed something none of them have
tables with calculations

I need to keep track of the product id , see how much each one cost (prices
varie) who bought it and how much profit was made on individual sales as
well as totals

OK

My first question to you guys is

Any idea of samples, sites, downloads, tips, to get me going

I am sure I will be asking for more later but a kick in the right direction
would be much appreciated

Thanks

Rex
 
Hi

After looking up I have Jeff 's set of links in the Tutorial thread
So I already have things to look throught, but if any of you has ideas, they
are alwys welcome

Thanks

Rex
 
You shouldn't have calculations in tables. these should be done on the fly
when running the report or opening the form for display

To keep track on profit on individual sales you will need an
invoicetransaction table which will include for eg

Product ID
InvoiceID
CustomerID
Date of Invoice
QtySold
PriceEach
CostEach

The Profit would be calculated in the query rather than stored in the table

HTH
 
Hi

thanks for replying

Message recieved, understood and filed in the memory cell allocated to
important messages in my private little brain

But then again, trust me, I'll surely be making errors that would make Bush
and Kerry look like super geniuses

Rex
 
Back
Top