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.

In Microsoft Access, a Query can answer a simple question, merge data from different tables, perform calculations, add, change, and delete data from the database.

Creating a new table from query results can help you build a database of your clients, employees, expenses and other business details by allowing you to select certain columns from existing tables.

That way when you run either they return the same fields.<BR>Once the queries look the same, make a third query that UNIONS the 2 together. That will combine the results from both queries.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

Access apps can also be managed and monitored through a company SharePoint site, allowing multi-user accessibility, with customized permission controls. This Microsoft Access 2013 Cheat Sheet from ...