Pin Me

Microsoft Access 2007 - What’s Different and Where to Find the Familiar Menu Items

written by: Curt Smothers•edited by: Rebecca Scudder•updated: 11/17/2009

Microsoft Access 2007 has a different and “busier” look than the 2003 version. This is the first in a series of MS Access 2007 user interface overviews. Our first article will explain and catalog the menu items on the new MS Access tabbed ribbon.

  • slide 1 of 8

    Where did everything go?

    Microsoft Office 2007 added a common “ribbon” interface to all of its applications. MS Access, Word, Excel, and PowerPoint now have an array of tabbed ribbons at the top of their windows along with the common “Office Button” in the top left for better integration in the office suite. This article will briefly demonstrate the four tabbed ribbons divided into their various function groups where MS Access 2007 presents its user interface in a far more robust and user-friendly interface than in previous versions.

    The tabs are Home, Create, External Data, and Database Tools. Click on each tab to expose the individual menu groups. The revised interface can be somewhat daunting to the new user because of the sheer number of items that were once located in the more familiar drop-down menus of Access 2003.

  • slide 2 of 8

    The Basic Menu Tabs in Microsoft Access 2007

    1 - Home. Click on this tab to access basic formatting, spell checking, filtering and finding existing records.

    Home Tab 

  • slide 3 of 8

    2 - Create. Go to this tab to build your new database objects: tables, forms, reports and queries.

    Create Tab 

  • slide 4 of 8

    3 - External Data. Import and export data from other applications. Use the Create E-mail Wizard in the Collect Data group to solicit information that can be incorporated directly into your database. Fully integrate your database into Microsoft’s SharePoint for full workgroup integration.

    External Data Tab 

  • slide 5 of 8

    4 - Database Tools. Access the Visual Basic core of your database. Go to this tab to establish table relationships, analyze your database objects and move your data to an SQL server. The Database Tools group of this tab (last on the right) helps you link up your tables, create a switchboard, add a password and make an ACCDE (read-only database shell) file from your database.

    Database Tools Tabs 

  • slide 6 of 8

    Where Everything Went - An Alphabetical List of Access 2007 Menus

  • slide 7 of 8

    More information on What's New in Access 2007

    Additional information from Microsoft Office:

    Microsoft Office Online - What's new in Microsoft Access 2007

    Command your database: The Ribbon

  • slide 8 of 8