Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel V Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel V Access

Resolved · Low Priority · Version Standard

Reply Wed 20 Feb 2008, 16:46Delegate Siobh said...

Siobh has attended:
Excel Intermediate course
Excel Advanced course

Excel V Access

What is the difference between Excel & Access?

For upcoming training course dates see: Pricing & availability

Reply Sat 23 Feb 2008, 22:37Trainer Cress said...

RE: Excel V Access

Well access is a full database product. You can store data in tables and create queries on the tables to return data sets. You can also use the access functionality to create forms for user entry and reports. Excel uses tabs and worksheets to hold data in single tabs and sheets and not in a database format. Some of the functionality overlapps in places though.

Excel articles

· VBA Excel 2007
· How To Disguise Error Messages In Excel 2007/2010
· Is It Time For You To Trade Up To Excel 2010?
· How To Create An Argument With Excel
· How To Use The Research Functionality In Excel 2010

Please browse our web site to find out more about
excel+vba+training and other Microsoft training courses.

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips