Did you know that you could calculate fields in the query in Microsoft Access ... calculated field, a colon, and the calculations in one of the columns in the Field row of the query’s design ...

Launch a Microsoft Access file. Click the View button in the View group and select Design View from the drop-down menu. On the Design View interface, we want to add a new field below the Telephone ...