Access 2010—The 10,000 ft. View

Last week I wrote about the Office 2010 Technical Preview bevy of announcements. This post kicks off a series of conversations about what is new in Microsoft Access 2010. As a team, our passion is to help people quickly and easily create databases tailored to their needs with tools that are affordable, fast and efficient. Access 2010 is the next iteration in this quest.

Here is a peek at some of the many changes you will see:

  • Get started faster. One thing we have learned from the Access 2007 template effort is—people are more successful when they start from template that closely matches their needs. A while back we blogged that Office Online allows developers to submit Access templates. The new Getting Started experience includes community templates to make it easier for people to get rolling. It also provides an avenue for developers to share their creative work.
  • Better design and customization tools. Changes to the design tools make it faster to develop and customize databases to fit your needs. Integration with Office themes brings beautiful color palettes and a modern look to your application. A new navigation control enables codeless tab style navigation, similar to many web sites. The revamped macro designer makes it easier to write more powerful, readable logic while IntelliSense speeds up development and reduces errors.
  • Centralize business logic. Data macros allow you to write logic behind tables similar to SQL triggers. This makes it easier to maintain applications because you can centralize business logic:

image

  • Landing pad for data. We hear more and more that people want to use content from the Web and data from web services. A new Web Browser control gives users the ability to create Web 2.0 mash-ups and display web content in the application. Integration with Business Connectivity Services (BCS) allows people to create read-only link tables to LOB web services, which enable users to make use of trusted and validated data provided by IT.
  • SharePoint performance and offline. SharePoint adoption continues to grow fast as the platform helps people in organizations work better together. Access 2010 extends the ability of Access 2007 with improvements to the link table cache and offline models. List data is cached in local tables to improve large list performance. When server connectivity is lost, the database automatically goes into offline mode. When connectivity is restored, Access automatically synchronizes data changes for you.
  • Browser apps. One of the most common requests we hear from people is to make it easier to share databases in the browser. We will talk more about advancements in this area after the SharePoint Developer Conference in October.

This isn’t a complete list but rather the 10,000 foot view. Over the next few months we will dive into details. The team looks forward to your feedback through the beta newsgroups and this blog.

Next week we will talk about changes to the macro designer and IntelliSense followed by a discussion about data macros.

Updated 7/13/2009 with image of a data macro.

Office Blogs Comments

Comments: (24) Collapse

  • Fantastic advances, great job Clint and team! Can't wait for the RTM.

  • So far, I couldn't be happier with what I'm seeing in the TP. Thanks.

  • What about easy customisation of the Ribbon?? The good ole drag and drop? sigh

  • Domenic, there are some details about customisation of the ribbon at news.office-watch.com/.../n.aspx. If I have read it correctly, the built-in functionality allows you quite a bit of freedom to move items around your ribbons, but I didn't see anything about adding your own controls and associated code. Alan

  • Clint, I'm loving what I'm hearing so far....can't wait to hear more ! Thanks ! J.

  • I have one request for the Access team. Can you make Access 2010 not require MSI registration upon each startup so I can run 2003 and 2010 side by side or 2007 and 2010 side by side without Windows Installer launching every time I start either version? This is long overdue. Word allows that by setting a NoReReg value, why not Access?

  • This looks good. For the longest while I wanted Access to have a Trigger style feature so it is good to see something coming. Browser Apps you said, my mouth is drooling already!!

  • What is meant by "share databases in the browser". Does this mean that forms, reports, etc are created and can be displayed in a browser?

  • Clint,

    Are you able to say if there are any changes to security in Access 2010, i.e. is there anything resembling user-level security or does it remain at the file level with encryption and a database password? Thanks, Alan

  • Any improvements on the performance as a whole? I know that in Access 2007, when a table reaches 1.5 million records, things start to slow down considerably.

    Is that side also improved?

  • Sounds absolutely great. Can we have a native tree and list view control with easy access to the Office icon set (please :-))

  • An idea I've had for quite a while. I'd like to be able to change the order of the selections in the properties window. There are some I never use and others that are, in inconvenient places, used all the time. That would speed up development considerably. Thanks for the consideration.

  • Thanks for the compliments Brandon, George, Joseph, dallr, and Raymond. @Domenic: We wanted a better ribbon developer customization story but it didn't make it into the release. The experience for customizing user ribbons is pretty good but unfortunately this work doesn't extend to dtabase specific customizations. There are some good third party tools in this area that are turning out to be really good. @someone: I understand your frustration. We have looked at this issue multiple times but not been able to come up with a engineering solution that is affordable and reliable. Re-registration is required for make VBA run against the right type libraries and communicate with ACE. We are looking at solutions that look trackable next release. I know this isn't what you want to hear. @DW: sorry, I can't discuss what exactly is meant "by share databases in the browser." @Alan: there isn't anything that will give you user-level security. You would need to use mdb databases, create your own security model, or move your data to a server. @Sako: I'm not aware of any change that will speed up 1.5 million record queries. You might find 64 bit will speed it up but I'm not the expert in this area. @Raymond: I would love to make it possible to show icons in the datasheet. This has been on our list for a while. Neither of your requests are part of the plan right now. @David: Cool idea... Thanks for the suggestion.

  • David Schmucker, I agree. This would be a great improvement. VS needs this also.

  • When will we be able to get Office 2010, or is it available for download now? I like what I have seen, and want to try it. Dan

1 2  Next >
Comments

Comments: (loading) Collapse