Similar filters are available
for numeric and text data, as well.
FIGURE C-5
Datasheet view supports a number of powerful filtering and sorting options.
1283
What??™s New in Access 2007 C
You can also click on the field name itself and get additional sort-and-filter options based on the
field content. Figure C-6 shows a few of the filtering options for text data.
Along with filtering, you can now get totals for a column right from Datasheet view. These totals
will also apply as you filter down through the records??”very cool! Figure C-7 shows the Totals
row added to the bottom of a datasheet. Notice that the Totals row appears below the data contained
within the datasheet, and does not interfere with the datasheet??™s data.
Fields can easily be added from Datasheet view and there is now a Field Template pane from which
you can choose a field complete with name, data type, length, and prepopulated properties. You
can also set up your own field templates and standard definitions to share with a workgroup or
department.
Pages:
2307
2308
2309
2310
2311
2312
2313
2314
2315
2316
2317
2318
2319
2320
2321
2322
2323
2324
2325
2326
2327
2328
2329
2330
2331