xelodico/beltel

🗃️ Database for a fictitious hotel and spa complex.

🧮 Introduction

For my A2 (Year 14) Digital Technology coursework, a business solution was developed using Microsoft Access for the fictitious Beltel Hotel, Spa & Beauty Complex.

---

💡Features

• A normalised database with eight entities.
• Switchboard providing a GUI to aid user navigation.
• A sophisticated membership registration and restaurant ordering system.
• Detailed reports generated from SQL queries.
• A Macro for common tasks, such as archiving orders from the last six months.
• Comprehensive documentation and a user guide.

---

🖼️ Screenshots

ER Diagram
The MEMBER table
The MAIN ORDER query
The STAFF form
The Best-selling products report
The ORDER ARCHIVE macro

---

🖥️ Run Locally

1. Download the latest release.
2. Once finished, unzip the file and click on Beltel Database.accdb.

---

📚 Documentation

Database Documentation

• An overview into how the system was implemented.
• It is divided into 4 sections: Analysis, Design, Application Development and Evaluation.

User Guide

• Features step-by-step instructions on operating the system and a section with frequently asked questions to help users maximize its potential.