If you have new staff, students or volunteers who may need to search or add records to your databases, it is a good idea to have guidelines on data entry protocols, and some instructions on how to search effectively. However printed documents are often lost or not readily accessible, so we recommend adding notes and hints to the DB/TextWorks forms themselves. These can be as brief or as lengthy as you need – we have designed some forms for clients with incredibly detailed instructions.

The databases in all our DB/TextWorks kits feature query screens with searching hints in a text box at the bottom:

We also often add brief instructions in a text box right next to each field on data entry screens. We indicate in the label formatting whether a field is required (red) or has a validation list (underlined).

In the screenshot below we have also divided a long data entry screen up into sections with black textboxes, and resized boxes to indicate the length of a typical entry.

The DB/TextWorks Form Designer is a drag and drop WYSIWYG interface so quite easy to learn. If in doubt use Save As to make a copy of an existing form while you experiment.

When adding either a form or a text box, parameters such as size, label position and font are inherited from the box above of the same type. You can also click on a box, and right click to copy and then paste to create multiple matching boxes for your hints.

These simple conventions and the addition of hints can make the search and data entry experience much easier for your new or irregular users! We still occasionally find clients just using the basic forms – taking advantage of these design capabilities can dramatically improve the usability of your database.

We can of course help you!  Contact us if you’d like any training or assistance with designing any DB/TextWorks screens.

Patient health education materials are an important resource for both caregivers and patients, allowing health care providers to provide important information to patients for their ongoing care in a written format. This may include printed pamphlets handed out at the conclusion of a hospital visit, emergency department discharge instructions, and electronic resources patients can access from home during their recovery.

Like many health authorities, Vancouver Coastal Health (VCH) and Providence Health Care (PHC) manage databases of such materials, and each has recently upgraded the website used to provide access to these resources for staff and the public. Using our Andornot Discovery Interface, two modern, accessible and mobile-friendly search engine sites were built, one for VCH and one for PHC:

• https://vch.eduhealth.ca
• https://phc.eduhealth.ca

Staff and patients may search by keyword or select a health topic from the home page, then narrow their results by topic, format and critically, language, as many resources are available in multiple-language translations.

Spelling corrections, search suggestions and relevancy-ranked results also help connect a user with a resource quickly and accurately, and a synonym list helps connect different terms for a condition to the same resources. For example, a search for blood clots returns the same results as a search for coagulation, and vice versa, allowing different terms to be used to find all relevant resources.

When viewing a record, those available translations are shown so a user can quickly select the best version for their needs.

Many records provide the PDF online for patients and staff to access, but staff may also use these systems to monitor resources which are under review, or to request that a review be initiated or obtain other information about the resource.

A table view of search results is available for rapid scanning of resources, primarily for health care staff already familiar with the resources who only need quick access to the relevant PDF.

Behind the scenes, a DB/TextWorks database shared by both VCH and PHC is used to catalogue and manage the resources.

The two sites are hosted by Andornot, along with the DB/TextWorks software and database, as part of our managed hosting service.

Andornot works with health authorities throughout British Columbia and across Canada to provide information management solutions for other patient health resources and health care libraries.

British Columbia is recognized as a global leader in sustainable forest management and British Columbia’s wood product suppliers offer a wide range of high-quality wood in both construction and appearance grades. Over 400 manufacturers in B.C. deliver a variety of commodity and specialized wood products – from dimensional lumber, engineered, mass timber and speciality products, to furniture, doors and windows, pulp, paper and pellets.

A searchable directory of these suppliers is available at https://suppliers.naturallywood.com to connect buyers, especially from outside B.C., with suppliers and their products.

Users may search and browse by product, species and value-added service to find companies that meet their needs. The site is powered by our Andornot Discovery Interface.

A curated synonym list ensures that users can enter terms they are familiar with, or acronyms, and find relevant resources described using different terms. For example, a search for clt finds resources described with that acronym, as well as the fuller term cross laminated timber, and variations such as xlam, x-lam, and cross-lam, without a user having to think of each of these terms and use Boolean logic to combine them, or search each separately.

Spelling corrections, search suggestions and relevancy-ranked results speed the search process, with the ability to further limit results by product, species, service, export markets and sustainability certifications held by suppliers.

Behind the scenes, a DB/TextWorks database and one of Andornot's Starter Kits is used to manage the supplier information. The B.C. Wood Supplier Database is a project of Forestry Innovation Investment, a publicly owned, funded and operated company of the province of British Columbia. It was set up by the government to promote BC wood products, educate on provincial forest practices, and provide research around sustainable forest management, life cycle analysis and the benefits of using wood products.

This forestry resource complements two other Andornot Projects:

1. The ThinkWood Research Library (also offered by Forestry Innovation Investment); and
2. The FPInnovations’ Research Library.

The Widener University Archives collects, preserves, and provides access to print and digital materials such as papers, photographs, publications, audiovisual items and memorabilia related to the history of Widener University, in Pennsylvania, and its predecessor institutions.

A separate, more specific archive, the Sexuality Archives, contains the pamphlets, papers, newsletters, books, journals and audiovisual materials related to the history of Sexuality, Sexology and Sexuality Education as well as Widener's Human Sexuality program.

Both of these collections are now searchable online using Andornot's Discovery Interface at

• https://widenerarchives.org
• https://widenersexualityarchives.org

With a graphic design that matches the university's branding, and features such as spelling corrections, relevancy-ranked results, and facets such as Subject, Name, and Decade to narrow results, these sites help researchers quickly locate materials of interest.

Andornot worked with archives staff to upgrade their older DB/TextWorks databases to use our Archives Starter Kit, create new databases from Excel spreadsheets, and clean up some of the data, before developing the new web search interfaces and retiring previous ones. Both web search engines are hosted by Andornot.

The Arcadia Public Library's history collection supports the library's mission to collect and preserve materials relating to the cultural and intellectual heritage of the City of Arcadia, California.

Significant holdings include photographs from the Arcadia Tournament of Roses and Santa Anita Assembly Center for the Japanese, U.S. Army Balloon School papers, and a collection of books written by Arcadia authors. Other items focus on Elias DJ. "Lucky" Baldwin, Los Angeles County Arboretum, and Santa Anita Park Racetrack. The history of the City of Arcadia is documented from its incorporation in 1903 and includes information on local government, businesses, and maps.

Holdings currently comprise some 2000 photographs, three file cabinets of newspaper clippings, Arcadia City Directories from 1923 to the present, Arcadia school yearbooks, scrapbooks, Arcadia newspapers on microfilm from 1931 and Arcadia census on microfilm. Most of the collection ranges in date from the 1870's to the present.

Andornot worked with library and city staff to upgrade their older DB/TextWorks databases, clean up some of the data, and provide access to the results through our DB/TextWorks hosting service. We then developed and host a modern search interface using our Andornot Discovery Interface, available at https://arcadiahistory.andornot.com

The online collection provides access to documents, newspaper clippings, citations, and obituaries, as well as photos and paintings relating to Arcadia.

The home page features a rotating selection of watercolour paintings, as well as Quick Start links to other areas of the collection, ideal for new users. The graphic design of the site was matched to a new website for the library, for a relatively seamless transition from one to the other.