1 / 7

The Columns Banquets

Established in 2005 in Elma, New York, The Columns Banquets hosts over 275 events annually, accommodating groups of up to 160 people. Previously reliant on handwritten planning, the venue faced challenges in information management. To enhance event organization, a new database system has been implemented, ensuring quick access to customer information, event details, employee schedules, and payment records. Features include user-friendly forms, organized reports, and macros for efficient operation. Visit our website for more information on our services and database.

sharne
Télécharger la présentation

The Columns Banquets

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. The Columns Banquets Marc Paone Andrea Pasternak Elizabeth Quinn Jennifer Rothstein Garrett Schmigiel

  2. History The Columns Banquets was established in 2005 in Elma, New York. It is strategically located on the corner of Seneca Street and Transit Road. Columns books an average of 275 events per year. With spacious floor plans, it can accommodate groups of up to 160 people. This space is used to hold many different types of events such as: • Weddings • Business Meetings • Bridal Showers • Funeral breakfasts • Sports Banquets

  3. Business Problem • All planning concerning an event is hand- written on one piece of paper. • If the paper is lost, all of the details regarding the event are gone. • Columns has expanded their business and need an efficient way to store customers information, event details, employees working, and payment of events.

  4. Why is a Database is Useful? • Make event planning more organized • Managers can access information quickly • Customers information is stored for future events • Employees shifts are linked directly with specific events

  5. Database Design Overview Entity Relationship Diagram:

  6. Features • User friendly forms and sub-forms based off of five tables with options to add records, delete record, see next record, and print. • Organized reports which links customers and events, employees and shifts, customers and payments, and employees and events. • Macros which automatically open a main menu and allow user to close or print reports.

  7. Website and Database Website: http://www.acsu.buffalo.edu/~atpaster/# Database: Columns Banquets.accdb

More Related