Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access/Excel - differing versions

	98.1 % recommend us
	More live stats...

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

Training information:

Access/Excel - differing versions

Resolved · Low Priority · Version Standard

Reply Tue 12 Feb 2008, 09:54Delegate Alexis said...

Alexis has attended:
Access Introduction course
Access Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

Access/Excel - differing versions

Would any data be compromised if the excel version used to link to an access database was a later version (eg Excel 2007 linking to Access 2003) ?

For upcoming training course dates see: Pricing & availability

Reply Thu 14 Feb 2008, 09:18Trainer Pete said...

RE: Access/Excel - differing versions

Hi Alexis, Thank you for your post, In answer to your question I cannot see any reason for the data to be compromised as Excel can accept input data from a wide range of input data sources, using the Data - Import External Data operation will show you. I hope that helps best regards Pete

Access articles

· Discover the Secrets within Your Business through Microsoft Access Training
· Keeping Your Access Database Updated
· Why Do I Need To Use Access?
· How Reorganising Your Data Can Take Your Business to the Next Level
· How To Create Combo Lookups In Microsoft Access

Please browse our web site to find out more about
introduction access training and other Microsoft training courses.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips