Did you know that you could calculate fields in the query in Microsoft Access? If the user wants a calculated field in a query, the user needs to input a name for the calculated field, a colon ...

The Query Design: Create a new blank query in Design View ... the tables must be connected (see article about relationships). Below the field row is the Table row. Select your desired table.