Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - Databases and forms

excel vba courses london - Databases and forms

ResolvedVersion Standard

Thu 26 Jul 2007, 14:13 Delegate Martin said...

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

Databases and forms

how can i put Excel functions on Access tables

Thu 26 Jul 2007, 16:36 Trainer Richard said...

RE: Databases and forms

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

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

excel vba courses london - Databases and forms

Databases and forms

RE: Databases and forms

Excel articles

Excel tip:

Adding date and time