Tag Archives: calculating queries

Microsoft Access Databases – Learning the Fundamentals

The Access database application provides a rich set of powerful tools ranging from a simple database design model to the multi-user network version using Access’s administrative tools at all levels which include the Relationship Window, Database Splitter, Linked Manager Tool … Continue reading

Posted in Database Theory, Forms, Macros, MS Access, Queries, Reports, Tables, Utilities | Tagged , , , , , , , , , | 23 Comments

Microsoft Access Query Formulas Combining Fields, Calculation

Queries are the heart of any Access database and this query is typically utilised especially when wanting to calculate. A common type of calculation is known as ‘Concatenate’ which is demonstrated here with the ‘FirstName’ and ‘LastName’ fields. Also, this … Continue reading

Posted in MS Access, Queries, Utilities | Tagged , , , , , , , , | 3 Comments