New Access Query

• 1). Click "Create" on the ribbon to create a new query. Choose "Query Wizard." Select "Simple Query Wizard." Click "OK."
  
  
• 2). Select the table your field name is stored in from the drop-down box.
  
  
• 3). Select your field name from the "Available Fields:" box. Click ">" to add the field to your table. Click "Finish."
  
  

Existing Access Query

• 1). Right-click your existing query. Select "Design View" from the list of options.
  
  
• 2). Click the "Field" row in the next blank column in the design grid. Choose your field from the drop-down list.
  
  
• 3). Click "Run" on the top ribbon. This selects the field name from the table and places it in the query.
  
  

Create Access Macro

• 1). Click "Create" on the top ribbon to create a new macro. Click the drop-down box to "Add New Action." Select an action from the list. The "Action Catalog" on the right shows macros available. The "Filter/Query/Search" header shows commands that deal with specific records and table fields.
  
  
• 2). Complete the argument boxes that appear for the macro. For each macro, Access provides boxes that need to be completed to make the macro run. This information changes with each macro command. For example, the "FindRecord" action needs your field name and search criteria.
  
  
• 3). Click "Run" on the top ribbon under the "Design" tab. Access prompts you to save the macro. Name the macro and click "OK."