I believe you need a starter book about Access or at least a tutorial site about the subject.
but to add code to a button control you can right click on it and choose build event option. to show multiple tables you have 2 options depends on your needs.
#1. you can create a query that compiles the data from multiple tables or
#2. you can use subforms.