Project translated automatically. Log in or register, to view the original Option 10 The subject area is the staff department.Recommended basic tables and fields: units, stable units (or positions), employees; home address, date of birth, position, date of registration, education, name of units, type of units (check, department, brigade, etc.)), the name of the position, the post, the vacation, etc.The task 2.Create forms in MS Access.2.1 Based on the existing tables of your database to create: − autofound; − form that reflects the data from several tables (5-7 fields), as well as containing a photo (image) in the form headline, date and time in notes, calculated field (with calculation) in the data field.The task 3.Create requests in MS Access.3.1 Using the designer mode, develop a request for a data sample with a simple criterion.3.2 Using the designer mode, develop a request for a data sample with a complex criterion (using logical conditions and, or).3.3 When using the expression maker, calculate the value of the records of one of the fields in the BD table.3.4 Calculate the final values of one of the fields using the final queries.The task 4.Create reports in MS Access.4.1 Develop a multi-table data report containing transparent information about the data stored in your database.Compulsory screenshots2 to tasks 1-4 (insert into the text of the control work during the performance of tasks, not to the end or beginning!): a) ready tables of the database in the designer mode and in the table mode (1 task); b) the data scheme after the connections set (to see the types of connections) (1 task); c) the automatic form in the form mode (2 task); d) the ready form according to the data of several tables in the designer mode and the design mode (or form) (the form screenshot in the designer mode must also contain a properties window and a field with calculation in readable form) (2 task); e) the design mode requests and the results of the requests in the table mode (3 task); e) the report in the report presentation or preliminary viewing mode (4 task).Note: instructions for the performance of tasks see.Theoretical information by section.Examples of registration are in Annex B.All the requirements for this control work are found in the inserted file!You have to do 10 options, tasks from the first section (I copied them here, the rest of the sections do not have to do!)

Proposals 1 Rejected 2

Rasul Ramazanov

Winning proposal

29 0

Projects 24
Rating -
Rating 226

Budget: 300 UAH Deadline: 1 day

Good day ,
I'm interested in your order, I'll be happy to fulfill in the shortest time, in addition to quality. We have already been working with such tasks, so there will be no problems with the performance. Deadlines and prices are discussed. There are no questions for the time, it’s clear. I can start right now.
I look forward to your answer.

Andrey Ivanov

16 1

Projects 16
Rating -
Rating 197

Budget: 500 UAH Deadline: 2 days

Many of these works have been performed. Examples can be seen in the portfolio. I do it as quickly and quality as possible. The development environment - Access 2016

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Databases & SQL

Updating Joomla version

Content Management Systems 23 proposals 13:38

16 USD
Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Gaming Apps 18 proposals 3 August

Not specified
Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 20 proposals 31 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 42 proposals 27 July

179 USD

Viktoriya Polikarpova
Velikii Novgorod (Novgorod), Russia

Projects 1
Rating -
Rating 32

Rasul Ramazanov

Rasul Ramazanov

Proposals are currently absent

Andrey Ivanov

Current freelance projects in the category Databases & SQL

Updating Joomla version

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities