Where is Lookup Wizard in Microsoft Access 2007?
- Familiar way to get Lookup Wizard in Access 2007 if you have Classic Menu for Office
- If you do not have Classic Menu for Office
If you want to create a related table in Access 2007, the Lookup Wizard will help you work fast. Here we will introduce two methods to get Lookup Wizard in Access 2007 for you:
Familiar way to get Lookup Wizard if you have Classic Menu for Office
The goal of Classic Menu for Office is to bring you back into the interface of Microsoft Access 2003 that you are used to. It will restore familiar menus and toolbar, so that you can get the Lookup Wizard in Access 2007 with the same way that you did in Access 2003:
- Click the Insert drop down menu in main menus;
- Click the Lookup Column item;
- Then the Lookup Wizard dialog will pop up.
Figure 1: Get Lookup Wizard in Classic Menu
If you do not have Classic Menu for Office
The Access 2007 Ribbon is quite different from the menus of Access 2003. Commands and buttons are grouped into different tabs. We will guide you to look for the Lookup Wizard in Access 2007:
- Click the Datasheet tab;
- Go to the Fields & Columns group;
- Click the Lookup Column button;
- Then the Lookup Wizard dialog will come out.
Figure 1: Get Lookup Wizard in Classic Menu
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.
|
