Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • Doxserá DB Library
  • Doxserá DB, What can it do?

Demonstrating DB Drawing on Two Excel Spreadsheets

Properly structured, an Excel spreadsheet can approach the functionality of a database when using DB

Written by Service Desk

Updated at October 4th, 2024

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Introductions to our Software
  • The Learning Curve, Three Training Courses
    The Readers' Digest Condensed Version In the Beginning, The Lesson Plan #1 The Lesson Plan, The Lesson Plan #2 The Learning Curve Basics, #1 The Learning Curve Intermediate Level, #2 The Learning Curve Advanced Level, #3
  • Installations and Emergencies!
    Installation Instructions Network, Unusual, Troubled, or Manual Installations Emergencies — What to do when things turn hot
  • Videos: Deep Dives on Specific Features
    Form Sets Doxserá DB and Its External Sources
  • Doxserá DB Library
    Doxserá DB, What can it do? Doxserá DB, How does it work? Doxserá DB, In-depth features and functions
  • Resource Library
    Guides and Manuals Video demonstrations of the Lessons in the Expert Guide Organizing Files, Folders, Documents, Templates… and Your Life Converting WordPerfect to Word
  • The Community Treasure Chest
    Truly Complex Roles Complex Math and Date Formulae Tidbits That Can Improve Your Experience Company Organization and Formation Oklahoma Dissolution Form Examples Sources: Master Lists, Spreadsheets, and other data sources Little Tools
  • Aurora
  • Word Warriors®
    About Micrsoft Word Tips & Tricks
  • News and Updates
    Staying up to date Current Versions of Our Software Updates for Doxserá and TheFormTool Archives
  • More
    All Things Mac, Linux, Tablets, and Other Items Miscellaneous Feature Requests
+ More

In today's data-driven world, businesses and individuals alike are inundated with information. However, few have the tools to effectively harness that data. Doxserå® DB empowers users to take control of their data, transforming it into valuable insights with ease.
 

In this demonstration, we’re not going to overwhelm you with every feature inherited from the Form Tool and Doxserå®. Instead, we’ll focus on Doxserå® DB’s remarkable ability to integrate and leverage multiple external data sources effortlessly. This will be an illustration of Doxserå® 
DB being used at its most basic level, designed to show you what it can do and how simple it is to operate.

Today, we’ll use two data sources. The first is a library’s Excel workbook with worksheets listing authors, books, and borrowers, including their addresses. The second is a single worksheet listing the branches of the library.
 

We start by demonstrating a simple form that pulls specific information from the data sources. Let’s say we want information on a particular author—Herman Melville—and one of his books, Moby Dick. With just a click, Doxserå® DB pulls detailed, readable data from multiple worksheets, compiling it into a clear, customized format.
 

But the power of Doxserå® DB doesn't stop there. We also show how you can create documents for multiple borrowers at once, generating personalized letters for each. In this example, we create four letters—each customized to a borrower and referencing the specific book they checked out, the author of that book, and their local library branch.
 

Finally, with Doxserå® DB’s direct access feature, you can customize data retrieval and formatting. Whether you want to filter books by century, gender of the author, or even a specific author like Mark Twain, Doxserå® DB instantly compiles the information you need into any format you desire.
 

This demonstration highlights the true power of Doxserá DB: transforming your existing data into useful, customized documents with a few clicks—saving time, reducing complexity, and increasing efficiency.

Your browser does not support HTML5 video.

5:17

historical period past date

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • How to add additional rows in Q&A Tables?
  • TLC 2 How to Save a Questionnaire
  • Two Minute Demonstration of DB From a Users' Perspective
Recent posts
  • Multi-Party, Multi-Role Decisioning
  • The Fastest Training
  • Inflation is Going to Grow, a Lot
  • The lowest-hanging fruit
  • Technical tidbits from TheFormTool, LLC
  • Improving Your Firm’s Support Structure
  • The Knowledge Base
Request for information

Submit

Recent Tweets
  • While TheFormTool remains amazingly easy to use, it's fully capable of managing truly complex document assembly nee… https://t.co/DHPPwcNv1M 6 days ago
  • It was in January 2021, that we first forecast massive inflation was coming our way. Whether it is called “quantita… https://t.co/Ab3MV1SLQz 26 days ago
  • Low-hanging fruit: the most often used features of document assembly systems. Automatically: perfect pronouns and p… https://t.co/A5rg6zRSd8 200 days ago
Copyright ©2012-2022 TheFormTool, LLC. All rights reserved.

Knowledge Base Software powered by Helpjuice

  • Home
  • Contact Us
  • Privacy
  • TheFormTool User License
  • Site Map
——— bottom-nav
Expand