Posts Tagged 'Queries'

How to Create Queries Referring Multiple Tables in MS Access

Let’s learn the ways to create Queries in MS Access that can refer to multiple tables.  Queries for single table are very common in Microsoft Access but sometimes there are cases when we are required to make queries that can refer to multiple Tables. Users often face the requirement of data that is present in more than one table. Fortunately, Microsoft Access provides the feature of creating multi-level query. Users can create a query that can combine data and information from multiple...

Read more »

Why One Should Use Queries instead of Calculated Fields for Access Tables

The article explains why the users should avoid using calculated fields in the database and instead use Queries. MS Access allows its users to create calculated columns (field type) in the table design to perform various calculations, but more often it breaks the rules of normalization. It is therefore recommended to use Queries instead of calculated fields. This article will elaborate this point in detail. Calculated Fields in MS Access Calculated fields are integral part of the...

Read more »