RE: Access Database

Dear Nicola

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.


It depends on what you are planning to calculate. I'll give you an example.

Let's say that you have an Orders Table which has fields such as Unit Price and the Qty Sold

You wish to perform calculation which will multiply the Unit price with the Qty Sold field. You would have to follow these steps:

1. You would create a Query from design view.

2. Choose the Orders table from Show table window. Close the Show Table window.

3. Show the relevant field that you wish to see in the result view of the query.

4. On the grid you would click on the blank column next to the last field that you have in the grid box.

5. You would type the following:

Sales: [Unit Price]*[Qty Sold]

Sales is the name of the new filed that will appear in the other view

: (Colon) is required to separate the filed heading from the actual calculation that you are performing.

[ ] (Square brackets) are needed before and after the field headings to ensure that Access recognises that these are field headings.

6. When you run the query you would see that the new field that will provide you the relevant result.

I can see from the records that you are booked for Access Intermediate course on 12 March 2009 (which happens to be my birthday :)
You will be covering calculated fields in Queries, Forms and Reports.

Please refer to the following link to see the other topics that will be covered on tat day as well as the schedule for the future Access Intermediate and Advanced courses for if any one else is interested in doing the Access intermediate or advanced course:

http://www.microsofttraining.net/access-courses-in-london-2003-intermediate.php

http://www.microsofttraining.net/advanced-microsoft-access-in-london-2003.php

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT