Microsoft Office Questions? Ask a IT Expert for Support ASAP
The limit for fields is 255 in each table. If you have alot of fields or redundant data, then it's best to split the data into different tables so it makes sense to you when looking up the data. If one table seems to suit you, then that's fine. It's when your database gets 1000+ records and gets more complicated when you want to use the multiple tables linked 1 to 1 with client identity.