Forum home » Delegate support and help forum » Microsoft Access Training and help » access vba courses in london - Numbers of fields/tables
|
|
|
The UK's most regular 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 vba courses in london - Numbers of fields/tables
Resolved · Low Priority · Version Standard
Reply Mon 26 Nov 2007, 08:25Delegate Jo said...
Jo has attended:
Access Introduction course
Numbers of fields/tables
Is there a maximum number of fields you would recommend for a table or maximum number of tables for a database?
Thanks
Jo
For upcoming training course dates see: Pricing & availability
RE: Numbers of fields/tables
Hi Jo
Thanks for your question about Microsoft Access tables and fields.
The maximum number of fields that you can have in an Access table is 255.
Regarding the number of tables you can have in a database, Ms Access has a maximum of 32,768 OBJECTS that can be in any one database. You can divide that number into tables, queries, forms, reports.
If you have any further questions about Access, please post your questions to the forum.
Regards
Richard
Microsoft Office Specialist
|