Access 2007 After One Hour – Initial Highlights

I’ve been using Access 2007 for about an hour now, quickly developing a small database to store information on what periodicals I’ve been reading for my thesis, and when I have accessed them. Quick review – it is fairly impressive! Highlights are:

  • The Ribbon Gui common to all Office 2007 products is used very well in Access 2007
  • Graphical Calendar Lookup for Date Fields.
  • Split View Forms – Graphical Form at top, Datasheet at the bottom.
  • Ability to standardised formatting of controls on a form, meaning left, top, width and height values are consistent for groups of form controls! This means one can ‘pretty’ up a form much faster and easier.
  • Combo Box Lookup Wizards in Table Design.

Hopefully it won’t take too much time away from me actually *doing* work!

Access 2003 – Importing Queries results in bad query aliasing.

This is a quick little tip.

I came across a minor annoyance the other day when I was importing Access saved queries from another database and using link tables. If you import your queries before you link your tables, then try run the queries with no tables link – Access will complain that it can’t find the tables, then litter your queries that use those linked tables with aliases like “expr1:” “expr2:” and so on. This means that if you use a lot of saved queries you’re going to waste valuable time fixing them all up.

The trick is very simple and, when you think about it, does make sense – link your tables before you import anything.

Ms Access – The Upgrade

I’d never thought I’d ever say something so geeky but I must comment that I don’t think I’ve ever been as excited about downloading a product as I am right now. And right now I’m downloading Ms Access 2007. I’m taking advantage of the http://www.itsnotcheating.com.au offer, and buying the new version of Office 2007 Ultimate for $75. That is a bargain.

I’m presently doing a small bit of consulting work, developing in Access 2003, and have stumbled into a small problem. I have never worked with the Runtime version of Access, and now I’m being requested to deploy my new database using it (client doesn’t necessarily have Ms Access installed on all users computers’). I have come to realise that in order to properly license Runtime Access applications, I will have to splurge out something in the line of $1,000 AUD.

Lucky, MS have decided to be a bit more kind to developers in the new version, and will offer Runtime licenses free of charge! Unfortunately, the Runtime Access kit isn’t available yet – but should be soon!

Well, it’s official. As of later tonight, I will be happily coding away in Access 2007.

Geek!