One way would be to create a Form for each Table, then place one Subform, based on each of these Forms, on a different Page of the Tabbed Control.
There may very well be other approaches, but you've given us almost no information on what you're trying to do, here, what relationships you have between Tables and so forth.
If you have, for instance, a One-to-Many Relationship between Tables, you might do better using a Main Form/Subform scenario, with the 'One' side displayed on the Main Form and the 'Many' side displayed in the Subform.
More details on your part will allow us to offer you more/better options.
Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007