Tapestry is designed to enable a police force tape librarian to keep track of audiotapes and videotapes, to record details of sub copies made and keep track of working copies.

Details of audio and videotapes, working copies and sub copies, are linked to supporting data, including: station codes, offence types and force areas. All main data tables are amendable on-line, by users with the appropriate authority.

• Tapestry stores details of the file and tape numbers, interviewee, officers and witnesses. Once a tape has been dealt with, a retention code is stored which determines how long the tape and working copy are to be retained.
  
  
• A common address database table is available for recording names and addresses of institutions, such as the Crown Prosecution Service, which need to be contacted regularly.
  
  
• Mass letter printing is made easy as the system builds all the necessary information into merge files and then makes the word processor do the hard work of producing the final documents.
  
  
• There are comprehensive query facilities allowing users to interrogate the database for records matching specific search criteria.
  
  
• Simple queries can take place directly from a form, without the user needing to type in information.