| Access 2003 Location | Access 2007 Location |
|---|---|
| View | Replaced by the navigation pane. |
| Database Objects | Replaced by the navigation pane header menu. |
| Database Objects | Tables | Replaced by the navigation pane header menu. |
| Database Objects | Queries | Replaced by the navigation pane header menu. |
| Database Objects | Diagrams | Replaced by the navigation pane header menu. |
| Database Objects | Forms | Replaced by the navigation pane header menu. |
| Database Objects | Reports | Replaced by the navigation pane header menu. |
| Database Objects | Pages | Removed from product |
| Database Objects | Macros | Replaced by the navigation pane header menu. |
| Database Objects | Modules | Replaced by the navigation pane header menu. |
| Database Objects | Custom Group List | Replaced by the navigation pane header menu. |
| Database Objects | Custom Group List | Replaced by the navigation pane header menu. |
| Database Objects | Custom Group List | Replaced by the navigation pane header menu. |
| Database Objects | Custom Group List | Replaced by the navigation pane header menu. |
| Database Objects | Custom Group List | Replaced by the navigation pane header menu. |
| Database Objects | Custom Group List | Replaced by the navigation pane header menu. |
| Database Objects | Custom Group List | Replaced by the navigation pane header menu. |
| Database Objects | Custom Group List | Replaced by the navigation pane header menu. |
| Database Objects | Custom Group List | Replaced by the navigation pane header menu. |
| Database Objects | More Groups | Replaced by the navigation pane header menu. |
| Large Icons | Replaced by the navigation pane header context menu. |
| Small Icons | Replaced by the navigation pane header context menu. |
| List | Replaced by the navigation pane header context menu. |
| Details | Replaced by the navigation pane header context menu. |
| Arrange Icons | Replaced by the navigation pane. |
| Arrange Icons | By Name | Replaced by the navigation pane header menu. |
| Arrange Icons | By Type | Replaced by the navigation pane header menu. |
| Arrange Icons | By Created | Replaced by the navigation pane header menu. |
| Arrange Icons | By Modified | Replaced by the navigation pane header menu. |
| Arrange Icons | Auto Arrange | Replaced by the navigation pane header menu. |
| Line Up Icons | Replaced by the navigation pane header menu. |
| Design View | Home | View | Design View or Status Bar |
| Design View | Diagram Tools | Design | Views | Mode | Design View |
| Design View | Function & View Tools | Design | Views | Mode | Design View |
| Design View | SQL Statement Tools | Design | Views | Mode | Design View |
| Design View | Stored Procedure Tools | Design | Views | Mode | Design View |
| Design View | Table Tools | Design | Views | Mode | Design View |
| Design View | Form Design Tools | Design | Views | Mode | Design View |
| Design View | Form Layout Tools | Formatting | Views | Mode | Design View |
| Design View | Home | Views | Mode | Design View |
| Design View | Report Design Tools | Design | Views | Mode | Design View |
| Design View | Report Layout Tools | Formatting | Views | Mode | Design View |
| Design View | Table Tools | Datasheet | Views | Mode | Design View |
| Design View | Query Tools | Design | Results | Mode | Design View |
| Design View | PivotChart Tools | Design | Views | Mode | Design View |
| Design View | PivotTable Tools | Design | Views | Mode | Design View |
| SQL View | Mode | SQL View |
| SQL View | Diagram Tools | Design | Views | Mode | SQL View |
| SQL View | Function & View Tools | Design | Views | Mode | SQL View |
| SQL View | SQL Statement Tools | Design | Views | Mode | SQL View |
| SQL View | Stored Procedure Tools | Design | Views | Mode | SQL View |
| SQL View | Table Tools | Design | Views | Mode | SQL View |
| SQL View | Form Design Tools | Design | Views | Mode | SQL View |
| SQL View | Form Layout Tools | Formatting | Views | Mode | SQL View |
| SQL View | Home | Views | Mode | SQL View |
| SQL View | Report Design Tools | Design | Views | Mode | SQL View |
| SQL View | Report Layout Tools | Formatting | Views | Mode | SQL View |
| SQL View | Table Tools | Datasheet | Views | Mode | SQL View |
| SQL View | Query Tools | Design | Results | Mode | SQL View |
| SQL View | PivotChart Tools | Design | Views | Mode | SQL View |
| SQL View | PivotTable Tools | Design | Views | Mode | SQL View |
| SQL View | Mode | SQL View |
| SQL View | Diagram Tools | Design | Views | Mode | SQL View |
| SQL View | Function & View Tools | Design | Views | Mode | SQL View |
| SQL View | SQL Statement Tools | Design | Views | Mode | SQL View |
| SQL View | Stored Procedure Tools | Design | Views | Mode | SQL View |
| SQL View | Table Tools | Design | Views | Mode | SQL View |
| SQL View | Form Design Tools | Design | Views | Mode | SQL View |
| SQL View | Form Layout Tools | Formatting | Views | Mode | SQL View |
| SQL View | Home | Views | Mode | SQL View |
| SQL View | Report Design Tools | Design | Views | Mode | SQL View |
| SQL View | Report Layout Tools | Formatting | Views | Mode | SQL View |
| SQL View | Table Tools | Datasheet | Views | Mode | SQL View |
| SQL View | Query Tools | Design | Results | Mode | SQL View |
| SQL View | PivotChart Tools | Design | Views | Mode | SQL View |
| SQL View | PivotTable Tools | Design | Views | Mode | SQL View |
| Form View | Mode | Form View |
| Form View | Diagram Tools | Design | Views | Mode | Form View |
| Form View | Function & View Tools | Design | Views | Mode | Form View |
| Form View | SQL Statement Tools | Design | Views | Mode | Form View |
| Form View | Stored Procedure Tools | Design | Views | Mode | Form View |
| Form View | Table Tools | Design | Views | Mode | Form View |
| Form View | Form Design Tools | Design | Views | Mode | Form View |
| Form View | Form Layout Tools | Formatting | Views | Mode | Form View |
| Form View | Home | Views | Mode | Form View |
| Form View | Report Design Tools | Design | Views | Mode | Form View |
| Form View | Report Layout Tools | Formatting | Views | Mode | Form View |
| Form View | Table Tools | Datasheet | Views | Mode | Form View |
| Form View | Query Tools | Design | Results | Mode | Form View |
| Form View | PivotChart Tools | Design | Views | Mode | Form View |
| Form View | PivotTable Tools | Design | Views | Mode | Form View |
| Datasheet View | Home | Views | Datasheet View |
| PivotTable View | Mode | PivotTable View |
| PivotTable View | Diagram Tools | Design | Views | Mode | PivotTable View |
| PivotTable View | Function & View Tools | Design | Views | Mode | PivotTable View |
| PivotTable View | SQL Statement Tools | Design | Views | Mode | PivotTable View |
| PivotTable View | Stored Procedure Tools | Design | Views | Mode | PivotTable View |
| PivotTable View | Table Tools | Design | Views | Mode | PivotTable View |
| PivotTable View | Form Design Tools | Design | Views | Mode | PivotTable View |
| PivotTable View | Form Layout Tools | Formatting | Views | Mode | PivotTable View |
| PivotTable View | Home | Views | Mode | PivotTable View |
| PivotTable View | Report Design Tools | Design | Views | Mode | PivotTable View |
| PivotTable View | Report Layout Tools | Formatting | Views | Mode | PivotTable View |
| PivotTable View | Table Tools | Datasheet | Views | Mode | PivotTable View |
| PivotTable View | Query Tools | Design | Results | Mode | PivotTable View |
| PivotTable View | PivotChart Tools | Design | Views | Mode | PivotTable View |
| PivotTable View | PivotTable Tools | Design | Views | Mode | PivotTable View |
| PivotChart View | Mode | PivotChart View |
| PivotChart View | Diagram Tools | Design | Views | Mode | PivotChart View |
| PivotChart View | Function & View Tools | Design | Views | Mode | PivotChart View |
| PivotChart View | SQL Statement Tools | Design | Views | Mode | PivotChart View |
| PivotChart View | Stored Procedure Tools | Design | Views | Mode | PivotChart View |
| PivotChart View | Table Tools | Design | Views | Mode | PivotChart View |
| PivotChart View | Form Design Tools | Design | Views | Mode | PivotChart View |
| PivotChart View | Form Layout Tools | Formatting | Views | Mode | PivotChart View |
| PivotChart View | Home | Views | Mode | PivotChart View |
| PivotChart View | Report Design Tools | Design | Views | Mode | PivotChart View |
| PivotChart View | Report Layout Tools | Formatting | Views | Mode | PivotChart View |
| PivotChart View | Table Tools | Datasheet | Views | Mode | PivotChart View |
| PivotChart View | Query Tools | Design | Results | Mode | PivotChart View |
| PivotChart View | PivotChart Tools | Design | Views | Mode | PivotChart View |
| PivotChart View | PivotTable Tools | Design | Views | Mode | PivotChart View |
| Subform | QAT Customization and Context menu |
| Subform | Form | QAT Customization and Context menu |
| Subform | Datasheet | QAT Customization and Context menu |
| Subform | PivotTable | QAT Customization and Context menu |
| Subform | PivotChart | QAT Customization and Context menu |
| Subform in New Window | Form Design Tools | Design | Tools | Subform in New Window |
| Subform in New Window | Report Design Tools | Design | Tools | Subform in New Window |
| Subreport in New Window | Report Tools | Design | Tools | SubReport in New Window |
| Layout Preview | Form Design Tools | Design | Tools | First 10 Records Preview |
| Layout Preview | Report Design Tools | Design | Tools | First 10 Records Preview |
| Print Preview | Print Preview |
| Print Preview | Office Button | Preview and Print | Print Preview |
| Design View | Mode | Design View |
| Design View | Diagram Tools | Design | Views | Mode | Design View |
| Design View | Function & View Tools | Design | Views | Mode | Design View |
| Design View | SQL Statement Tools | Design | Views | Mode | Design View |
| Design View | Stored Procedure Tools | Design | Views | Mode | Design View |
| Design View | Table Tools | Design | Views | Mode | Design View |
| Design View | Form Design Tools | Design | Views | Mode | Design View |
| Design View | Form Layout Tools | Formatting | Views | Mode | Design View |
| Design View | Home | Views | Mode | Design View |
| Design View | Report Design Tools | Design | Views | Mode | Design View |
| Design View | Report Layout Tools | Formatting | Views | Mode | Design View |
| Design View | Table Tools | Datasheet | Views | Mode | Design View |
| Design View | Query Tools | Design | Results | Mode | Design View |
| Design View | PivotChart Tools | Design | Views | Mode | Design View |
| Design View | PivotTable Tools | Design | Views | Mode | Design View |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Page View | Removed from product |
| Table | Diagram Tools | Design |
| Table | Column Properties | Diagram Tools | Design | Show/Hide | Table Modes | Column Properties |
| Table | Column Names | Diagram Tools | Design | Show/Hide | Table Modes | Column Names |
| Table | Column Names | Diagram Tools | Design | Show/Hide | Table Modes | Column Names |
| Table | Keys | Diagram Tools | Design | Show/Hide | Table Modes | Keys |
| Table | Name Only | Diagram Tools | Design | Show/Hide | Table Modes | Name Only |
| Table | Name Only | Diagram Tools | Design | Show/Hide | Table Modes | Name Only |
| Table | Custom View | Diagram Tools | Design | Show/Hide | Table Modes | Custom View |
| Show Panes | Menu is cut, items are at top level (below) |
| Show Panes | Diagram | Function & View Tools | Design | Tools | Diagram |
| Show Panes | Diagram | Stored Procedure Tools | Design | Tools | Diagram |
| Show Panes | Grid | Function & View Tools | Design | Tools | Grid |
| Show Panes | Grid | Stored Procedure Tools | Design | Tools | Grid |
| Show Panes | SQL | Function & View Tools | Design | Tools | SQL |
| Show Panes | SQL | Stored Procedure Tools | Design | Tools | SQL |
| Totals | Query Tools | Design | Show/Hide | Totals |
| Table Names | Query Tools | Design | Show/Hide | Table Names |
| Indexes / Keys | Diagram Tools | Design | Schema Tools | Indexes / Keys |
| Relationships | Diagram Tools | Design | Schema Tools | Relationships |
| Constraints | Diagram Tools | Design | Schema Tools | Constraints |
| Properties | Database Tools | Show/Hide | Property Sheet |
| Properties | Diagram Tools | Design | Schema Tools | Property Sheet |
| Properties | Function & View Tools | Design | Tools | Property Sheet |
| Properties | SQL Statement Tools | Design | Tools | Property Sheet |
| Properties | Stored Procedure Tools | Design | Tools | Property Sheet |
| Properties | Table Tools | Design | Show/Hide | Property Sheet |
| Properties | Form Design Tools | Design | Tools | Property Sheet |
| Properties | Form Layout Tools | Arrange | Tools | Property Sheet |
| Properties | Report Design Tools | Design | Tools | Property Sheet |
| Properties | Report Layout Tools | Arrange | Tools | Property Sheet |
| Properties | Query Tools | Design | Show/Hide | Property Sheet |
| Properties | PivotChart Tools | Design | Tools | Property Sheet |
| Properties | PivotTable Tools | Design | Tools | Property Sheet |
| Server Properties | Office Button | Server | Server Properties |
| Expand Indicators | PivotChart Tools | Design | Show/Hide | Drill Buttons |
| Expand Indicators | PivotTable Tools | Design | Show/Hide | Drill Buttons |
| Drop Areas | PivotChart Tools | Design | Show/Hide | Drop Zones |
| Drop Areas | PivotTable Tools | Design | Show/Hide | Drop Zones |
| Properties | Database Tools | Show/Hide | Property Sheet |
| Properties | Diagram Tools | Design | Schema Tools | Property Sheet |
| Properties | Function & View Tools | Design | Tools | Property Sheet |
| Properties | SQL Statement Tools | Design | Tools | Property Sheet |
| Properties | Stored Procedure Tools | Design | Tools | Property Sheet |
| Properties | Table Tools | Design | Show/Hide | Property Sheet |
| Properties | Form Design Tools | Design | Tools | Property Sheet |
| Properties | Form Layout Tools | Arrange | Tools | Property Sheet |
| Properties | Report Design Tools | Design | Tools | Property Sheet |
| Properties | Report Layout Tools | Arrange | Tools | Property Sheet |
| Properties | Query Tools | Design | Show/Hide | Property Sheet |
| Properties | PivotChart Tools | Design | Tools | Property Sheet |
| Properties | PivotTable Tools | Design | Tools | Property Sheet |
| Object Dependencies | Database Tools | Show/Hide | Object Dependencies |
| Object Dependencies | Table Tools | Datasheet | Relationships | Object Dependencies |
| Join Properties | Context menu of the join line. |
| Field List | Form Design Tools | Design | Tools | Add Existing Fields |
| Field List | Form Layout Tools | Formatting | Controls | Add Existing Fields |
| Field List | Report Design Tools | Design | Tools | Add Existing Fields |
| Field List | Report Layout Tools | Formatting | Controls | Add Existing Fields |
| Field List | Table Tools | Datasheet | Fields & Columns | Add Existing Fields |
| Field List | Form Design Tools | Design | Tools | Add Existing Fields |
| Field List | Form Layout Tools | Formatting | Controls | Add Existing Fields |
| Field List | Report Design Tools | Design | Tools | Add Existing Fields |
| Field List | Report Layout Tools | Formatting | Controls | Add Existing Fields |
| Field List | Table Tools | Datasheet | Fields & Columns | Add Existing Fields |
| Data Outline | Removed from product |
| Sorting and Grouping | Report Design Tools | Design | Grouping & Totals | Group & Sort |
| Sorting and Grouping | Report Layout Tools | Formatting | Grouping & Totals | Group & Sort |
| Tab Order | Form Design Tools | Arrange | Control Layout | Tab Order |
| Tab Order | Form Layout Tools | Arrange | Control Layout | Tab Order |
| Tab Order | Report Design Tools | Arrange | Control Layout | Tab Order |
| Tab Order | Report Layout Tools | Arrange | Control Layout | Tab Order |
| Indexes | Table Tools | Design | Show/Hide | Indexes |
| Code | Form Design Tools | Design | Tools | View Code |
| Code | Report Design Tools | Design | Tools | View Code |
| HTML Source | Removed from product |
| Ruler | Form Design Tools | Arrange | Show/Hide | Ruler |
| Ruler | Report Design Tools | Arrange | Show/Hide | Ruler |
| Grid | Form Design Tools | Arrange | Show/Hide | Grid |
| Grid | Report Design Tools | Arrange | Show/Hide | Grid |
| Toolbox | Form Design Tools | Controls |
| Page Header/Footer | Form Design Tools | Arrange | Show/Hide | Page Header/Footer |
| Page Header/Footer | Report Design Tools | Arrange | Show/Hide | Page Header/Footer |
| Page Header/Footer | Form Design Tools | Arrange | Show/Hide | Page Header/Footer |
| Page Header/Footer | Report Design Tools | Arrange | Show/Hide | Page Header/Footer |
| Form Header/Footer | Form Design Tools | Arrange | Show/Hide | Form Header/Footer |
| Form Header/Footer | Report Design Tools | Arrange | Show/Hide | Form Header/Footer |
| Report Header/Footer | Report Design Tools | Arrange | Show/Hide | Page Header/Footer |
| Macro Names | Macro Tools | Design | Show/Hide | Macro Names |
| Conditions | Macro Tools | Design | Show/Hide | Conditions |
| Procedure Definition | I can't find this in Access 2003. |
| Task Pane | There is no single entry point for task panes in Access 2007. |
| Toolbars | You can find customization options at Office Button | Access Options | Customize dialog. |
| Toolbars | Alignment and Sizing | These commands are available in the Form and Report Design Tools | Arrange | Control Layout. |
| Toolbars | Database | These commands are available in the Home tab. |
| Toolbars | Filter/Sort | These commands are available in the Home tab. |
| Toolbars | Form Design | "These commands are available in the Form Design Tools Contextual Tab once a form is in Layout or Design View. " |
| Toolbars | Form View | Home | Views | Form View |
| Toolbars | Formatting (Datasheet) | Home | Font | Group Builder |
| Toolbars | Formatting (Form/Report) | Home | Font | Formatting or Form Design Tools | Design | Font |
| Toolbars | Formatting (Page) | Removed from product |
| Toolbars | Formatting (PivotTable/PivotChart) | These commands are available in the PivotChart Tools Contextual Tab once a PivotChart is selected. |
| Toolbars | Macro Design | These commands are available in the Macro Tools Contextual Tab once a macro is opened in design view. |
| Toolbars | Page Design | Removed from product |
| Toolbars | Page View | Removed from product |
| Toolbars | PivotChart | These commands are available in the PivotChart Tools Contextual Tab once a PivotChart is selected. |
| Toolbars | PivotTable | These commands are available in the PivotTable Tools Contextual Tab once a PivotTable is selected. |
| Toolbars | Print Preview | These commands are available in the Print Preview tab once an object is in Print Preview mode. |
| Toolbars | Query Datasheet | Home | Filter and Sort and Records groups |
| Toolbars | Query Design | These commands are available in the Query Design Tools Contextual Tab once a query is opened in design view. |
| Toolbars | Relationship | These commands are available in the Relationships Tools Contextual tab once when viewing a database's relationships. |
| Toolbars | Report Design | These commands are available in the Report Design Tools Contextual Tab once a report is opened in design view. |
| Toolbars | Source Code Control | These commands are available in the Source Code Control Contextual tab. |
| Toolbars | Table Datasheet | Home |
| Toolbars | Table Design | These commands are available in the Table Design Tools Contextual Tab once a table is opened in design view. |
| Toolbars | Task Pane | These commands are not available from one place. Individual objects will open and close task panes as needed. |
| Toolbars | Toolbox | These commands are available in the Form and Report Design Tools | Controls Contextual Tab once a form or report is opened in design or layout view. |
| Toolbars | Utility 1 | I can't find this in Access 2003. |
| Toolbars | Utility 2 | I can't find this in Access 2003. |
| Toolbars | Web | Removed from product |
| Toolbars | Customize | Office Button | Access Options | Customize |
| Zoom | Moved to the status bar and Print Preview | Zoom when an object is in Print Preview mode. |
| Zoom | Maximum 1000% | Print Preview | Zoom | Zoom | 1000% |
| Zoom | 500% | Print Preview | Zoom | Zoom | 500% |
| Zoom | 200% | Print Preview | Zoom | Zoom | 200% |
| Zoom | 150% | Print Preview | Zoom | Zoom | 150% |
| Zoom | Zoom 100% | Print Preview | Zoom | Zoom | Zoom 100% |
| Zoom | 75% | Print Preview | Zoom | Zoom | 75% |
| Zoom | 50% | Print Preview | Zoom | Zoom | 50% |
| Zoom | 25% | Print Preview | Zoom | Zoom | 25% |
| Zoom | 10% | Print Preview | Zoom | Zoom | 10% |
| Zoom | Fit To Window | Print Preview | Zoom | Zoom | Fit To Window |
| Zoom | Zoom Selection | Context menu of a diagram in ADPs |
| Pages | Print Preview |
| Pages | One Page | Print Preview | Zoom | One Page |
| Pages | Two Pages | Print Preview | Zoom | Two Pages |
| Pages | Four Pages | Print Preview | Zoom | More Pages | Four Pages |
| Pages | Eight Pages | Print Preview | Zoom | More Pages | Eight Pages |
| Pages | Twelve Pages | Print Preview | Zoom | More Pages | Twelve Pages |
| Refresh | Replaced by the navigation pane. |
Source: Microsoft (http://www.microsoft.com/)










0 comments:
Post a Comment