Editing multiple tables at once

[Anilusion]

Hey, I'm pretty new to using access, but in excel there's a feature that lets you group sheets together and edit them all at the same time. I have a file with about 100 sheets in access, and I'm trying to adjust the column width in all of them so that they're all aligned with eachother. Is there a way to group them all together or do I have to edit each and every one manually?

Same goes for editing the design of the sheets. I want all of them to look the same, and if I change one I want to change the others as well.

[RayMilhon]

Based on your statement am I to assume you have 100 tables in access 1 for each spreadsheet? If so, Do a search on database Normalization and re-think your data structure.

[June7]

And no, there is no 'group' behavior for tables.

Review the 'sticky' thread tutorials at http://forums.aspfree.com/microsoft-access-help-18/

[Anilusion]

This is the first time I'm using access and I imported all of my data from excel. I'm need step by step instructions on how to go about doing stuff.

This is how it looks right now: http://i.imgur.com/Ml3c3.jpg

What I'm trying to do is to make is to that the column width is the same in all sheets. Right now they are all different because it's auto adjusting them.

[June7]

Access Help has guidelines for basics and there are lots of tutorials on web. Get an introductory book that will take you through some basic exercises.

First thing you need to do is understand the difference between Excel and Access. Then understand relational database concepts. Then learn Access interface. Then learn programming.

The link I provided is a good start.