Confused about basic setup

  • Thread starter Thread starter kymmy
  • Start date Start date
K

kymmy

This is probably a really silly question. I have an assignment due fo
TAFE and I have left my Access till last, believing it to be reall
simple and concentrated on my Excel Assignment. I have now come to d
my Access Assignment and I am confused! We have to create an invoic
to be used in a shop. I know how to create forms and reports when yo
are looking at information already in a database, but I'm finding i
difficult to get my head around the actual invoice part.

Do I need to create extra fields in tables to store the amount of eac
invoice? Do I create the actual invoice in the form, or do I do it a
a report? Do I need to save the information which has been created b
the invoice in the tables? (We do have to create reports which wil
tell how much of each product has sold, and what money denomination wa
used(notes or coins) for reconciliation at the end of the day).

All my notes and books only deal with databases of information whic
you can add to, not where you have to use calculations and print
receipt, so I am very confused.

If anyone could give me some hints and tips I would be very grateful!

Kymm
 
I hope I understood you. Generally speaking there is no reason t
create calculated fields in a table (such as invoice totals). You wan
to capture each unique piece of data for the invoice (Part no., Qty
Price per unit, etc) then on your report or form you can creat
controls to capture the calculated values
 
From: kymmy <[email protected]>
Organization: MSAccessForum.com
Newsgroups: microsoft.public.access
Date: Mon, 19 Apr 2004 05:22:44 -0500
Subject: Confused about basic setup

This is probably a really silly question. I have an assignment due fo TAFE
and I have left my Access till last, believing it to be reall simple and
concentrated on my Excel Assignment. I have now come to d my Access
Assignment and I am confused! We have to create an invoic to be used in a
shop. I know how to create forms and reports when yo are looking at
information already in a database, but I'm finding i difficult to get my head
around the actual invoice part.

Do I need to create extra fields in tables to store the amount of
eac
Click to expand...
invoice? Do I create the actual invoice in the form, or do I do it a
a
report? Do I need to save the information which has been created b the
invoice in the tables? (We do have to create reports which wil tell how much
of each product has sold, and what money denomination wa used(notes or coins)
for reconciliation at the end of the day).

All my notes and books only deal with databases of information whic you can
add to, not where you have to use calculations and print receipt, so I am
very confused.

If anyone could give me some hints and tips I would be very grateful!

Kymm
Click to expand...

-----------------------------------------------
~~ Message posted
from http://www.ExcelTip.com
Click to expand...
~~View and post usenet messages directly from
 
Back
Top