how to create access database in alphabetical order?

Question

I am creating a contact database in microsoft access.. how do i arrange them in alphabetical order??I am using this template by microsoft
http://office.microsoft.com/en-us/templates/TC010178391033.aspx?CategoryID=CT011366681033

thanks

Answer 1

In a table: in Spreadsheet view, select the column you wish to sort by and click the Sort (Ascending) or Sort (Descending) icon on the toolbar.

If you are creating a query: in Design view, click in the Sort column of the field you wish to sort by. A down arrow will be displayed in this box--click this down arrow and choose ascending or descending.

Answer 2

database store information in the most economical format possible. so when it returns data, it has a tendency to look random.

in access as well as other databases, you can ask for the data to be presented to you in a particular order, but you have to specfy which column

search order by in the help program

Answer 3

If I'm not mistaken Access keeps them in the order entered.

If you want them in alphabetical order you will have to enter them in that way.

You could try to filter the results when pulling the list together.

Answer 4

Its not so much important how the data is stored as how it is retrieved. To get the data back in alphabetical order just add "ORDER BY lastName" to the query that gets your information.

Answer 5

You may use the access query tool "Advanced Access Builder" at http://www.download5000.com/page25449.aspx or http://www.dlkj.net/sqlBuilder , it allows you to visually build complete SQL scripts.