Northwind Invoice

  • Thread starter Thread starter ak
  • Start date Start date
A

ak

I have some idea about other things except report in msaccess. We know
Northwind is a sample tool for those who learn msaccess. So how can I study
regarding invoice in Northwind? What are the object I have to study out of
it?
Please comment.
 
When you have Northwind open, you will see a button on your Menu toolbar
next to Help which says Show Me. It will tell you in Detail about any object
that is open.
Evi
 
This is a very broad question: too big to answer in a newsgroup reply.

In essence, you need to learn about how to:
- Design the tables for the Invoice (header) and InvoiceDetail (line items)
- Design a query using multiple tables.
- Design a report using the query as RecordSource.
- Use the Sorting and Grouping in the report to create the group header and
group footer for the invoice, as Northwind does.

Here is a free on-line tutorial that will help you through this process:
http://allenbrowne.com/casu-22.html
You will need to set aside some hours for each step, and actually work
through some practice examples before it becomes familiar.
 
Back
Top