Transcript MGS351 A12 Group 3 Presentation PPT

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
 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
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
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
Design Overview







Check In
Members
Membership
Personal Training
Employees
Department
Machine Repair Log
User Interface Design
 BAC DATABASE.accdb
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
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
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