The project makes a « Driving school » base. Every client has an email and a photo, a mail adress with the city and the mail code. The code should be different of zero. The default city is Paris and there is only one city for each mail code. There should be a set of codes known by the database to choose from, and that the city could be chosen by identifying the code, in order to avoid the errors. For every learning session, the number of faults of a candidate is limited to 20. The session also has an attribute, qualifying the result, which value is “TB?? if the number of faults is lower than 5. A mark is calculated, equal to 20 less the number of faults. Each session has a few words title. The table of results of the sessions must have a sub-table: a request indicating for each tuple of results the average number of faults in the session referenced in this tuple. This allows to locate the client’s result for this session by one click. There is another base at the Prefecture (Townhall), called “Exams??. In this one, there is a table which, for each exam (identified by the same ID as in the school base), gives the average number of faults for this exam. The school base will have forms. At least : (1) the General Menu (“Menu Général??), automaticly launched ; (2) the capture and client’s file modifying form ; (3) the one which enables to enter the session results; (4) the display of all the data about a client and his results at the different sessions ; (5) one which displays the results of at least six requests of the listed below. These results can be forms, but it’s not an obligation. The requests are in the zipped doc file. There will have to be a brief relational diagram of the base.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Microsoft Access 2007