Bd Auto Service -2.mdb

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

Uploaded: 13.09.2016
Content: Автосервис 2003.rar (207,41 kB)

Description

Bd Auto Service -2.mdb Bd Auto Service -2.mdb

Bd Auto Service -2.mdb

Download the report on the database screen forms for free http://access.avorut.ru/1/259_avtoservis/259_otchjot_bd_avtoservis.doc

Note: If the yellow Message Bar appears when you open a file, you must click on "Enable Content" button.

Additional information

Task for the database access "Auto Service".

Option 36
Theme: car service information system
Description of the information system:
The information system is designed to store information about the work of the car service. The information system should contain the following information:
- Information on services (name of service, price);
- information about the car mechanic of the center (personnel number, passport data, category);
- about cars (GosNomer, Mark, driver´s name, Color, etc.).
In the information system it is necessary to store information about the payment for each service (the date of the service, the master number of the master, what service is provided, and the number of the machine being repaired).
The output documents of the information system of the car-care center:
- salary statement for each master;
- report on the costs of customers.


1. Create tables by defining properties for each field in the table.
2. Establish links between tables.
3. Create delete requests, add and update rows
4. Create two forms: simple (based on one table) and complex-subordinate (based on two tables, united by a one-to-many relationship). Place in the forms various control elements: fields with drop-down lists, buttons for launching queries and forms, and so on.

Option 17
Create a database "Auto Service".
The database should contain the following information:
information on services (name of service, price), information on car mechanic center (personnel number, passport data, category), about cars (GosNomer, Mark, driver´s name, Color, etc.).
In the database put information about the payment for each service (the date of the service, the master number of the master, what service is provided, the number of the machine being repaired). Output information about the salary of each master and the costs of customers.

The task "Designing a relational database and its implementation in an Access DBMS
General requirements
1. Design a database using any design method. Determine the number, structure, and relationships between tables.
2. Create tables by defining properties for each field in the table. Ensure data consistency (foreign key requirement) by creating fields with substitution.
3. Establish links between the tables.
4. Create multiple queries:
1) Three sampling requests with complex selection criteria;
2) Three queries using group operations and statistical SQL functions;
3) Parametric query;
4) Cross-Request.
5. Create two forms: simple (based on one table) and complex-subordinate (based on two tables, united by a one-to-many relationship). Place in the forms various control elements: fields with drop-down lists, buttons for launching queries and forms, and so on.

Option 14
Create a database "Auto Service". The database should contain the following information: information about the services provided (name of service, price), information on car mechanics in the center (personnel number, passport data, category). In the database put information about the payment for each service (the date of the service, the master number of the master, what service is provided, the number of the machine being repaired). Output information about the salary of each master and the costs of customers.

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.)