Sedang Disiapkan

224138 MSACCESS course booking System

Project: Training provider course booking System.

Creation of fully relation database using VBA/Ms Access 2000.

We are a training provider, providing tutor lead training courses:

Clients/Customers complete a booking form from a brochure or flyer and send it to us. Bookings are then added by our staff to this booking/Enrolment database we want creating.

Booking Procedure:

Neat intuitive, form or tab controls with access to Client/Company – Courses – Students – Payments, to allow us to add single or multiple bookings, all from a single interface with the ability to give a % discount for volume bookings/enrolments, then output an invoice via a Report for the bookings added.

All data should be stored logically and in a structured manner and be fully relational.

Forms to have good error handling.

Entities:

Clients/Company.

Clients can have many STUDENTS that can be booked on to attend COURSES

Holds all the company information ie address etc

A Form that shows Booking/Student history for the current client record.

Courses

All courses will have a Venue/Hotel allocated from the Venues/Hotels Table

All courses will have a Tutor allocated from the Tutors Table

Admin form to add/edit course list

Bookings

Holds the correlated booking information…

Venues/Hotels

List of Venues/Hotels that we hold courses at

Admin form to add Venues/Hotels

Tutors

List of tutors

Admin form for adding courses

Students

Students booked on Courses – Need to be added at booking

Payment

Payment information for bookings made.

Reporting

How many Students are Booked/enrolled on particular Courses?

How many Students are Booked/enrolled by date (From Date to Date)

Tutors allocated to which courses

Ability to print out duplicate invoices

----------------------------------------------------------------------------------

If you any further information please do not hesitate to contact me.

Kemahiran: Semua Boleh, Microsoft Access, Visual Basic

Lihat lebih lanjut: booking system vba, venue brochure, vba tutor, tutor flyer, give flyer, admin system company, vba error, print vba, microsoft vba, visual lead, tutors, print hold, multiple course, microsoft access vba, hotel system, flyer creation, edit flyer, discount flyer, booking system, creating access database forms, hotel database system access, hotel booking system access, database invoice microsoft access, duplicate table, tutor company

Tentang Majikan:
( 1 ulasan )

ID Projek: #1970374

Dianugerahkan kepada:

iLoveCoding

please see PMB

$400 USD dalam 15 hari
(61 Ulasan)
4.8