How to Use Microsoft Access Expression Builder

In this video tutorial we will explore one of its reporting features using access expression builder. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Microsoft Access is a very easy to use Database management program. It also contains several reporting features. Follow this easy step by step tutorial to learn how to use Microsoft access expressions builder and see how to work on forms. Step 1 - Employee Table Consider an employee table containing the employee ID, Employee Name, Wages, Hours Worked and Payroll. Notice here that the payroll column is empty. So we will calculate the payroll using expression builder. Step 2 - Form Wizard For that we have to create a new form by clicking More Forms and then clicking on Form Wizard. Step 3 - Selecting the Fields Then we have to select the entries we want in the form like ID, Employee Name and Payroll. After that click next until we land to last page. Step 4 - Finalizing the Form Designing Wizard On the last page we have to choose the second option which would be "Modify the Form's Design" and select Finish. Step 5 - Property Sheet After that we would be taken to Form Design page. On the property sheet click on Control Source and then click on the Three Dots button. Step 6 - Writing Expression With that done, access expression builder window will open up. Start writing an expression with equal to sign then click on tables, and then double click on wages. Click on multiply operator and then click on hours worked. This is how the expressions are written. After that click Ok and then save the form pressing Ctrl+S. Step 7 - Observing Form View And now if we open the Form view, we can see the payroll automatically calculated from wages and hours worked. This is how we can use Microsoft access expressions.