access courses in london - Microsoft 2003 and Microsoft 2007 compatibility

The UK's most regular instructor-led training courses.
Training information: access courses in london · Courses in microsoft access · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Microsoft 2003 and Microsoft 2007 compatibility

Dave has attended:
No courses

by - delegate Dave bronze contributer [32 posts] (2007 Jul 27 Fri, 15:12) Reply

Hi

If I have Microsoft Access 2003 files will I be able to use them within Microsoft Access 2007? Also If I have a Microsoft Access 2007 files, will I be able to open it in Microsoft Office 2003.

Thanks again for you Microsoft Access training support forum.

Dave

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Bayswater	0	FULL
2003	2008 Sep 3 Wed	Southwark	1	book now	£235	£240
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	8	book now	£110	£224
Full Schedule: See all 55 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Microsoft 2003 and Microsoft 2007 compatibility

by - trainer David gold contributer [428 posts] (2007 Jul 27 Fri, 16:09) Reply

Hi Dave,

You shouls be able to use your Microsoft Access 2003 files with Microsoft Access 2007, however you will not be able to use you Microsoft Access 2007 files with Microsoft Access 2003, unless you save them to be compatible with previous version of Microsft Access. You may also be albe to find some 3rd party Microsoft Access compatibility tools.

Hope this helps
David

· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Reasons to Consider Microsoft Access Training
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Access Database Optimization: First Normal Form
· Learn about Subqueries in Access Courses

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips

Institute of IT Training - Accredited Training Provider

Prodigy Platinum Learning Partner

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

access courses in london - Microsoft 2003 and Microsoft 2007 compatibility

Related articles

Access tip:

Calculating The Difference Between Dates