Database Railway station.mdb + course text

1.1. Statement of the problem

Create a database in Microsoft Excel and Microsoft Access: "Railway stations".
The database must contain the following elements:
- the name of the railway station;
– number of station personnel;
– number of main paths;
- the number of emergency tracks;
- information about the railway (name, head of the road, city where the head office is located);
- the name of the region (subject of the Russian Federation).
Functions performed by information technology:
1. Filling and editing database tables.
2. Formation of a list of stations with the number of main tracks not less than the requested value.
3. Formation of a list of stations located on the territory of the area selected by the user and having sidings.
4. Calculation of the average number of personnel of stations belonging to the same road, indicating the name of the head of the road and the location of the head office.
5. Formation of a report, including: the name of the station, the total number of tracks and the name of the railway grouped by regions.
Input data:
- the name of the railway station;
– number of station personnel;
– number of main paths;
- the number of emergency tracks;
- information about the railway;
- the name of the region.
Output:
– list of stations with the number of main tracks not less than the requested value;
– list of stations located on the territory of the region selected by the user and having sidings;
is the average number of station personnel;
– station report.