Access Invoicing

The UK's most regular instructor-led training courses.
Training information: ms access course · Access course microsoft training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2003

Access Invoicing

Grace has attended:
Access Advanced course

by - delegate Grace [1 post] (2008 Aug 6 Wed, 15:30) Reply

What is the best and quickest method for designing an invoice in Access

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Access Invoicing

by - trainer Stephen gold contributer [369 posts] (2008 Aug 12 Tue, 13:09) Reply

Hi Grace

Thank you for your question

The quickest method for designing an invoice would be to create a query that selects the required information for the invoice and then to run a report that uses that query as its record source.

A second solution would be to export the query into Excel and create the invoice there

Regards

Stephen

· Access VBA Training Adds Power to your Databases
· Learn about Subqueries in Access Courses
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Convert a Paper Trail to a DBMS
· Microsoft Access: Unleash the True Potential Today

Please browse our web site to find out more about
ms access course and other Microsoft training courses.

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes

Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips