Database of the Internet Store of Smartphones
Source data: text of task
TZ: Create an Internet store of smartphones in Access, with the possibility of authorization, personal office, access to site analytics, catalogue of goods, the possibility of ordering
Implementation: on the main page created: access to the personal office, after successful authorization, access to analytics and transition to the catalogue.1) The personal office:
1.1 ofpassing authorization, if successfully - transition to the possibilities of LK, otherwise - error
If successfully fulfilled 1.1, the customer may change the personal data, view all of his orders and view orders within a certain interval of dates.Analysis of the store:
2) Possibility of adding supplies
2.2, 2.3) Delivery and sales report with further possibility of displaying data in the schedule
2.4, 2.5, 2.6) Search by dates, customer search, product search
3) Catalog of goods, where you can see the photo of the goods and its characteristics.3.1)If the customer wants to make an order, he presses "form the order" and in the form chooses his number, after which the current date is automatically entered, with the possibility to manually change the data and data of the customer that are drawn from the BD.After that, the customer selects the desired goods (automatically 1 piece, if desired, can be changed) and the amount of the goods and the total amount is calculated with regard to the discount, which is also automatically drawn from the customer's number.3.2) After completing paragraph 3.1, the customer will press "to make a order" and in the form check the data for delivery, which are drawn from the BD, with the possibility of changing the phone, delivery address, email and type of receipt.If the contract is not verified, the verification form is opened, where the customer must enter the verification code.
If verified / after verification - the order is successful.The macros were also used.
TZ: Create an Internet store of smartphones in Access, with the possibility of authorization, personal office, access to site analytics, catalogue of goods, the possibility of ordering
Implementation: on the main page created: access to the personal office, after successful authorization, access to analytics and transition to the catalogue.1) The personal office:
1.1 ofpassing authorization, if successfully - transition to the possibilities of LK, otherwise - error
If successfully fulfilled 1.1, the customer may change the personal data, view all of his orders and view orders within a certain interval of dates.Analysis of the store:
2) Possibility of adding supplies
2.2, 2.3) Delivery and sales report with further possibility of displaying data in the schedule
2.4, 2.5, 2.6) Search by dates, customer search, product search
3) Catalog of goods, where you can see the photo of the goods and its characteristics.3.1)If the customer wants to make an order, he presses "form the order" and in the form chooses his number, after which the current date is automatically entered, with the possibility to manually change the data and data of the customer that are drawn from the BD.After that, the customer selects the desired goods (automatically 1 piece, if desired, can be changed) and the amount of the goods and the total amount is calculated with regard to the discount, which is also automatically drawn from the customer's number.3.2) After completing paragraph 3.1, the customer will press "to make a order" and in the form check the data for delivery, which are drawn from the BD, with the possibility of changing the phone, delivery address, email and type of receipt.If the contract is not verified, the verification form is opened, where the customer must enter the verification code.
If verified / after verification - the order is successful.The macros were also used.
Poltava 
Available for hire