| Access 2003 Location | Access 2007 Location |
|---|---|
| PivotTable | These commands are available in the PivotTable Tools Contextual Tab once a PivotTable is inserted or selected. |
| Sort | PivotChart Tools | Design | Filter & Sort |
| Sort | Sort Ascending | PivotChart Tools | Design | Filter & Sort | Ascending |
| Sort | Sort Ascending | PivotChart Tools | Design | Filter & Sort | Ascending |
| Sort | Sort Ascending | PivotTable Tools | Design | Filter & Sort | Ascending |
| Sort | Sort Descending | PivotChart Tools | Design | Filter & Sort | Descending |
| Sort | Sort Descending | PivotChart Tools | Design | Filter & Sort | Descending |
| Sort | Sort Descending | PivotTable Tools | Design | Filter & Sort | Descending |
| Sort | Ascending by Total | PivotChart Tools | Design | Filter & Sort | By Total | Ascending by Total |
| Sort | Descending by Total | PivotChart Tools | Design | Filter & Sort | By Total | Descending by Total |
| AutoFilter | PivotChart Tools | Design | Filter & Sort | AutoFilter |
| AutoFilter | PivotTable Tools | Design | Filter & Sort | AutoFilter |
| Show Top/Bottom Items | PivotTable Tools | Design | Filter and Sort | Show… |
| AutoCalc | PivotChart Tools | Design | Tools | AutoCalc |
| AutoCalc | PivotTable Tools | Design | Tools | AutoCalc |
| Subtotal | PivotTable Tools | Design | Tools | Subtotal |
| Calculated Totals and Fields | PivotTable | Design | Tools | Calculated Totals… |
| Show As | PivotTable Tools | Design | Tools | Show As |
| Expand | PivotChart Tools | Design | Active Field | Expand Field |
| Expand | PivotTable Tools | Design | Active Field | Expand Field |
| Collapse | PivotChart Tools | Design | Active Field | Collapse Field |
| Collapse | PivotTable Tools | Design | Active Field | Collapse Field |
| Hide Details | PivotTable Tools | Design | Show/Hide | Hide Details |
| Show Details | PivotTable Tools | Design | Show/Hide | Show Details |
| Refresh | PivotChart Tools | Design | Data | Refresh Pivot |
| Refresh | PivotTable Tools | Design | Data | Refresh Pivot |
| Export to Microsoft Office Excel | PivotTable Tools | Design | Data | Export to Excel |
| View | Microsoft Office Button | Access Options | Customization | All Commands | Table Design |
| Save | Save |
| Save | Microsoft Office Button |Save |
| File Search | Removed from product |
| Quick Print | |
| Microsoft Office Button |Preview and Print | Quick Print | |
| Print Preview | Print Preview |
| Print Preview | Microsoft Office Button |Preview and Print | Print Preview |
| Copy | Home | Clipboard | Copy |
| Sort Ascending | Home | Sort & Filter | Ascending |
| Sort Ascending | PivotChart Tools | Design | Filter & Sort | Ascending |
| Sort Ascending | PivotTable Tools | Design | Filter & Sort | Ascending |
| Sort Descending | Home | Sort & Filter | Descending |
| Sort Descending | PivotChart Tools | Design | Filter & Sort | Descending |
| Sort Descending | PivotTable Tools | Design | Filter & Sort | Descending |
| AutoFilter | PivotChart Tools | Design | Filter & Sort | AutoFilter |
| AutoFilter | PivotTable Tools | Design | Filter & Sort | AutoFilter |
| Show Top/Bottom Items | PivotTable Tools | Design | Filter and Sort | Show… |
| AutoCalc | PivotChart Tools | Design | Tools | AutoCalc |
| AutoCalc | PivotTable Tools | Design | Tools | AutoCalc |
| Subtotal | PivotTable Tools | Design | Tools | Subtotal |
| Calculated Totals and Fields | PivotTable | Design | Tools | Calculated Totals… |
| Show As | PivotTable Tools | Design | Tools | Show As |
| Collapse | PivotChart Tools | Design | Active Field | Collapse Field |
| Collapse | PivotTable Tools | Design | Active Field | Collapse Field |
| Expand | PivotChart Tools | Design | Active Field | Expand Field |
| Expand | PivotTable Tools | Design | Active Field | Expand Field |
| Hide Details | PivotTable Tools | Design | Show/Hide | Hide Details |
| Show Details | PivotTable Tools | Design | Show/Hide | Show Details |
| Refresh | PivotChart Tools | Design | Data | Refresh Pivot |
| Refresh | PivotTable Tools | Design | Data | Refresh Pivot |
| Export to Microsoft Office Excel | PivotTable Tools | Design | Data | Export to Excel |
| 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 |
| 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 |
| Database Window | Replaced by the navigation pane. |
| New Object | Create |
| Microsoft Office Access Help | Help |
| Microsoft Office Access Help | Microsoft Office Button | Access Options | Customization | All Commands | Help |
Source: Microsoft (http://www.microsoft.com/)
RSS Feeds
0 comments:
Post a Comment