eHow launches Android app: Get the best of eHow on the go.

How To

How to Create a Form in MS Access

Contributor
By eHow Contributing Writer
(1 Ratings)

Forms are used by MS Access to edit, enter or display data that is contained in underlying tables or queries, and are an excellent way to let end-users (who are not familiar with programming or databases) input and interact with complex data. Microsoft Access provides several form creation tools, but the easiest one to use will create a form for you with only one click. The key to success is knowing how to set up your data before you start creating forms.

Difficulty: Moderate
Instructions
  1. Step 1

    Open an existing MS Access database and check to see if the table or query you want to build a form for already exists. If you do not have a table or query in place to hold your data, you must create them prior to building your form.

  2. Step 2
     

    Confirm your data. After you have confirmed that your data exists in either table or query format, open up the table or query and then click on the "Create" tab located at the top of the MS Access toolbar.

  3. Step 3
     

    Click once on the "Form" button to have MS Access create your form for you.

  4. Step 4

    Click and drag on the form to adjust the size of the entire form, individual fields inside of the form, or even rename the field names themselves by double-clicking on the existing names and typing over them with your new name.

  5. Step 5
     

    Locate the key to using your newly created form. It is efficiently located at the lower left corner of the form page. You will see the word "Record:" followed by a series of arrows and numbers in the format "1 of 2." The numbers tell you which record you are currently viewing and you can move from record to record by clicking on the arrows without lines. The small arrow with a line on the left side will always take you to record number one with just one click. The small arrow with a line on the right side will always take you to the last record with just one click. To add a new record, just click on the small arrow with a yellow starburst next to it--this tells the form to add a new blank record so you can start typing the data into the fields. There is also a search box that helps you quickly locate one piece of data from among thousands of different records.

Tips & Warnings
  • Forms should always be created for your tables and queries when you need to have a person who is not a database expert work with large amounts of data. The forms can be restricted so that only certain public fields appear and the underlying data cannot be changed by accident by an inexperienced user.
Subscribe

Post a Comment

Post a Comment

Related Ads

  • Have you done this? Click here to let us know.
I Did This
Get Free Computers Newsletters

Copyright © 1999-2010 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy .   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License. † requires javascript

eHow Computers
eHow_eHow Technology and Electronics