Code for database Firma.mdb

Affiliates: 1,73 $ — how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 0
Refunds: 0

Uploaded: 09.10.2015
Content: text (449 symbols)

Description

Code for database Firma.mdb

Code for database Firma.mdb
Download the report on the database screen forms for free http://access.avorut.ru/1/firma/215_otchjot_dlja_firma.doc

Title: Firma.mdb

Link: http://access.avorut.ru/load/0-0-0-215-20

Additional information

Task for the database "Firm"
Option 1
Create a database "Firm" consisting of tables:
"Employees", containing the following information about the employees of some organization: the surname, name, employee code, telephone number, address.
"Premium" containing information on quarterly bonuses to employees during the year: employee code, quarter, amount.
Solve problems:
- determine the necessary links between the tables,
 - Develop forms for entering the necessary information,
- Display the names and names of employees of the firm, who received the award in the second quarter,
- Display the amounts of payments for each employee,
- display the data of both tables, indicating the subordination of one of them,
- output information on the results of any request for sampling, with a parameter, of the final request.
When solving problems, create the necessary tables, queries, forms and reports.


Option 2
1. Create a database.
2. Create a table that contains the following information about the employees of an organization:
Surname, name, employee code, telephone number, address (at least 5 entries).
3. Create a table containing information on quarterly bonuses to employees during the year: employee code, quarter, amount (7-10 records).
4. Link the tables.
5. Create a parametric query to display the names and names of employees of the firm that received the award in the quarter specified by the parameter.
6. Create a query to display the amount of payments for each employee.
7. Create a form that displays data from both tables.
8. Create a report on the first query, including the current date in the title.

Option 3
1. Create a database.
2. Create a table containing the following information about the employees of an organization: last name, first name, patronymic, employee code, telephone number, address (at least 10 entries).
3. For street names, create a directory table (at least 10 entries).
4. Create a table containing information on quarterly bonuses to employees during the year: employee, quarter, amount (not less than 10 entries).
5. Link the tables.
6. Create a query for the display. employees of the firm who received the award in the second quarter.
7. Create a query to display the amount of payments for each employee.
8. Create a form for displaying all the data of both tables, indicating the subordination of one of them. Take advantage of the automatic insertion of the current date.
9. Create a report showing the amount of payments for each employee, adding the name of the report to the note area.

Feedback

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)