bio
music
in concert
art

design

Database design in Microsoft Access

Combining Art & Science into a powerful, user-friendly custom application
yields productivity with no sweat, answers when and where you want them,
intuitive screens, and hardcopy/facsimiles that are remarkably informative,
succinct, and, of course, stylish. 
RAM Productions (Marsh, Copsey & Associates)
Washington DC
Television studio Complex for ZAGROS TV, Erbil, Iraq Project Wrangler
  • PO creation, tracking
  • Inventory and asset management.
  • Shipment logistics
  • Manifests/Bill-of-lading
  • Customs declarations.
  • Warehouse and operations Expense tracking.
FAA (Federal Aviation Administration)
800 Independance Ave. SW
Washington DC
ATO-F Capital Expenditures FAA-TARS
(The Hudson Hornet)
  • MS Azure Cloud-based SQL Server back-end
  • MS Access Client-side User interface
  • Database splits to track both Operations and F&E sides of the enterprise.
  • Service Order/Program Funding & ExpenditureTracker tracks
  • Funding: Allocation & Obligations, and Funding vehicles
  • Provides reporting by Product Division, Project Code,
    Line-of-business, Client (ATO-W, ATO-E, etc..), and Service Provider levels.
  • Tracks Invoices & line items including labor providers & their hours
  • Tracks FAA PRISM Purchase Request Routings.
  • Provides Monthly, Quarterly, and Year-to-date reports to APML/Managers and supervisors

 

Site Development Services, Inc

5920 Sawmill Rd., Clifton, VA
703.968.3300
SDS estimates Cut & Fill quantities, material removal quantities, and
construction site development costs using 3-D computer graphic modeling.

The SDS site Wrangler
  • Job Assignment
  • Task flow and Job-tracking
  • Invoicing
  • Sales and Job quality-control analysis
  • Client Order Tracking
  • Technician Timesheet and bonus point tracking

Advance Concepts Inc. & TCT

8229 Boone Blvd. Suite 102, Vienna, VA
703.448.0445
ACI plans and manages all Audio and Video technical aspects of the annual Trans Catheter Technologies (TCT) convention at the DC Conv. Center.
11,000 Cardiac Doctors from around the world with 1,100 presentations in a five-day period.TCT Doc Wrangler
  • Links with TCT database
  • Speaker Ready Room coordination
  • Print a Doctor's personal appearance schedule
    • Print a day's schedule of all Halls and breakout rooms
Video Wrangler
  • Video Sales Order-taking
  • Onsite Order Receipts
  • Task flow and Job-tracking
  • Invoicing
  • Sales analysis
  • Client Order Tracking
FAA (Federal Aviation Administration)
800 Independance Ave. SW
Washington DC
ASU-370 FAA-Audit Wrangler
  • FAA/DCAA Audit Action Tracker
    • tracks:
  • Current DCAA Audits of FAA Contracts
  • FAA funding of DCAA audits
  • Contains a module that will link to

    • DCAA DMIS billing statements and
    show up- to-date billing, funding, and delta.
  • Tracks audits by Contract #, Contractor, and program (ie: STARS, WAAS, etc...)
    • Creates reports of all CO contract caseloads
Pentagon: Employee Referral Service)
Pentagon
Washington DC
PERS Doc Wrangler
  • Doctor & Specialist Database
  • Specialist search by specialty, location, and insurance type
FAA (Federal Aviation Administration)
800 Independance Ave. SW
Washington DC
ATB-10 ATB Pipeline
  • FAA HR: ATB-10 Job Action Tracker
    • tracks:
  • Review Process
  • Documentation Process
  • Award Review & Payments
    • Creates reports of all CO contract caseloads
FAA (Federal Aviation Administration)
800 Independance Ave. SW
Washington DC
ASU-310 A/I-Tracker
  • FAA Contracts Appropriation Code balances
  • Invoice tracking
  • Task & CLIN level tracking
  • Advance/Progress Payment & repayment balance tracking
  • Supervisory Reports of all CO contract caseloads

Database/Estimate & Invoicing design in MicrosoftAccess

Advance Concepts Inc.

8229 Boone Blvd. Suite 102, Vienna, VA
703.448.0445
Creative MultiMedia, Computer Graphics, and Video services
and Event Staging Services Company
DataCow (server) & Elsie (client)
  • Creative Services Estimates
  • Task flow and Job-tracking
  • Invoicing
  • Sales analysis
  • Client Call Tracking
Permere Presentation
2929-C Eskridge Rd, Merrifield, VA
703.204.1258
Video, Multi-image, Staging and Audio Equipment Rental 
and Event Staging Services Company
  • Rental & Service Estimates
  • Invoicing
  • Job-tracking
  • Sales analysis
Hardware Technologies
14500-H Lee Rd, Chantilly VA   703.802.0266
Digital hardware, Digital Storage & Retrieval Subsystems
  • Client Database
  • Call logging
  • Sales analysis
LANscience
Willard St., Chantilly VA   703.802.0277
LAN & WAN design, Implementation,
Proactive System Management
  • Client Database
  • Call logging
  • Sales analysis