Database Warehouse.mdb + course text
Replenishment date: 13.04.2022
Content: text (32 characters)
️Automatic issue of goods ✔️
️Automatic issue of goods ✔️
Sales:
0
Refunds:
0
Reviews:
0
Views:
100
Description
Develop a database to store data:
Goods in stock and their release to customers.
The database must be developed in the MS Access environment and must contain at least two tables containing data about the subject area of your assignment. You choose the list of required fields and their type in the tables yourself, based on the meaning of the task solution.
At the first stage of creating a database in MS Access, you need to create the required tables in design mode, set a primary key for each table, and establish relationships between tables.
At the second stage, you should enter data into the created tables in the table mode (at least 10 records in one table and at least 40 records in the second table).
At the third stage, you need to create two queries in design mode to retrieve data from the database tables. The first request should be based on one. The second query should fetch data from two tables. The last step is to use the Report Creation Wizard to create a report based on the second query.
Content
1. Text of task 3
2. Description of the database design process 3
3. Structure of database tables 4
4. Scheme of relationships between tables 6
5. Contents of tables 7
6. Request structure 8
7. Query results 11
8. Structure of the report 12
9. Report output results 13
10. Shapes 14
List of used literature 18
Goods in stock and their release to customers.
The database must be developed in the MS Access environment and must contain at least two tables containing data about the subject area of your assignment. You choose the list of required fields and their type in the tables yourself, based on the meaning of the task solution.
At the first stage of creating a database in MS Access, you need to create the required tables in design mode, set a primary key for each table, and establish relationships between tables.
At the second stage, you should enter data into the created tables in the table mode (at least 10 records in one table and at least 40 records in the second table).
At the third stage, you need to create two queries in design mode to retrieve data from the database tables. The first request should be based on one. The second query should fetch data from two tables. The last step is to use the Report Creation Wizard to create a report based on the second query.
Content
1. Text of task 3
2. Description of the database design process 3
3. Structure of database tables 4
4. Scheme of relationships between tables 6
5. Contents of tables 7
6. Request structure 8
7. Query results 11
8. Structure of the report 12
9. Report output results 13
10. Shapes 14
List of used literature 18
Additional Information
I enclose the text of the term paper on page 18. Development environment: Microsoft Office Access.