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.

How to create Calculated Fields in Query in Microsoft Access ShantelAnderson@TWC Shantel has studied Data Operations, Records Management, and Computer Information Systems.

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.