Database Mail.mdb + course text

In the process of performing this work, it is necessary to develop a database "Mail". Compile data tables that describe the subject area, design and link tables, prepare several queries, design and develop several forms based on table data, create several types of reports, design and develop button forms.
Tasks to be solved - issuance of certificates about newspapers and magazines (index, title, circulation, price, publishing house, etc.), as well as their publishing houses (city, telephone, etc.).
Requests:
Ordering by fields: circulation, price, name.
Search: all information about newspaper XX,
Sample: Elektrostal newspapers.
Calculations: income received by NN publishing house (circulation * price).
Correction: deletion of data about the newspaper XX; increase in the subscription price for newspapers of publishing house X by M rub.
Integrity constraints: a) each newspaper is published by a publishing house in the list; b) the name of the newspaper is not an empty value; c) the index of the newspaper must be unique.
Tabular report: list of publishers; grouping by city.
Custom report: Subscription subscription (index, title, price...).

Content

3 introduction
1. Data Design 4
2. Designing and linking tables 5
3. Preparation of requests 6
4. Mold design and development 8
5. Reporting 10
6. Design and development of button form 11
Conclusion 12
List of used literature 13