Migrating from Access 2003 to Access 2007

with David Rivers
please wait ...
Migrating from Access 2003 to Access 2007
Video duration: 0s 49m 1s Appropriate for all


In Migrating from Access 2003 to Access 2007, author David Rivers explains the key differences between Access 2007 and Access 2003 and the benefits of upgrading to the 2007 version of Microsoft's database design software. The course covers key differences Access 2003 users need to understand, including the new Ribbon interface, database templates, the improved Layout View and the new Open XML file format. Exercise files accompany the course.

Topics include:
  • Comparing the Access 2003 and 2007 interfaces
  • Changing the default file format
  • Ensuring compatibility with the Compatibility Checker
  • Controlling Access with keyboard shortcuts
  • Adding attachments to records with the Attachment field type
  • Converting older databases
  • Filtering data without a query
  • Designing in the improved Layout View


- [Voiceover] Hi, and welcome to Migrating from Access 2003 to Access 2007. I'm David Rivers. Microsoft has incorporated some major changes and improvements in Access 2007. So, if you're considering migrating from Access 2003, this title will help to make your transition to Access 2007 a smooth one. We'll begin with a tour of the new and improved user interface. Namely the ribbon, where you'll find easy and logical access to the various features and functions in Access 2007.

Then we'll investigate the various options for staying compatible with older versions of Microsoft Access. Such as, continuing to work with Access 2003 databases in Access 2007, versus converting older databases to Access 2007 databases, that use a new format. Now the way you perform many of the common commands in Microsoft Access 2003 may be performed in a different way in Access 2007. So we'll investigate the Office button for common file related commands and we'll work with the Quick Access toolbar to help create a more efficient work environment.

We'll discover new ways to view the parts of your database. New fields and options. And we'll also work with the mini toolbars for even faster access to related functionality when selecting content in Access 2007. So, so much to cover, let's get started.

please wait ...