How to Use Microsoft Access Expression Builder


Microsoft Access is a very easy to use Database management program. It also contains several reporting features and in this tutorial we will explore one of its reporting features using access expression builder.

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

Employee Data

Step 2 – Form Wizard

For that we have to create a new form by clicking More Forms and then clicking on Form Wizard

Working on Forms

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.

Adding Fields

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.

Finishing Form Design Wizard

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.

Property Window

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.

Expression Writing

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.

The Final Form View

This is how we can use Microsoft access expressions.