PxPixel
Web Based Databases - Tech Learning

Web Based Databases

Last week I mentioned Jotforms, an easy to use web tool for creating simple forms. This week I would like to expand on this idea and talk about online database tools. Basically these are tools similar to traditional desktop databases, except you access them and enter data via a web interface. Because they are accessed
Author:
Publish date:

Last week I mentioned Jotforms, an easy to use web tool for creating simple forms. This week I would like to expand on this idea and talk about online database tools. Basically these are tools similar to traditional desktop databases, except you access them and enter data via a web interface. Because they are accessed through the web, they provide all the advantages of a web-based tool including ubiquitous access and the ability to share data collection and data mining. Two examples of this type of web database are Dabble DB and Zoho Creator. The following example describes the use of Zoho Creator, but the principles and methods described can be applied to any of these web database tools.

Zoho Creator is one of the many web based tools provided by zoho.com. Creator allows you to create any number of web-based data applications. For example one could create a simple form for capturing school custodial work requests. Using the simple form creating interface, you can easily drag and drop fields, arrange them, and create a web form where the information is to be captured. Once the information is entered it can be viewed and searched as with any database. Email alerts can also be established that route the request to specific individuals. In our custodial request example, once a teacher submits a request, an email containing the information is sent automatically to our building custodian, and to the principal.

In addition Zoho Creator allows you to export your data in a number of common formats including PDF, Excel, and tab delimited text. One other very nice feature is the ability to export an RSS file. This RSS file contains the latest entries in the data base. One could imagine having several of these web based data collection tools and using an RSS reader to organize and watch them.

Another use we are exploring is the creation of a data collection tool for classroom walkthroughs and observations. Using one of these web database tools, a principal could easily create a form to capture classroom walkthrough information. Since this is a web based tool one could easily add content from any web accessible device, a laptop, a cellphone, a palm device or an iPhone.

Next Tip: Web Based Databases

Featured

Related

Easy Web Based Forms to Capture Information

My school, like most schools, has its staff fill out all kinds of forms, everything from emergency contact information to technology support requests. The forms are then collected and saved in folders or binders and accessed when needed. I have grown tired of this paper chase, often finding myself wishing I had ready

Fixing a Corrupt Entourage 2004 Database

Question: My Entourage 2004 has a corrupt database. I attempted to use the database utility tool and it gives me an error message. "An error occurred while attempting to verify your database. An unknown error (-5000) occurred." No matter what I try, verifying integrity or rebuilding database, etc., it gives me the

Web-based Word Processors

Tip: Have you ever worked on a computer that didn’t have a word processor? How about using a Web-based word processor? Zoho Writer's "Online Word Processor" provides all the tools you need to write and Email your document to yourself or save it in your online document folder. Try it as a demo user or sign up

Access Database on a Macintosh

Question: How can I view and use an Access database on a Macintosh computer? The IT Guy says: You have several options. If you are using an OS X Macintosh computer, you can use the free program from Microsoft “Remote Desktop Client for Macintosh” to remotely connect to a WindowsXP computer (with

Access Databases on a Macintosh

Question: How can I view an Access database on a Macintosh? The IT Guy says: Three possible options come to mind. First, you could have the person export the Access database data as a delimited file, and then open that file with Microsoft Excel or another spreadsheet program. That way you could not only view

Web-based tool processes exam data

Binghamton City School District recently implemented TestWiz, a web-based testing analysis and reporting tool, to help expedite the student assessment reporting process for K–10 classrooms in the district.

New Web-based service announced

My Web Lockers (www.myweblockers.com) is a new Web-based service launched today that intends to make it easier and more affordable for K-12 schools to begin using the Internet to store and share everyday projects, such as homework and class assignments. Affiliated with School Web Lockers (www.schoolweblockers.com), the leading online platform for cost-effective, Web-based collaboration and storage for K-12 schools, My Web Lockers provides schools with an entry-level solution to their file sharing challenges. Check back and look for our review in an upcoming issue and online here at techlearning.comClick through for the full release.