Ready database access "Employment office"
Stages of individual self-employment:
1. Create a table structure by means of MS Access;
2. Create a data schema;
3. Develop screen forms for entering and viewing information;
4. Fill in the tables (10-15 records);
5. Develop and execute various types of queries to the database:
• for sample;
• using logical operations in the selection condition;
• with the parameter;
• cross request;
• for updating;
• to add;
• to delete;
• with calculated fields (if this is possible for your predefined area).
6. Develop various types of reports for printing data;
7. Organize work through a button form or headband. The database should look like a complete software product.
8. Draw up a documentary report on all stages of the work in accordance with the individual task.
3. Employment office
The activity of the bureau is organized as follows: bureau agents (Familiar, First Name, Middle Name, Contact Phone) are ready to look for employees for various employers and vacancies for job seekers of various profiles.
When applying to the customer´s employer office, its standard data (Enterprise name, Activity, Address, Phone) are recorded in the database. Each employer can offer several vacancies (Type of activity, Position, Required level of education, Qualification (if necessary), Wages).
When the client-applicant applies, his standard data (Surname, Name, Patronymic, Year of birth, Education, Position, Qualification, Estimated salary, Other data) is also fixed in the database.
For each fact of satisfaction of the interests of both parties is a transaction (Date of imprisonment, Commission (income of the bureau)). The applicant can conclude several transactions for different vacancies. The transaction involves one applicant, one vacancy, one bureau agent.
2.3.6. Employment agency
Description of the subject area
You work in an employment office. Your task is to track the financial side of the company.
The activities of your office are organized as follows:
Your office is ready to look for employees for various employers and vacancies for job seekers of various profiles. When you contact your employer client, its standard data (name, activity, address, phone) are recorded in the database. When referring to you client-applicant, its standard data (name, first name, patronymic, qualification, profession, other data) are also recorded in the database. For each fact of satisfying the interests of both parties, a document is drawn up. The document specifies the applicant, employer, position and commission (income of the bureau).
Employers (Employer´s code, Title, Activity, Address, Telephone).
Transactions (Applicant´s code, Employer´s code, Position, Commission).
Applicants (Applicant´s code, Family name, First name, Patronymic, Qualification, Type of activity, Other data, Estimated salary).
Development of the formulation of the problem. It turned out that the database does not accurately describe the work of the bureau. In the database only a transaction is fixed, and information on open vacancies is not stored. In addition, to automatically search for options, you need to maintain a directory of "activities". Add changes to the table structure that take into account these facts, and modify existing queries. Add new queries.