Forum home » Delegate support and help forum » Microsoft Access Training and help » Indexing
|
|
|
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. |
Indexing
Resolved · Low Priority · Version 2003
Reply Thu 12 Mar 2009, 15:54Delegate Anne said...
Anne has attended:
Access Intermediate course
Access Advanced course
Indexing
As indexing is about saving time when querying - does Access ssign a number to a value? If so where is that number stored?
For upcoming training course dates see: Pricing & availability
RE: Indexing
Dear Anne
Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.
Please refer to the link which provides you a bit of information on Indexes in MS Access.
http://www.tek-tips.com/faqs.cfm?fid=1752
Is there a specific reason why you want to know where the index values arte stored?
If you simply want to know which fields the indexes have been applied to then you have to go to the design view of the table and click on the Indexes button next to the primary key button.
Please remember that Primary key is automatically indexed by default.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
Tue 24 Mar 2009: Automatically marked as resolved.
|