Create a query, put the clients and transactions tables on it. Stick the join on (line from clientid in one table to the other).
Make sure only amount is checked in the transactions table and set it to do the sum and perhaps alias the field name.
Don't ask me how to do any of that in access (whatever version you have), I've not a clue). I just know it's in there somewhere...
The sql should look something like
Select Clients.*, Sum(Transactions.Amount) as Total from Clients Inner join Transactions on Clients.ClientID = Transactions.ClientID Group By Clients.ClientID
It probably won't in access, square brackets everywere for starters.
If you want to learn sql, this place is a good start. http://www.w3schools.com/sql
but you'll never learn it with that GUI crap, it's for people who don't want to.
On the rare occasions I'm forced to access, (once my tantrum is over), I usually just go into SQL view and type the stuff in.
Not sure how much support there is in there in current access versions, you might be better off with SQL Server 2008 express as a learning tool, does syntax highlighting, type ahared and stuff.
If you switch from one to the other access will some some things that it won't (let you use form variables and such) and sql server does a heck of a lot that access can't even start on.
Hths and happy learning.