Home Page

   Websites

   Databases

   PowerPoint

   Training

   Our Fees

   About Us

   Contact

 


Denning Systems Can Design and Maintain Your Database

Finally ... you can keep track of all your information

A database is an accumulation of custom data that you can enter and display.

Actually, a database is more of a complete data system. It includes the data itself, methods for you to enter data, customized reports, customized letters and documents, data filters, mailing labels, and so on.

The data: Basically, all of the data is held in one or more tables. You can picture a  table as being like a checker board, which is divided into columns and rows. The rows are called records. The columns are called fields. The square, where a particular column and row intersect, is called a cell. Each cell contains some data for that record, like an employee's street address, or a lawnmower part number.

Forms for entering data: The entry forms are where the user meets the data. A simple form is displayed on the computer screen. The majority of the form is made up of labels and text boxes. Labels are simply words that define the adjoining text box, for example "Last Name" or "Part Number". The text boxes are where you type the data. They may also be filled in ahead of time from existing data, or they can have a drop down menu with predetermined choices. A well designed form will allow a person, with minimal training, to properly enter, manipulate, and display important data.

Customized reports: The data can be filtered and sorted in any reasonable way. As a simple example, you may want to have a printed report, or generate mailing labels, of everyone on your Christmas list, from a certain ZIP code, or area code. You may need a report of all part numbers stored in a particular location, sorted in alphabetical order. You could even print a list of all employees with "A" as the third letter of their last name. The possibilities, and the practical uses, are almost endless.

Labels: A custom label, with specific data, can be printed for each record you specify. These labels are not limited to envelopes. Perhaps you need to identify parts or containers. Once again, the possibilities, and the practical uses, are almost endless.

Databases on the Internet: Your database can be placed on the Internet. Imagine any authorized person being able to make data entries, and read or print reports, from anywhere in the world. Persons authorized to access the data will have their user name and password stored in the database. After they enter the proper personal information, they will obtain permission to access and manipulate the data. Managers can control and monitor these activities through the use of administrative forms and data displays. 

Denning Systems ... we're here to help.