For my A2 (Year 14) Digital Technology coursework, a business solution was developed using Microsoft Access for the fictitious Beltel Hotel, Spa & Beauty Complex.
- 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.
ER Diagram
The MEMBER table
The MAIN ORDER query
The STAFF form
The Best-selling products report
The ORDER ARCHIVE macro
- Download the latest release.
- Once finished, unzip the file and click on
Beltel Database.accdb.
- An overview into how the system was implemented.
- It is divided into 4 sections: Analysis, Design, Application Development and Evaluation.
- Features step-by-step instructions on operating the system and a section with frequently asked questions to help users maximize its potential.