What determines a table’s sort order? - ProProfs Discuss
Topics
Products
Follow Us:

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 NOEL, Last updated: Feb 14, 2020

+ Answer
Request

4 Answers

John Smith

John Smith

Answered Apr 13, 2017

Index field
1
 1

John Adney

John Adney

Replied on Sep 04, 2017

AutoNumber field

NOEL

NOEL

Answered Nov 22, 2019

Index field determines a table's sort order


 

C. Bernthal

Its kind of my job to give answers

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

Answered 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.

 

John Adney

John Adney

Answered 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.
 

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.