excel vba courses london - Databases and forms

The UK's most regular instructor-led training courses.
Training information: excel vba courses london · Excel training courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Databases and forms

Martin has attended:
Access Introduction course
Access Intermediate course
Excel Intermediate course

by - delegate Martin [2 posts] (2007 Jul 26 Thu, 14:13) Reply

how can i put Excel functions on Access tables

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Databases and forms

by - trainer Richard platinum contributer [813 posts] (2007 Jul 26 Thu, 16:36) Reply

Hi Martin,

You create them in Queries.

In a new field, you can do simple math, and also use functions. some of the functions are slightly different, and you may need to look into the help section to verify the syntax.

some examples:

[total]*0.175 (where [total] is a numeric field)

or

GrandTotal: [total]+[vat]

Or

Total: [unit_price]*[quantity]

Regards

Richard