Sorting

[Guest]

I am very new to access. I am viewing data in a table. I would like to know
how do you sort the data? Unlike Excel it doesn't allow you to choose a
column to sort by. Please help. Thanks~

 

[Guest]

Tables are there just to hold your data. If you need to do any sorting etc.
you use queries.

 

[Joan Wild]

Use a query instead. You can sort on multiple columns.

Open a new query and add your table. Add the fields you want displayed and choose a sort order in the query grid.

 

[Guest]

How do I go about using the query? I just don't know where to begin.
Currently I have the table up. Where do I go from here?

 

[J]

Wooooooow welcome to Access. We're used to tougher questions that
that.

You can close your table. A table stores data and it's already
stored.
A query is a set of instructions for reading the table. A table could
have columns "A", "B" and "C"... but you could tell a query "Show me
column A and B only, sorted by column B"

Now what version of Access are you using? 2007? 2003? 2002?
In 2007 go to the "Create Tab" choose "Query Wizard" and go from
there. It's probably not much different in 2003. You really should
dig around yourself. You'll be surprised how easy it gets over time.

Best of luck,
~J

PS. After tables and queries, forms are the next big thing in Access.
A form usually lets you view a single row at a time, so you can add a
new row, edit an old row, or whatever.