Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Old version of Access
Jackie has attended:
Access Introduction course
Access Intermediate course
I am having to work in Access 2000 until we are updated in a few weeks.
Will I have any problems opening my data in 2007 when it is installed/
Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.
For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:
From the 'Insert' menu select 'Name', then select 'Define'.
Enter the constant
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
