What determines a table’s sort order? - ProProfs Discuss
Topics-
Products +
     

What determines a table’s sort order?

What determines a table’s sort order?

Change Image    Delete



A. AutoNumber field
B. Index field
C. Field order
D. Primary key

This question is part of MS Access - Final Exam
Asked by Michael_laguisma, Last updated: Nov 27, 2018

+ AnswerRequest Answer
...

4 Answers

John Smith

John Smith

Answered on Apr 13, 2017

Index field
1
 Reply

John Adney

John Adney

Replied on Sep 04, 2017

AutoNumber field

Lemmy Paradisiacal

Lemmy Paradisiacal

Answered on Mar 21, 2019

Plz help.. cz am not sure about my ans.

 Reply

C. Bernthal

Its kind of my job to give answers

C. BernthalTeacher, MA, P.hD, Seattle
Teacher, MA, P.hD, Seattle

Answered on Nov 27, 2018

In this example, you can see that the entry date is not in date order. Neither are the entries in columns C, D and E. By contrast, the Income column is determining the order. It goes from low to highest. This is the index field. It may be that another determinant could be chosen for the Index field, such as number sold. The essence is that the index field is the area of interest; i.e. what the data output is to show.

 Reply

John Adney

John Adney

Answered on May 04, 2017

Autonumber field only helps with the order in which they were created. Helps determine if something was deleted and how many records you have. However,the order of columns in a multi-column index definitely matters. One type of query may need a certain column order for the index. If you have several types of queries, you might need several indexes to help them, with columns in different orders.
 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.