I have just finished a simple free demonstration application, the SQL Azure Cloud App 1.0, and I have not had time to test it yet but people are asking for it so I am making it available. You can learn more and download the file here. It is just a simple database to demonstrate how Microsoft Access can get data from SQL Azure. Since I have not had time to test it on other machines yet so please et me know how it works for you. It is most important that you read the ReadMeFirst.txt and the Release Notes.txt files before using the application. It was made for Access 2010 but you may be able to use Access 2007. If you can use it with Access 2007 please let me know.
Update: You can now download a version for Access 2007 and one for Access 2010.
SQL Azure provides access to your data anywhere your computer can connect to the internet, 365 days a year around the clock. With no startup costs for equipment and affordable management plans SQL Azure provides new possibilities for any size company or organization.