Versions are stored in Access 2003 and 2010.
Automated system of road accidents.
>> 1. Create a database (tables, charts, substitutions, filling), in which information is stored:
- On vehicles,
- Their holders, one holder may have several vehicles
- The fines for violations of traffic rules
- A perfect vehicle traffic accidents (with date and time, participants and brief description of the incident)
- About fined
>> 2. Implement the following queries on the sample:
- List all incidents committed in a given time period
- Withdraw all fines and road accidents For transport, committed some owners on all their machines
- Withdraw the person who committed the most accident
>> 4. Create a form:
- To view, adjust and introduction of new vehicle owners
- To view, adjust and recording of the accident the owner of each his car.
- To view the number of accidents each species by day
>> 5. Create reports:
- About the owners and their vehicles
- About the accident and about the perpetrators
- The quantities of each type of accident in a given period
The main form.