What I have is in the colum -fields- is the information we take from the client, demographics and their information related to our business. As each new client comes in to use our services, a new entry is created,-the rows. I had though of creating several tables, but as the need to acquire information grew so did the fields. I had imported an excel sheet with about 50 entries, but now the things has over 300 entries. in order to created addidtional related tables, would there be a easier safer way then to do it all from scratch and pick and choose what goes on to what table?
John W. Vinson wrote:
Re: Creating many forms from one table - Newbie
06-Oct-09
A good spreadsheet design is often a very bad table design (and vice versa).
Access is emphatically NOT "Excel on steroids"!
A Table with thirty fields is an extremely wide table, and a table with a
hundred fields is TOO wide (for anything but a deliberately denormalized data
archive).
You would do MUCH better to construct a set of two, three or more properly
normalized and related tables, and use Append queries to migrate the data from
this unwieldy monster into them. If you have "columns" - fields - with names
like January, February, March; or Sale1, Sale2, Sale3... these need to be
moved from fields in this table into rows in a related table.
That said... you can create a Form with a Tab Control, and put one batch of
textboxes or other controls on each of several pages of the tab control. This
will keep all the data for one record together more easily than several
unrelated forms will.
--
John W. Vinson [MVP]
Previous Posts In This Thread:
Creating many forms from one table - Newbie
I am curious if there is any conflict in creating multiple forms from one table? I have imported from excel one worksheet with a slew of fields and its corresponding data in the columns. when I imported this to access 2007, I allowed access 2007 to create the key and now each row has its key.
Would there be any problems (opertating wise) in creating multiple forms from one table using distinct fields from the table and not repeating?
David N
EggHeadCafe - Software Developer Portal of Choice
...NET System.IO Read And Write Files Compared To Scripting.FileSystemObject
http://www.eggheadcafe.com/tutorial...512-462b2a15a09b/net-systemio-read-and-w.aspx
Re: Creating many forms from one table - Newbie
A good spreadsheet design is often a very bad table design (and vice versa).
Access is emphatically NOT "Excel on steroids"!
A Table with thirty fields is an extremely wide table, and a table with a
hundred fields is TOO wide (for anything but a deliberately denormalized data
archive).
You would do MUCH better to construct a set of two, three or more properly
normalized and related tables, and use Append queries to migrate the data from
this unwieldy monster into them. If you have "columns" - fields - with names
like January, February, March; or Sale1, Sale2, Sale3... these need to be
moved from fields in this table into rows in a related table.
That said... you can create a Form with a Tab Control, and put one batch of
textboxes or other controls on each of several pages of the tab control. This
will keep all the data for one record together more easily than several
unrelated forms will.
--
John W. Vinson [MVP]
Creating many forms from one table
I guess then I would have to create several table for this action. But now that I have one table and many forms, with data in this now, what would be the easier way to go with various tables and relate it to the forms I now have???
Creating many forms from one table - Newbie - John W. Vinson
What I have is in the colum -fields- is the information we take from the client, demographics and their information related to our business. As each new client comes in to use our services, a new entry is created,-the rows. I had though of creating several tables, but as the need to acquire information grew so did the fields. I had imported an excel sheet with about 50 entries, but now the things has over 300 entries. in order to created addidtional related tables, would there be a easier safer way then to do it all from scratch and pick and choose what goes on to what table?
EggHeadCafe - Software Developer Portal of Choice
SQL Server / .NET Database Driven Permissions
http://www.eggheadcafe.com/tutorial...e49-c6bd4aee5f5f/sql-server--net-databas.aspx