Microsoft Office Tutorials and References
In Depth Information
AC 192
Access Chapter 3 Maintaining a Database
Ordering Records
Normally, Access sequences the records in the Client table by client number whenever listing
them because the Client Number fi eld is the primary key. You can change this order, if desired.
To Use the Ascending Button to Order Records
To change the order in which records appear, use the Ascending or Descending buttons. Either button
reorders the records based on the fi eld in which the insertion point is located.
The following steps order the records by city using the Ascending button.
Open the Client
table in Datasheet
view and hide the
Navigation pane.
Home tab
Click the City fi eld
on the fi rst record
to select the fi eld
(Figure 3–76).
Did I have to click
the fi eld on the
fi rst record?
No. Any other record
would have worked
as well.
City fi eld on fi rst
record selected
Figure 3–76
Click the Ascending
button on the Home
tab to sort the records
by City (Figure 3–77).
Ascending button
records sorted
alphabetically by city
What if I wanted the
cities to appear in
reverse alphabetical
Click the Descending
Figure 3–77
Sort the records by city in
reverse order. When done, sort the records by city in the original order.
Close the table. When asked if you want to save your changes, click the No button.
Other Ways
1. Right-click fi eld name,
click Sort A to Z (for
ascending) or Sort Z to
A (for descending)
Special Database Operations
The special operations involved in maintaining a database are backup, recovery, compacting
a database, and repairing a database.
Search JabSto ::

Custom Search