Where is Create Query in Microsoft Access 2007 and 2010?
- Used way to create query if you have Classic Menu for Office
- If you do not have Classic Menu for Office
If you request database information displayed in a Window format, you may need to create a query. The Query creating wizard buttons stay different places in Microsoft Access 2010, Access 2007, and Access 2003. Here we will list the ways to find Query Wizard in Access 2007 and Access 2010.
Used way to create query if you have Classic Menu for Office
Classic Menu for Office will bring you back to the interface of Access 2003, so you can easily find the Query Wizard functionalities in Access 2007 and Access 2010:
- Click the Insert drop down menu in main menus;
- Click the Query items;
- Then you will view the Query Wizard. This Query Wizard will guide you to create simple queries.
Figure 1: Create Queries with Classic Menu
If you do not have Classic Menu for Office
Although both Microsoft Access 2010 and Access 2007 replace the classic menus interface with Ribbon User interface, it is quite different between two Ribbons.
Seek Query Wizard in Access 2007 Ribbon
- Click the Create tab in Access 2007;
- Go to the Other group;
- Then you will view the Query Wizard button.
Figure 2: Query Wizard in Access 2007 Ribbon
Seek Query Wizard in Access 2007 Ribbon
- Click the Create tab in Access 2010;
- Go to the Queries group;
- Then you will view the Query Wizard button.
Figure 3: Query Wizard in Access 2010 Ribbon
More tips for Microsoft Access
- Where is Compact and Repair
- Where is Convert Database
- Where is Create Query
- Where is Design View
- Where is Field List
- Where is Form
- Where is Help
- Where is Linked Table Manager
- Where is Lookup Wizard
- Where is MDB Save As
- Where is Message Bar
- Where is Navigation Pane
- Where is Security
- Where is Startup
- Where is Switchboard Manager
- Where is Workgroup Manager
Classic Menu for Office
Frustrated by endless searches for commands on the ribbon interface of Access? The Classic Menu for Office brings back the familiar menus and toolbars to Microsoft Access 2007 and 2010. The classic view allows you to work with Office 2010 as if it were Office 2003.
- All new features and commands for Access 2007 and 2010 have been added to the menus and toolbars.
- You can still enjoy many features of Access 2003 that have been removed from Access 2007 and 2010.
- You won't need any training or tutorials after upgrading to Microsoft Access 2007 and 2010.
 |
Classic Menu for Office 2007It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.
|
|
Classic Menu for Office 2010It includes Classic Menu for Word, Excel, PowerPoint, Access, Outlook, Publisher, InfoPath, Visio and Project 2010.
|
