Project description
“With the help of the Access database, create a database of accounting of crossing the state border by Russian citizens departing from the Russian Federation by rail. The database should store the following data: train number, type of train (ambulance, brand), time and station of departure, time and station of arrival, number and type (coupe, SV, etc.) of the car, seat number; name of a citizen of the Russian Federation, type of passport (Article 7 of the Law on the procedure for entry, exit ...), passport number, purpose of departure, country.
Create forms that provide input, viewing and editing of data.
Create requests that provide the withdrawal of information:
- on citizens of the Russian Federation departing to a particular country;
- in the cross-query for each train number (line headings) to determine the total number of citizens departing from the Russian Federation with an indication of the type of train (column headings).
Create a report that ensures:
-) output of data on tickets sold to citizens of the Russian Federation to a certain terminal station.
In the created database enter records to visually check its performance.
Create forms that provide input, viewing and editing of data.
Create requests that provide the withdrawal of information:
- on citizens of the Russian Federation departing to a particular country;
- in the cross-query for each train number (line headings) to determine the total number of citizens departing from the Russian Federation with an indication of the type of train (column headings).
Create a report that ensures:
-) output of data on tickets sold to citizens of the Russian Federation to a certain terminal station.
In the created database enter records to visually check its performance.
Other / Miscellaneous Bank transfer
