Imaginal Web Design LLC-Expert Vision-Exceptional Solutions

Custom Content Management System and Data Entry Programs

Web Developer, Jon Holmquist, has years of experience in programming and database design. He has applied his experience to create an AJAX-based *, comprehensive suite of custom Shopping Cart web application programs for developers to use in their own projects. The "back-end" database management tools include data entry programs for every database file in the module.

Content Management system

We have developed our own proprietary content managment system. This is a suite of utility programs that allows you to add, edit, and delete records in the multiple data tables that make up your database. There is one utility for each table and all of them operate exactly the same way - the only differences being the different types of data contained in each table. This suite of utilities is contained in its own subdirectory of your hosting account root directory so they are separate and easy to password protect. We host our CMS demos on our CMS Composer website. Please try out the demos yourself.

Database Table Types (Design Patterns)

We also have special tools that allow us to quickly (one-day turn-around) create inexpensive, custom data entry input web-application programs perfect for a Content Management System or for developers to use in their own projects. We can produce the three data entry table type utilities depending on the number of tables involved in your particular data relationship:

  • Master Tables - Reference tables that define a set of attributes about a specific subject. For example a Contact table contains name, address, email, and phone information about people you've had contact with. Try this Master Table Demo
  • Transaction Tables - Tables that store (sometimes time sensitive) recurring instances of a data relationship. For example, in an invoicing system with an Invoice master table which defines the primary attributes of an invoice (company name and contact info), the transaction table would store each of the invoice lines for each billing debit item as well as date sensitive credit payments against the master invoice. Try this Transaction Table Demo
  • Junction Tables - Tables that contain common fields from two tables that have a many-to-many relationship. For example, a school might track students, classes, and which classes each student is enrolled in. Try this Junction Table Demo

*Ajax (Asynchronous JavaScript and XML) is a web development technique for creating interactive web applications. It is rapidly gaining in popularity for the seamless and responsive interactive experience it provides to users. Traditional client-server processing requires a barely-noticed, but annoying, refresh of the page, which can add confusion if your page position is shifted. AJAX allows instantaneous database updates, page updates, message boxes, etc., without ever leaving the current page and focus.

For us to create your data entry web application programs, all we need are the definitions (also called the "schema") of the tables you're working with. Just email us information that looks similar to that below. For example the table definition of our simple demo table looks like this:

FieldData Type
contidint(11)
usernamevarchar(32)
emailvarchar(32)
phonevarchar(32)
contypeint(11)
commentstext
listoptintinyint(1)
credtimedatetime

Try out all of our Data Entry Input Program Demos, the Master Table demo, the Transactional Table demo, or our Junction Table demo, They are all fully functional examples of data entry programs for finding, entering, navigating forward and backward through, and deleting fictional contact, invoice and school classes information.

Features

  • Convenient access to data with multiple functions in a single interface
  • Find records to edit by entering a partial key
  • Target record is displayed in the middle of a list with similar neighbors above and below
  • Select record to edit from list with a single mouse click
  • List allows Next and Previous page scanning with buttons deactivated at maximum and minimum limits
  • 'Add This' button automatically changes to 'Update' after add
  • Main edit page displays record key number
  • Main edit page allows Next and Previous record scanning with buttons deactivated at maximum and minimum limits
  • Delete buttons prompt for delete confirmation
  • Entry values are error checked for type for numerical and date types
  • Drop down menus work for static values or values obtained from external relational tables
  • 'Complex' programs integrate relational table data entry to primary table data entry
  • Custom functions available, e.g. a summation function from line items - Amount Due in invoice example
  • Custom button functionality available
  • Image display functionality available
  • Display label for key id from an external table

Please contact us for questions or more information about our custom data entry programs.


  • Terms of Use
  • Your Privacy
  • Related Links
  • Site Map
Website design by Jon R. Holmquist at Imaginal Web Design LLC  | Stock Photography - Photo Stock Source  
 Panoramic Photography - Panorama Source  | Oregon Photography - Oregon Stock Photos
All content Copyright © 1998-2023 - Imaginal Web Design LLC - All rights reserved     Valid XHTML 1.0 Strict
CMS Support by CMS Composer
Imaginal Web Design LLC-Website Development Services

The Company

  • Home
  • F.A.Q.s
  • About Us
  • Contact Us

For Clients

  • Website Portfolio
  • Services
  • Web Design
  • Responsive Web Design
  • Web Development Approaches
  • Web Design Process
  • Website Pricing
  • Quote Request

For Developers

  • Stock Photography
  • Panoramas
  • Programming
  • Shopping Cart
  • Content Management System
Jon Holmquist is an absolute joy to work with. I was somewhat apprehensive about creating a website since I knew so little about the subject (and had put this project off for years because of it) and he made the entire project, start to finish, a pleasure!.
- Ivy J. Cotler
chef/owner Ivy's Cookin'

Get In Touch

Contact us for more information or questions you might have about your website project.

  • Contact Us
  • contact@imaginalwebdesign.com