Create Table Forms, Data Input Screens, Lookups, Reports
$30-5000 USD
Closed
Posted over 15 years ago
$30-5000 USD
Paid on delivery
Using fully normalized database, and some reference code, build user interface, data entry screens, searches / lookups for a number of tables including:
ASSET ORIENTED TABLES:
Zone Table (9 fields)
Bin Location Table (12 fields)
Asset Type Table (50 - 55 fields, depending on how counted)
Asset Table (100 - 110 fields, depending on how counted)
Vendor Table (25 - 30 fields...)
Asset Documents Table
Asset Documents Type Table
Asset Inspections Transaction Table
Asset Maintenance Transaction Table
Condition Table
Warranty Terms Table
Some of these fields are calendar based calculations.
Tables do relate to each other and pull data from each other.
Each table will have 1 report assigned to it, except the asset table, which will have 3-4.
MEMBER ORIENTED TABLES
Contractor Database
Training Company Database
Certificates Table
Trainer Membership
Trade Table
Construction Status Table
Jobs table
End User Table
Trainer Affiliation Table
Member Table
Alergies Table
Medications Table
Security Questions Table
Member Types
Medical Conditions
Medical Specialty
Documents Table
Trade Table
Union Table
Local Table
Experience Table
Member Document Table
Certificated Table
All tables except: Member, Member Types, Asset Asset Types require only one view. Member, Member Types, Asset Types, and Asset Tables all require multiple views.
All data input screens & forms must be constructed in a way that allows for multiple language capability (English, French, Spanish, Italian, Portuguese, German) languages must be turned on at will by end user.)
There must be a field level help system.
A specification including screen mock ups is generally complete.
Successful completion of this project should lead to additional work to complete daily procedure processing / applications.