Banner Image

All Services

Programming & Development

Database Design

$5/hr Starting at $25

At the Marine Corps base in Barstow, California, I developed a forms-based database application using MS Excel as the platform, supported by VBA code, that tracked utilities expenditures (and reimbursements) by each department on the base. I created data entry screens for the operator to enter monthly meter readings, direct billings (invoices), and miscellaneous billings. I included functionality to analyze the data and generated dynamic reports/charts to show past performance and to forecast near- and long-term trends.The database contained well over a million records, distributed among a number of workbooks that, together, constituted a tabularized, relational database. Included was extensive built-in software support for database maintenance tasks such as adding/deleting/editing records in each table, finding data in user-specified columns, dynamically reporting the data in accordance with user-specified report criteria, and more.Operation was via labeled buttons on drill-down userf

About

$5/hr Ongoing

Download Resume

At the Marine Corps base in Barstow, California, I developed a forms-based database application using MS Excel as the platform, supported by VBA code, that tracked utilities expenditures (and reimbursements) by each department on the base. I created data entry screens for the operator to enter monthly meter readings, direct billings (invoices), and miscellaneous billings. I included functionality to analyze the data and generated dynamic reports/charts to show past performance and to forecast near- and long-term trends.The database contained well over a million records, distributed among a number of workbooks that, together, constituted a tabularized, relational database. Included was extensive built-in software support for database maintenance tasks such as adding/deleting/editing records in each table, finding data in user-specified columns, dynamically reporting the data in accordance with user-specified report criteria, and more.Operation was via labeled buttons on drill-down userf

Skills & Expertise

Algorithm DevelopmentData EntryEditingExcelMsMs ExcelReportsSoftware DesignVBA

0 Reviews

This Freelancer has not received any feedback.

Browse Similar Freelance Experts