How to Create Formulas in Access 2007

Save

Microsoft Access 2007 is a database program that you can use to store, compare and manipulate data. Some versions of the Microsoft Office 2007 productivity suite include this program and it can work in conjunction with other Office programs. One particularly useful feature of Access 2007 is your ability to use formulas, or expressions, for a variety of operations. You can apply these formulas to any number of fields or records held within the database to achieve the results you desire.

  • Navigate to the location of your Access database and double-click on the file to open it in Access.

  • Right-click on any form listed in the "All Tables" column on the left-hand side of the screen.

  • Click the "Design View" option.

  • Right-click in the text box where you wish to add the formula, and click the "Properties" option. This will open a new column on the right-hand side of the screen called "Property Sheet."

  • Click the "Data" tab at the top of the "Property Sheet" column, and click in the "Control Source" field.

  • Type the formula that you would like to perform. For example, if you wanted to total up all of the values for a particular field, you would type "=Sum([xxxxxx])," where "xxxxxx" would be the name of the field containing the values you wish to total.

Tips & Warnings

  • You can use Access formulas for a variety of purposes, including performing a calculation, retrieving a value or supplying the criteria for a custom query. Formulas provide you with a high level of customization in your Access databases.
  • Click the "Create" tab at the top of the screen and click the "Form" button to create a new form within your database.
  • In order to create formulas, you need an Access 2007 database with at least one form.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!