Northwind Invoice

[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.

 

[Evi]

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

 

[Allen Browne]

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.