I access 2007 easy ?

[mick]

I have spent quite some time learning to use access (2003) and have just
created my 1st database, helped by all the experts in this site.

My questio is this. Now that I can create a database in 2003 should I stop
and start learning 2007 as 2003 will soon be out of date.

And, most importly - is 2007 easy to learn.

I would like to learn to use code instead of macros - can you learn these in
2007

Thank you for your advice (and to all the exerts here - thank you for your
past answers to other people which I have learn much from)

 

[John W. Vinson]

I have spent quite some time learning to use access (2003) and have just
created my 1st database, helped by all the experts in this site.

My questio is this. Now that I can create a database in 2003 should I stop
and start learning 2007 as 2003 will soon be out of date.

And, most importly - is 2007 easy to learn.

I would like to learn to use code instead of macros - can you learn these in
2007

Thank you for your advice (and to all the exerts here - thank you for your
past answers to other people which I have learn much from)

2007 is a major change from 2003. My understanding is that most databases
designed in 2003 will work in 2007, but the user interface is QUITE different
(the Ribbon is in, menus and toolbars are out); and it's much pickier about
security.

The feedback I've seen is that 2007 is easier to learn than 2003 *for people
who have never used Access at all*, but it's harder to learn for people who
are already used to working with 2003 or earlier versions, just because so
many things are done in a different way. I'll be finding out first hand myself
in the next few days, I need to install it and test some of my apps.

 

[Linq Adams via AccessMonster.com]

John's comments are spot on. Also, the statement that "2003 will soon be out
of date" couldn't be more incorrect. Many, many developers are still using
Access 97 quite successfully. v2003 is, according to most people, the most
stable version produced since v97, and given the huge difference in 2007, I
suspect will be used for years to come.

 

[mick]

Thats blown it

My "wonderful" database is for our weekly shopping - but !!!!! It does not
work as it will not see the difference between "needing" an item (using a
reducing number of stock - pinched from the MS template page) and just
"wanting" an item. Mind you you the "need" to increase my stock of real ale
may be something I could work on ??

Thank you for your answers

Thank you to John Vinson for his help of realationships in tables, Fredg for
his reports help, Klatu for his good ideas about tables (which I was getting
wrong till I read his post to another person), Douglas Steel for his DLookup
help, Wayne-i-m for the gps code (I can locate any supermarket in my area
now), Tina for her bsic tips on her page hich I read when I first started
out, ---- there are just too many

so thanks you to everyone

with a special thanks to Arron Kemp for keeping me amused

I answered a question last night and I hope that I can answer another soon -
watch this space ha ha

Mick
Preston City, UK

 

[Armen Stein]

John's comments are spot on. Also, the statement that "2003 will soon be out
of date" couldn't be more incorrect. Many, many developers are still using
Access 97 quite successfully. v2003 is, according to most people, the most
stable version produced since v97, and given the huge difference in 2007, I
suspect will be used for years to come.

Yes, we're a professional development shop and we've been using Access
2003 almost exclusively, and will continue to do so for a while. We
have only one client that is deploying Office 2007 across their
organization, but that's for internal political reasons, not
technological ones.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Linq Adams via AccessMonster.com]

I knew Mein Kemp had to have some socially redeeming grace!

 

[Wayne-I-M]

If you can used access 2k3 - you can use access 2k7

There are differences but (in the same way that you had to learn previous
versions) you just need spend a little time and you will get it.

Good luck