Access 2003 (table relation)

Dear Anita

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

You are right. This is something to do with Relationships between tables. We cover this in detail in Intermediate level.

If you know how the relationship work in Access you can very easily insert something known as Subdatasheets. If you are not familiar with relationships between the tables then I recommend that you enrol in one of our Intermediate courses.

Please find the below link to see the schedule of the intermediate course:

https://www.stl-training.co.uk/microsoft-access-course-london-2000-intermediate.php

It is important to understand that Access is not there for lots of calculations and functions!! If you feel that you need to do lots of calculations then my recommendation will be to use Excel. If you have got most of teh data in Access and you wish to transfer it in Excel so that you can perform the financial functions then please follow these steps:

1. Open the Table or Query in Datasheet view
2. Choose Tools > Office Links > MS Excel

This will extract your table into Excel and you can perform all your excel functions.

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