access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

resolvedResolved · Low Priority · Version 2003

Simon has attended:
Access Intermediate course
Access Advanced course

Access

how many non-data fields can we use within a table? i.e. word limit to text box.

RE: Access

Hello Simon,

Hope you enjoyed your Microsoft Access courses with BEST STL Training.

Thank you for your question regarding data fields.

You can have upto 255 fields of data in a table.

Within each field you can customise the properties.
A standard text field can only contain upto 255 characters. A memo field can contain upto 16000 or so characters.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.
Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer


 

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips


Server loaded in 0.08 secs.