Locations of Access 2003 commands in Access 2007 : Query

Access 2003 Location	Access 2007 Location
Run	Function & View Tools | Design | Tools | Run
Run	SQL Statement Tools | Design | Tools | Run
Run	Stored Procedure Tools | Design | Tools | Run
Run	Macro Tools | Design | Tools | Run
Run	Query Tools | Design | Results | Run
Verify SQL Syntax	Function & View Tools | Design | Tools | Verify SQL Syntax
Verify SQL Syntax	SQL Statement Tools | Design | Tools | Verify SQL Syntax
Verify SQL Syntax	Stored Procedure Tools | Design | Tools | Verify SQL Syntax
Group By	Function & View Tools | Design | Output Operations | Group By
Group By	Stored Procedure Tools | Design | Output Operations | Group By
Add Table	Diagram Tools | Design | Show/Hide | Add Table
Add Table	Function & View Tools | Design | Output Operations | Add Table
Add Table	Stored Procedure Tools | Design | Output Operations | Add Table
Remove	Function & View Tools | Design | Output Operations | Remove
Remove	Stored Procedure Tools | Design | Output Operations | Remove
Show Table	Relationship Tools | Design | Relationships | Show Table
Show Table	Query Tools | Design | Query Setup | Show Table
Remove Table	Context menu of the table header in query design view.
Add to Output	Function & View Tools | Design | Output Operations | Add to Output
Add to Output	Stored Procedure Tools | Design | Output Operations | Add to Output
Sort Ascending	Function & View Tools | Design | Output Operations | Sort Ascending
Sort Ascending	Stored Procedure Tools | Design | Output Operations | Sort Ascending
Sort Descending	Function & View Tools | Design | Output Operations | Sort Descending
Sort Descending	Stored Procedure Tools | Design | Output Operations | Sort Descending
Remove Filter	Home | Filter and Sort | Clear All Filters
Select All Rows from	Moved to the context menu.
Select All Rows from	Moved to the context menu.
Manage Indexes	Function & View Tools | Design | Tools | Manage Indexes
Manage Indexes	Stored Procedure Tools | Design | Tools | Manage Indexes
Select Query	Query Tools | Design | Query Type | Select
Crosstab Query	Query Tools | Design | Query Type | Crosstab
Make-Table Query	Query Tools | Design | Query Type | Make Table
Update Query	Query Tools | Design | Query Type | Update
Append Query	Query Tools | Design | Query Type | Append
Delete Query	Query Tools | Design | Query Type | Delete
Select Query	Stored Procedure Tools | Design | Query Type | Select Query
Make-Table Query	Stored Procedure Tools | Design | Query Type | Make-Table Query
Update Query	Stored Procedure Tools | Design | Query Type | Update Query
Append Query	Stored Procedure Tools | Design | Query Type | Append Query
Append Values Query	Stored Procedure Tools | Design | Query Type | Append Values Query
Delete Query	Stored Procedure Tools | Design | Query Type | Delete Query
SQL Specific	Query Tools
SQL Specific | Union	Query Tools | Design | Query Type | Union
SQL Specific | Pass-Through	Query Tools | Design | Query Type | Pass-Through
SQL Specific | Data Definition	Query Tools | Design | Query Type | Data Definition
Parameters	Query Tools | Design | Show/Hide | Parameters
Query Datasheet | View	Microsoft Office Button | Access Options | Customization | All Commands | Table Design
Query Datasheet | Save	Save
Query Datasheet | Save	Microsoft Office Button |Save
Query Datasheet | File Search	Removed from product
Query Datasheet | Print	Quick Print
Query Datasheet | Print	Microsoft Office Button |Preview and Print | Quick Print
Query Datasheet | Print Preview	Print Preview
Query Datasheet | Print Preview	Microsoft Office Button |Preview and Print | Print Preview
Query Datasheet | Spelling	Home | Records | Spelling
Query Datasheet | Cut	Home | Clipboard | Cut
Query Datasheet | Copy	Home | Clipboard | Copy
Query Datasheet | Paste	Home | Clipboard | Paste
Query Datasheet | Paste	Home | Clipboard | Paste | Paste
Query Datasheet | Format Painter	Form Design Tools | Design | Font | Format Painter
Query Datasheet | Format Painter	Form Layout Tools | Formatting | Font | Format Painter
Query Datasheet | Format Painter	Report Design Tools | Design | Font | Format Painter
Query Datasheet | Format Painter	Report Layout Tools | Formatting | Font | Format Painter
Query Datasheet | Format Painter	Home | Clipboard | Format Painter
Query Datasheet | Can't Undo	Undo
Query Datasheet | Can't Undo	Microsoft Office Button | Access Options | Customization | All Commands | Undo
Query Datasheet | Hyperlink	Form Design Tools | Design | Controls | Hyperlink
Query Datasheet | Hyperlink	Report Design Tools | Design | Controls | Hyperlink
Query Datasheet | Sort Ascending	Home | Sort & Filter | Ascending
Query Datasheet | Sort Ascending	PivotChart Tools | Design | Filter & Sort | Ascending
Query Datasheet | Sort Ascending	PivotTable Tools | Design | Filter & Sort | Ascending
Query Datasheet | Sort Descending	Home | Sort & Filter | Descending
Query Datasheet | Sort Descending	PivotChart Tools | Design | Filter & Sort | Descending
Query Datasheet | Sort Descending	PivotTable Tools | Design | Filter & Sort | Descending
Query Datasheet | Filter By Selection	Microsoft Office Button | Access Options | Customization | All Commands | Filter By Selection
Query Datasheet | Filter By Form	Home | Sort & Filter | Advanced | Filter By Form
Query Datasheet | Toggle Filter	Other Commands | | Toggle Filter
Query Datasheet | Toggle Filter	Home | Sort & Filter | Toggle Filter
Query Datasheet | Find	Home | Find | Find
Query Datasheet | New Record	Home | Records | New
Query Datasheet | New Record	Home | Find | Go To | New
Query Datasheet | Delete Record	Home | Records | Clear | Delete Record
Query Datasheet | Database Window	Replaced by the navigation pane.
Query Datasheet | New Object	Create
Query Datasheet | Microsoft Office Access Help	Help
Query Datasheet | Microsoft Office Access Help	Microsoft Office Button | Access Options | Customization | All Commands | Help
Query Datasheet | Grid	Home | Font | Datasheet Formatting builder
Query Design | View	Microsoft Office Button | Access Options | Customization | All Commands | Table Design
Query Design | Save	Save
Query Design | Save	Microsoft Office Button |Save
Query Design | File Search	Removed from product
Query Design | Print	Quick Print
Query Design | Print	Microsoft Office Button |Preview and Print | Quick Print
Query Design | Print Preview	Print Preview
Query Design | Print Preview	Microsoft Office Button |Preview and Print | Print Preview
Query Design | Spelling	Home | Records | Spelling
Query Design | Cut	Home | Clipboard | Cut
Query Design | Copy	Home | Clipboard | Copy
Query Design | Paste	Home | Clipboard | Paste
Query Design | Paste	Home | Clipboard | Paste | Paste
Query Design | Format Painter	Form Design Tools | Design | Font | Format Painter
Query Design | Format Painter	Form Layout Tools | Formatting | Font | Format Painter
Query Design | Format Painter	Report Design Tools | Design | Font | Format Painter
Query Design | Format Painter	Report Layout Tools | Formatting | Font | Format Painter
Query Design | Format Painter	Home | Clipboard | Format Painter
Query Design | Undo	Undo
Query Design | Undo	Microsoft Office Button | Access Options | Customization | All Commands | Undo
Query Design | Redo	Redo
Query Design | Redo	Microsoft Office Button | Access Options | Customization | All Commands | Redo
Query Design | Query Type	Query Tools | Design | Query Type
Query Design | Run	Function & View Tools | Design | Tools | Run
Query Design | Run	SQL Statement Tools | Design | Tools | Run
Query Design | Run	Stored Procedure Tools | Design | Tools | Run
Query Design | Run	Macro Tools | Design | Tools | Run
Query Design | Run	Query Tools | Design | Results | Run
Query Design | Show Table	Relationship Tools | Design | Relationships | Show Table
Query Design | Show Table	Query Tools | Design | Query Setup | Show Table
Query Design | Totals	Query Tools | Design | Show/Hide | Totals
Query Design | Top Values	Query Tools | Design | Query Setup | Return
Query Design | Properties	Database Tools | Show/Hide | Property Sheet
Query Design | Properties	Diagram Tools | Design | Schema Tools | Property Sheet
Query Design | Properties	Function & View Tools | Design | Tools | Property Sheet
Query Design | Properties	SQL Statement Tools | Design | Tools | Property Sheet
Query Design | Properties	Stored Procedure Tools | Design | Tools | Property Sheet
Query Design | Properties	Table Tools | Design | Show/Hide | Property Sheet
Query Design | Properties	Form Design Tools | Design | Tools | Property Sheet
Query Design | Properties	Form Layout Tools | Arrange | Tools | Property Sheet
Query Design | Properties	Report Design Tools | Design | Tools | Property Sheet
Query Design | Properties	Report Layout Tools | Arrange | Tools | Property Sheet
Query Design | Properties	Query Tools | Design | Show/Hide | Property Sheet
Query Design | Properties	PivotChart Tools | Design | Tools | Property Sheet
Query Design | Properties	PivotTable Tools | Design | Tools | Property Sheet
Query Design | Build	Table Tools | Design | Tools | Builder
Query Design | Build	Macro Tools | Design | Tools | Builder
Query Design | Build	Query Tools | Design | Query Setup | Builder
Query Design | Database Window	Replaced by the navigation pane.
Query Design | New Object	Create
Query Design | Microsoft Office Access Help	Help
Query Design | Microsoft Office Access Help	Microsoft Office Button | Access Options | Customization | All Commands | Help

Source: Microsoft (http://www.microsoft.com/)