These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience
Saturday, December 12, 2009
Band Manager VBA Application
Executive Summary
I am a very busy and active performing musician. I play with several bands and groups, host and promote concerts, and record and sell CDs. I track the musicians that I work with, venue contacts, CD sales, and other finances. I created the Band Manager application because I was looking for a way to do all of these things in a single, unified environment.
The application uses a modified relational data model. The advantage to this is that Band Manager supports one to many and many to many relationships between objects. Also, in addition to it's robust processing capabilities, the interface is simple and intuitive. The user interacts with the Band Manager UI and never with the data tables.
The application is launched from a button on the main worksheet upon opening the application. Once the UI is visible, the user can create, read, and update musicians, bands, venues, gigs, and merchandise objects. The user can also create or delete relationships between musicians and bands, venues and gigs, and financial transactions with merchandise and gigs. Lastly, the user may view reports about disbursements and sales.
Full write up availablehere
excel workbook availablehere
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2009
(62)
-
▼
December
(61)
- Anthony WhiteProject Write-UpProjectBusiness Backg...
- Utah County Property Search
- Inventory Tracker and Exporter
- Final Project Journal Entries
- Piano Technician Customer Database
- Band Manager VBA Application
- Student Hours Report for the Political Science Dep...
- Final Project ISYS 520
- Jeremy Heckaman - Viking Pest And Plant Customer/C...
- Student Teacher Database - Alexander Ivanov
- Statistical Research Program - Matthew NelsonExecu...
- Inventory Tracking System
- Route Y Registration
- BOb Transaction Report Analysis Project
- PBC Report Project
- Finding the Area of a Cutter
- APX Licensing Reporting Tool
- iTunes Playlist Generator
- Tracking Days-in-Inventory
- Textbook Pricer
- Aircraft Part Measurement Analysis
- Income For Life
- Extracting Email Data & Small Business Accounting
- Adwords Report Automation
- Inventory and Sales Manager
- Jaxon Physical Therapy
- Faculty Profile System Report
- Refund Reconcilation and Stale Dated Checks
- The Drakinator by Drake Allsop
- Automated Year-on-Year Sales Report by Rand Blair
- Nate Smith VBA Project
- Contract Threshold Matrix
- Stock Picker
- Pricing Monitor
- Waddingham & Peterson Law Firm Database
- Josh Caplin VBA Final Project
- VBA Project Pope Weston
- VBA Project- Customer/Supplier Database
- Classroom/Grade Management
- Negotiation Scoring System
- Financial Analysis Automation
- Green Light Films Set List Database
- Nine Fingers Sharpening
- Internal Audit Purchasing Card Applications
- A VBA Project for Health Equity
- Client Billing Manager
- Ward Membership Data Viewer
- Ebay Data Extraction
- Nonprofit Financial Management
- Winder Farms
- Reconcile G/L Accounts: A VBA Application
- Let There Be Light
- The Board List--Text Message Sender Tool
- Oil Volume Auditing Add-In
- Security Analyzer
- Expense Report Analysis
- QB Interface 1.0
- Google Analytics Report Runner
- Wind Loads per ASCE 7-05
- Product Manager Dashboard
- Bathroom Remodel Estimator
-
▼
December
(61)
No comments:
Post a Comment