access vba courses in london - Numbers of fields/tables

Resolved · Low Priority · Version Standard

Mon 26 Nov 2007, 08:25 Delegate 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

Mon 26 Nov 2007, 09:37 Trainer Richard said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips