1 / 10

Buffalo Athletic Club

Buffalo Athletic Club. Section A-12 Group #3 Stephanie Bulkowski Melanie Matthews Ai Peng Andrew Robertson Yuxiang Wang. Agenda. Background Business Problems Business Value Design Overview User Interface Design Additional Features Conclusion. Background.

holt
Download Presentation

Buffalo Athletic Club

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Buffalo Athletic Club Section A-12 Group #3 Stephanie Bulkowski Melanie Matthews Ai Peng Andrew Robertson Yuxiang Wang

  2. Agenda Background Business Problems Business Value Design Overview User Interface Design Additional Features Conclusion

  3. Background Western New York’s premier health club Founded by Rick Rugg and Bob Schiffhauer in October, 1980 Has grown all throughout Buffalo and expanded to Rochester, creating the Rochester Athletic Club (RAC) Since 1980, they have used a paper-based format in order to keep track of their operations

  4. Business Problems • Three-quarters of its functions are in a paper based format • Mostly a “he-says-she-says” based system • No set operations or even a standardized database for the BAC’s • Many papers are misplaced • Not filled out correctly • Unable to read an employee or customer’s writing • No proper place to file papers • Not having access to papers that are needed

  5. Business Value • End the BAC paper system and produce a better system for keeping track of files • Have an opening screen with announcements there for employees to read • Create a better customer value • Lead to more organized data that can help daily activities run simpler • Money • Maintenance • Personal Training

  6. Design Overview Check In Members Membership Personal Training Employees Department Machine Repair Log

  7. User Interface Design BAC DATABASE.accdb

  8. Additional Features • Tables • Dropdowns • Check In – Location • Department - Department title • Employees – City • Members - City • Check box • Personal Training – Show up • Attachment • Employees • Input masks • Employees – State; Phone number; Zip code • Members – State; Telephone number; Zip code • Forms • Navigation form • Calculated control • Membership – Price with discount • Additional button • Membership – Previous Record; Next Record • Conditional formatting • Machine Repair Log - Cost • Queries • Grouped • Department & Employees – Employee ID of count • Parameters • Check in Count • IIF Statement • Department & Employees - Size • Concatenation • Membership & Members - Member • Advanced criteria • Ascending

  9. Additional Features • Reports • Additional buttons • Print Report • Personal Training - Close Report • Calculated fields • Employees – Department Total Employees • Members based on Types of Memberships – Membership Type Total Members • Made from advanced queries • Membership based on Types od Memberships – Membership & Members Query • Conditional formatting • Check In – Alerted Notes • Machine Repair Log - Cost • Switchboard • Additional menu interface • Employees Menu • Members Menu • Additional macros • Close Database • Quit Access • Website • Multiple pages • Video

  10. Conclusion Our database will fix the current problems at the BAC We hope that our database will be so successful that it will be used at the RAC

More Related