98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Fields
microsoft access training - Fields
Resolved · Low Priority · Version Standard
Tue 3 Jul 2007, 17:24Delegate Edmund said...
Edmund has attended:
Access Introduction course
Access Intermediate course
Fields
How do i add more fields. i have a database that has currently 200 fields. I keep getting error message that maximum fields reached. How do I get more fileds, is approximately 200 the maximum fields allowed. thanks
Wed 4 Jul 2007, 12:42
Edited on Wed 4 Jul 2007, 12:42Trainer David said...
RE: fields
Hi Edmund
200 fields is a lot.
If you just have 1 table with 200 fields I would suggest that you break that table down into lots of smaller tables. The purpose of Ms access is to allow you to have lots of tables that hold similar information, these tables are linked together using primary and foreign keys. You can then run reports and queries to extract data.
Hope this helps
David
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Deleting duplicate records from a tableYou cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table. |
