answersLogoWhite

0


Best Answer

Access automatically creates an index for the primary key field in a table. In addition, Access automatically creates an index for any field name that contains the following letter sequences: code, ID, key, or num.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Does Access automatically creates and maintains an index for a table's primary key?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

When Access first creates a database it automatically creates a table.?

Yes it does. However the table is blank and the user must then start to create the fields they want. So Access really only starts the process of creating a table and the user must do the rest.


When you create a table in datasheet view access automatically adds which field as the first field in the table?

The primary key.


To delete the id field that access creates automatically for new table the table must appear in layout view rather than datasheet view?

the answer is false.


Define sessions in aspnet?

ASP.NET automatically creates a session for each unique browser connection to your application. You can access the session through the Session[] collection in any System.Web.UI.Page object.


What type of integrity is enforced when a primary key is declared?

By default a primary key is also a unique constraint, that means only one row can contain a specific value for this key (or no duplicates are allowed). Also an index is automatically created for a primary key allowing efficient access.


What is one of the primary roles of a DBA?

database administrator will monitor the database size and creates users ,grant privilages to the users .His job is to give the access permission to the right person not the oponent.He maintains the tablespaces size and increase the size of it when it requires.Daily he must take the backup of the data and if any problem occurs in the database he must in a position to recover the data.


Is the Values in an AutoNumber field automatically created by Access?

true


What is filename.mdb in computers?

It is the databases that Access creates. It stands for Microsoft DataBase.


What is a unique identifier in Access?

Primary key


Does a war veteran automatically have access to wall of memories on their death?

We aren't sure what memories any of us have access to after our death.


When does Access automatically assigns either a sequential or random numbering field?

AutoNumber


What is Supper key in MS Access?

primary key