Veterinary station (supervisor in MS Access 2003)
Replenishment date: 19.01.2008
Content: 032.rar (496.77 KB)
️Automatic issue of goods ✔️
️Automatic issue of goods ✔️
Sales:
1
Refunds:
0
Reviews:
0
Views:
429
Seller discounts
for all goods
for all goods
The goods are given a discount for regular customers.
If the total amount of purchases from a VSbest seller is more than:
If the total amount of purchases from a VSbest seller is more than:
the discount is: 3%
Description
The task. Create a database of the veterinary station.
Indicative composing tables: "Plan of veterinary work", "Serviced farms", "Work performed".
The total number of fields in the database is at least 20, the total number of records is at least 30.
Create reports: "List of farms planned for the next week" (query - conditional sample); "The volume of work performed in each farm" (final request); "Fulfillment of the plan for farms for a given date" (parametric query); "Distribution of the number of examined animals by day of the week" (cross-reference).
Indicative composing tables: "Plan of veterinary work", "Serviced farms", "Work performed".
The total number of fields in the database is at least 20, the total number of records is at least 30.
Create reports: "List of farms planned for the next week" (query - conditional sample); "The volume of work performed in each farm" (final request); "Fulfillment of the plan for farms for a given date" (parametric query); "Distribution of the number of examined animals by day of the week" (cross-reference).
Additional Information
The database is organized in Microsoft Office Access 2003CONTENTS 2
PURPOSE AND OBJECTIVES OF DB DESIGN ON THE THEME OF INDIVIDUAL TASK 3
SUBJECT DIAGRAM 3
ESSENCE-LINK MODEL 4
DATA SCHEME IN ACCESS (RELATION MODEL) 5
DESIGNERS OF TABLES AND INQUIRIES, REPORTS ON INQUIRIES 5
"LIST OF FACILITIES PLANNED FOR THE NEXT WEEK". 5
"SCOPE OF WORK PERFORMED IN EACH FARM" 6
"IMPLEMENTATION OF THE FARMING PLAN FOR THE SPECIFIED NUMBER" 7
"DISTRIBUTION OF THE NUMBER OF EXAMINED ANIMALS BY DAY OF THE WEEK" 8
FORMS: MAIN AND SUBSIDIARY. DESCRIPTION OF NAVIGATION AND OPERATING OPPORTUNITIES 9
DEVELOPMENT OF MASTERS, OTHER CONTROL ELEMENTS 11
PROGRAM LISTING 11
LISTING FOR FORM "MAIN FORM" 11
LISTING OF THE "PROPERTY FORM" FORM 13
LISTING OF THE FORM OF THE "FARM" 14
LISTING FORM "MASTER OF FIELDS" 15
CONCLUSION 16