Create Calculated Fields in Access. Open Microsoft Access. Create a table or an existing table. Create a Query. To create a Query, go to the Create tab and click Query Design in the Queries group.

Select a field and drag it to the tabbed page. 3] Add other controls to the page. In Microsoft Access, there are a variety of controls that you can add to your forms, such as Textbox, Labels ...

Instead of wasting disk space with stored values, you should use calculated fields whenever possible in a database. Simply follow these steps to create your own calculated fields for queries.