Key Points

  • Microsoft Office Access 2007 provides a variety of tools you can use to organize the display of information in a database and to locate specific items of information. These tools make it easy to search through and find information in your database, even as it grows in size and complexity.

  • You can sort a table in either ascending or descending order, based on the values in any field (or combination of fields). In Access, numbers can be treated as text or numerals.

  • You can filter a table so that information containing some combination of characters is displayed (or excluded from the display). You can apply simple filters while viewing information in a table or a form. These filters are applied to the contents of a selected field, but you ...

Get 2007 Microsoft® Office System Step by Step, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.