|
Database Creations
provides the following services:
 |
Database Design & Development |
 |
System Analysis |
 |
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.
|