functions

[Guest]

This question might be very simple, but i am very new to this program

does Access has functions and formulas like the ones in Excel? Does it do
complicated calculations like Excel? or is it just a for recording data?

 

[Duane Hookom]

There are lots of functions and a full VBA programming language much like
Excel.

 

[Douglas J. Steele]

Just to expand on Duane's answer a little.

Yes, Access has a full range of functions and can do complicated
calculations like Excel. Unlike Excel, though, you cannot use the functions
on tables. You must create queries and/or forms based on the tables, and use
the functions in the queries and forms.