Task for the access database "Picture Gallery".
Topic: information system of the picture gallery
Description of the information system:
Information system of the picture gallery stores information about paintings, exhibitions, artists.
In the picture gallery exhibitions are held. The exhibition presents works of art of various masters. One and the same work of art can be presented at several exhibitions (expositions). The exposition is a set of works of art presented at this exhibition. Each work of art has its owner, refers to a particular kind of art (painting, sculpture, graphics, etc.) and a certain direction in art (impressionism, primitivism, modern, surrealism, etc.). The exhibition is characterized by the time of the beginning and the end of its holding. Works of art are characterized by the year of creation, the estimated value.
As output documents, it is necessary to obtain the name of the exhibition with the exposition having the highest estimated value for the previous reporting period (the month previous to the current period).
Also, to form a report sheet indicating all the works of art exhibited by the artist in the gallery. Based on the results of the formation of the sheet, determine how the works of art of various directions are represented in the gallery (by the number of works and by their estimated value).
1. Create tables by defining properties for each field in the table.
2. Establish links between tables.
3. Create delete requests, add and update rows
4. Create two forms: simple (based on one table) and complex-subordinate (based on two tables, united by a one-to-many relationship). Place in the forms various control elements: fields with drop-down lists, buttons for launching queries and forms, and so on.