How to Make an Auto Lookup Query in Access 2007

Written by katrina matterhorn
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make an Auto Lookup Query in Access 2007
You can create a lookup query with a few commands in Microsoft Access. (laptop image by Angie Lingnau from Fotolia.com)

Microsoft Access is a relational database application designed to work with the Microsoft software suite. You can use it to develop application software and simple applications. It is supported by Visual Basic for applications. Access offers a query interface, reports for printing and forms to display data. Lookup fields are efficient when you have information repeated in several tables. It can also prevent typing errors when you're having to enter redundant information. Setting up an auto lookup query in Microsoft Access 2007 requires a few steps.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Open your Access table. Click on the "Template Categories" tab and hit "Northwind Sample Database." Click "Download." Open the "Tables" tab. Click on "Create," and then hit "Table Design."

  2. 2

    Enter "Employee Lookup" within the first row beneath "Field Name." Hit "Lookup Wizard" under the "Data Type" column. Check the box next to the sentence "I want the Lookup Column to Look up the Values in a Table or Query" within the first page of the Lookup Wizard. Hit "Next."

  3. 3

    Hit the "Employees" table beneath the tables list. Hit "Next." Double-click on the "EmployeeID," "LastName" and "FirstName" fields to add them to your list of fields. Hit "Next" twice.

  4. 4

    Check the box next to the "HideKey Column," then click "Next." Hit "Finish" when you arrive at the last page of the wizard.

  5. 5

    Hit "Save" when asked if you wish to save your query. Name your query when prompted. Find your query by clicking on the "Datasheet View" and locating your saved query.

  1. 1

    Open your Access table. Click on the "Template Categories" pane. Hit "Northwind 2007," and then click on "Download." Open your "Tables" tab, click on "Create," and then hit "Table Design." Enter "EmployeeLookup" within the first row of your table under "Field Name."

  2. 2

    Hit "Number" within the "Data Type" column. Hit the "Lookup" tab under "Field Properties." Hit "Combo Box" within the "DisplayControl" list.

  3. 3

    Hit the "RowSource" property box, then click on "Employees," then hit "Build." Double-click on the "EmployeeID," "LastName" and "FirstName" fields. Hit "Close" within the "Close" group under the "Design" tab.

  4. 4

    Hit "Yes" when prompted to save your changes. Set the "BoundColumn" property to 1. Change the "ColumnCount" property to 3. Enter "0";1";1" in the "ColumnWidths" box. Enter 2 within the "ListWidths" box.

  5. 5

    Click on "Datasheet View" and open your table. Click on "Yes" to save your query when asked, and name it. Hit "Yes" when prompted to add a primary key to your table.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.