Finding, checking, and searching records
You can find individual records, or groups of records, for adding to or editing the information in your database or to analyze data for a particular task. There are a number of ways that you can find records, and each is designed for a particular type of inquiry.
Feature | Description |
|---|---|
Find | For locating one or more records of a specific type, such as person entities or phone call links, where you know some fragment of the information that you are seeking. |
Queries | For discovering information about the contents of the database. Queries can be simple or complicated according to your needs. You can save queries for future use and in SQL Server databases, add alert definitions to them to notify you of changes to the records returned by the query. |
Search 360 | For a more flexible type of search across all entity and link types in the database. This type of search allows for variations, for example in spelling and word order. The results are scored depending on how closely the record matches your search criteria. |
If you are working in a Microsoft™ Access database, then you can use these tools in place of Search 360:
Feature | Description |
|---|---|
Word Search | For searching by exact word, by wildcard (basic or complex) or synonym matching, or by Soundex matching. Word Search highlights all found terms in context. You can also browse the index and find words with a high or low frequency of occurrence or by their leading characters. |
Scored matches | Very similar to queries but allow you to rank the results in order of likelihood that the results are exactly what you require. You can save scored matches for future use. |
Matching Records | Allows you to discover if records in the database share common values with a single record that you are interested in. |
Duplicate Records Checker | Allows you to search for records containing duplicate values. This is similar to Matching Records but it allows you to work with a set, a query or even the whole database. |
The results returned by these search methods will depend on whether the database uses cases.