mgs 351 project
Download
Skip this Video
Download Presentation
MGS 351 Project

Loading in 2 Seconds...

play fullscreen
1 / 12

MGS 351 Project - PowerPoint PPT Presentation


  • 94 Views
  • Uploaded on

MGS 351 Project. Carlos Gamboa Jacob Pomilio Krystal Brown Leong Mei Si Nataliya Savka. Background. Company: Animal Humane Society Animal shelter designed to shelter stray animals until an owner is found. Due to the company being non-profit, almost nothing is computerized.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' MGS 351 Project' - teness


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
mgs 351 project

MGS 351 Project

Carlos Gamboa

Jacob Pomilio

Krystal Brown

Leong Mei Si

NataliyaSavka

background
Background
  • Company: Animal Humane Society
  • Animal shelter designed to shelter stray animals until an owner is found.
  • Due to the company being non-profit, almost nothing is computerized.
  • Lead to tedious and inefficient business system.
business problem
Business Problem
  • The former system was messy and unorganized.
  • Manual sign in sheets held all the important data.
  • No records of interaction with the dogs.
business opportunity and value
Business Opportunity and Value
  • We identified an opportunity to improve the company’s former system by implementing a new and effective database.
  • This database organizes all the information necessary thus producing a faster, more efficient operation.
  • Can be easily displayed to national branches of the Humane Society or other interested outside parties.
database design overview
Database Design Overview

3 main entities

1) People

  • Drop down list
  • Calculated control

2) Dogs

  • Acquired date
  • Validation rule and text
  • <=Date()

3) Attendance

  • AutoNumber
  • Notes
database design overview1
Database Design Overview

Relationship Table

  • 3 main entities
  • 1 to many relationship between
  • People and attendance
  • Dogs and attendance
  • Attendance is the main entity
database design overview2
Database Design Overview

Forms

  • 3 main forms
  • 1 sub form

Reports

  • 5 reports

Switchboard

  • Main menu
  • Links to forms and reports

Macros

  • 7 macros
  • AutoExec
user interface design
User Interface Design

Main Menu

  • The switchboard has all the links to the forms and reports including a help and exit button

Forms

  • 3 main forms
  • Customer, employee and dog records for easy accessibility
  • Attendance records shows the various statuses of each dog.
user interface design1
User Interface Design

Reports

  • 5 reports
  • Organize and classify information
  • Helps managers greatly
  • Creates business value
conclusion
Conclusion
  • Database will greatly improve efficiency of business.
  • Saves a lot of time
  • Easier follow up
  • Improve local management decisions
  • Garner more donations
  • Brings value to our cause
ad