How to Create Buttons in Microsoft Access 2007

Written by m. alanna white
  • Share
  • Tweet
  • Share
  • Email

Buttons created for Microsoft Access 2007 serve an important purpose in database design. Access buttons, often referred to as command buttons or controls, allow users to navigate, save, accept data, cancel actions and exit the database. The forms, reports, and data access tables you designed for your database are referred to as objects. Once created and added to the database object, these buttons allow the user to perform these various operations. If you are a beginner or are unfamiliar with the process of creating buttons to add to your database objects, use the Control Wizard.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Open Microsoft Access 2007 and allow it to completely load on your screen. Open your database. Select "Open" on the File Menu. Select the name of your database in the populated list in Documents. Select "Open."

  2. 2

    Select the report, form or data access page for which you will add buttons to open the file. Select "Design" on the database dialogue box to show Design View.

  3. 3

    Open the toolbox. Select "Customize" on the Tools Menu. Scroll down and select "Toolbox" check box on the Customize dialogue box. Select "Close." Select the "Control Wizard" on the Toolbox located next to the "Select Objects" button (the Control Wizard button displayed a box surrounding it, once selected).

  4. 4

    Select the "Command Button" tool located in the toolbox. Click the location on your object (i.e. form, report, access page) for the location where your button will be displayed. The Control Wizard will now display.

  5. 5

    Choose the category for your button--for example "Record Navigation"--and then select the action to be performed when your button is selected. Action choices for "Record Navigation" include "Find Next." Find Next will tell the database to locate the next record when the button is pressed. Once you have made these selections, select "Next."

  6. 6

    Select between the text and picture option for your button. For example, if you chose "Find Next" as the button's action in Step 5, selecting text will display "Find Next" on this button. If you choose "Picture," the button will contain a picture instead of text. You can use any picture stored on your computer for the picture option. Select "Browse" and Access will display the Pictures dialogue box. Select the picture from the list, and select "Insert." Once you've made this decision, select "Next."

  7. 7

    Enter a name for this button, then select "Finish." Select "Save" in the File Menu to save these changes. Repeat Steps 4 through 7 for each button to be added to this object.

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.