The task for the database database access database of the post office delivery department.
Note: vba in the finished database is used for the form of adding / removing fields and for the "Prices" form for the year (if more than the following) and prices.
1. In Microsoft Access, create tables on the basis of the logical data model, set the necessary restrictions on the data in the fields, establish relational relationships between the tables in the data schema, and then fill the tables with data in accordance with the context of the domain.
2. Execute the requests specified in the variant of the task, create reports on them, and also independently invent and execute queries with conditional sampling by fields with the date / time type; requests for deletion, for addition, for updating, and for creating tables (theory and examples are set forth in laboratory works No. 3, 4).
3. Create for the database user a screen form that will automate the work with the data: view, add, delete and modify records in any table without using standard Microsoft Access panels, run created queries, view and print reports, search and view related table information in subordinate forms. All field codes of the linked tables on the "many" relationship side must be replaced by substituting the original parent table data. All necessary controls must be placed on the forms so that the user is intuitive and easy to work with the database (theory and examples are set forth in laboratory work No. 5).
4. Create a form for adding and removing fields and write a program in VBA, which allows using elements of this form to add and remove any non-key fields in any of the database tables. In this case, only the structure of the tables should change, it is not necessary to display the change in the composition of the fields on the forms. Viewing changes in the tables should be done with this form. All actions performed on the form (selecting a table, selecting a field, specifying a new field name, selecting a data type) in case of any error (the field already exists, the field type is not specified, the table is not selected, etc.) should be accompanied by contextual messages , directing the user´s work (theory and examples are set forth in the laboratory work No. 6).
Option 3. Create a post office delivery department database. Indicative tables-components: "Subscribers", "Periodica", "Subscriptions", "Postmen". The total number of fields in the database is at least 20, the total number of records is at least 30.
Create reports on requests: "Subscribers of the newspaper Vecherniy Minsk" (conditional selection); "Number of subscriptions for each publication" (final request); "Subscriptions are cheaper than a given price" (parametric query); "Dynamics of prices for subscriptions to specified publications" (cross-request), output a general list of subscribers and postmen (request for association).