Subscribe


 

 


Services
 


Database Creations provides the following services:

bullet

Database Design & Development

bullet

System Analysis

bullet

Custom Programming - Access, SQL, Pocket PC, Palm O/S, Visual Studio, HTML,

When we design a new system we will work with the client to develop a specification if one is not available. After the
specification is completed, the system is designed using our development methodologies. The system generally consists of 4 main elements.

- Application Data Model
- User Interface
- Forms
- Reports

Application Data Model

All data tables are normalized to eliminate redundancy, improve overall performance, and reduce database management
overhead.

User Interface

The user interface generally consists of a main menu also referred to as an application switchboard that utilizes the latest design techniques and feature the new contemporary look of the new generation of Window’s products. All forms are designed to conform to Windows standards and interface guidelines as published by Microsoft. The system will be able to be operated by both a mouse and a keyboard. For users who want to primarily use a keyboard, hot keys, and mouse equivalent navigation will be provided.

The ability to specify defaults will be provided. The design goal is to automate tasks as much as possible to minimize user entry.

Forms

A form is generally be provided for each function. All data entry/display forms include consistent navigation buttons and
common find and print dialogs. Drop-down lists are utilized to minimize data entry. All date or time entries are selectable by a visual time/date pop-up calendar or time clock. All years will be in 4 digits to comply with year 2000 processing standards. Tabbed dialogs are used to keep the forms organized, uncluttered and easy to use.

Each form features error checking to handle potential problems and maintain correct data. Business rule processing will be supplied by the client. Extensive use of combo and list boxes for data entry are utilized where appropriate.

We include our pre-designed search engines as appropriate to make record selection and searching for data both easy and flexible.

We assume the user has a basic understanding of Access form navigation, so we generally do not include buttons that duplicate the functionality available within Access. These typically include moving from one record to another, adding records, deleting records, closing forms, etc.

Reports

We will provide a centralized reporting facility with our Report Manager which allows the selection of one or all records from a dynamically selected defined group of criteria. Reports can be sent to the screen or a hardcopy printer and can be printed with both standard and optional titles. The user can also select the quantity to print. The reports facility will allow the seamless inclusion of any user-created reports.