Database Deposit Department.mdb + term paper

An analysis of the subject area showed the need to automate the activities of an employee of the bank's deposit department. It is possible to distinguish the composition of the tasks of the AWP of an employee of the deposit department of the bank: filling out an application; execution of a deposit agreement; harmonization of contract; analysis of work with clients.
The meaningful design of the hierarchical menu made it possible to determine the following menu structure: input of initial data; work with documents; reporting and exit.
In the process of designing the database, the need to develop the following tables was determined: positions; professions; currency; activity; the subject of the loan; education; employees; clients; contributor; applications; contracts.
Data analysis is carried out using developed queries and reports: report "Register of applications"; query "Search for an agreement by full name"; report "Register of clients"; report "Register of contracts"; query "Search for contracts for the date"; employee list report.