Indexes Tool

M

myxmaster

Can you please tell me how to access this function? I am using access
2003.
TIA
 
M

Matt

Can you please tell me how to access this function? I am using access
2003.
TIA
Click to expand...

In the design view of the table there is section for it at the bottom
(in the area where you set formats, validation rules, etc).

The options are:
No - This field will not be indexed.
Yes (Duplicates Ok) - This will be the option used the most
frequently. It will allow the column to have non unique values.
Yes (No Duplicates) - Used for the primary key (and I am sure some
other randomfields). Each record must have a unique value in this
field.
 
M

myxmaster

In the design view of the table there is section for it at the bottom
(in the area where you set formats, validation rules, etc).

The options are:
No - This field will not be indexed.
Yes (Duplicates Ok) - This will be the option used the most
frequently. It will allow the column to have non unique values.
Yes (No Duplicates) - Used for the primary key (and I am sure some
other randomfields). Each record must have a unique value in this
field.
Click to expand...

Does this apply to the following advise?
Use the Indexes tool; type a distinctive name in the left column
(UniqueCategory say). Select the Account field in the right column
next to the
name, and the Category field in the next row down:

UniqueCategory Account
Category


Check the Unique Values checkbox and save the index, and you'll only
be able
to insert one record for each account-category pair.

TIA
 
J

John W. Vinson

Can you please tell me how to access this function? I am using access
2003.
Click to expand...

Open the table in design view. It's the 13th tool in the standard table design
toolbar - looks like a stack of horizontal rows getting hit by a lightning
bolt.

John W. Vinson [MVP]
 
A

Aaron Kempf

CORRECTION!

you just should be usnig Access Data Projects, SQL Profiler and either
'Index Tuning Wizard' or 'Database Tuning Advisor'
 
Top