© um.co.ua -

1

  1. 1
  2. 1
  3. 1
  4. 1
  5. 1
  6. 1

2-5- 034700 , 032001

, . ̳ .

- .

- MS Access.

, .

.

:

() . .

Access, , , , .

Access, ' .

. SQL.

:

1. .

2. .

3. .

4. Access.

5. SQL.

1. . : , . , , ' ( , ) (, ). : , . ³ . . , .

1

1

1
PersonID
Name ϲ
Department ,
Institute ()
Birth
Place ̳
Address
Phone
Education
Year г
Speciality
Picture OLE
DegreeYes ( / )
Degree
Rank
Post
Comment Memo
Passport
PassportDate
Region
WorkBegin
WorkEnd
Work
WorkPlace
WorkAddress
WorkPhone
Reason
Penalty Memo ³
Rewards Memo ³

2. . , , . . , . . , '. , . ϳ , .

2

2

1
JoblessID
LastName
FirstName '
Patronymic
Age
Passport
PassportDate
Region
Address
Phone
Picture OLE
StudyPlace
StudyAddress
StudyType ( ..)
Registrar
RegDate
Payment
Experience ( / )
Comment Memo
ArchivesDate
Archivist
JobID
JobType (, .)
JobName
JobGiver
Place
Mobile
District ,
Money
More Memo

3. . - , 50000 , . , . - ( ), , , . 2002 . - (13 ), , , , , .

3

3

1
INN
LastName
FirstName '
Patronymic
Document ,
Serial
Number
Date
Region
Born
Picture OLE
DateTax
NumberTax
Address
District ,
DistrictTax ,
TaxNumber
Enterprise ,
InnEnterprise
AddressWorks
Chief ϲ
Phone '
SumAll
SumTax
SumPension ³
ExemptType
Exempt
Comment Memo

4. .

-, . 볺 - . , - . .

³ . , . , . 볺, , , .

4

4

1
CustomerID
CustomerType (. / . )
CustomerFio ϲ ( . )
CustomerName ( . )
CustomerInn ( . )
Chief ( . )
Phone
Address
Bank ( . )
District
Discont
MasterID
MasterFio ϲ
Experience
Defect
RepairAll
TypeID
Type (, .)
Country
Company Գ -
Picture OLE
Age ³
DateStart
DateStop
Summa
Period
Guarantee ( / )
Comment Memo

5. .

. . . . ³ , , .

5

5

1
OwnerID
OwnerType (. / . )
OwnerFio ϲ ( . )
OwnerName
OwnerInn
Chief
Phone
Address
District
Number
Brand
Model
BodyID
EngineID
BodyModel
Color
Volume '
Comment Memo
Power ..
Helm ( / )
Drive
Year г
TypeBody (, )
DrivingAway
DateAway
DateReturn
DateSee
Inspector ϲ ,
YearTax г
YearNumber
Work
Distance
Okey
Reason Memo ,

6. . . ʳ .

. .

, . , , .

- , , .

6

6

1
ClientID
LastName
FirstName ' 볺
Patronymic
Document ,
Serial
Number
Date
Region
Born
Picture OLE
Pasport
RouteID
RouteName
Country
Period
Worker
Cost
Exempt
Return
DateStart
Town
Count
Hotel
StartDate
StopDate
Type (* * * * * * *)
Comment Memo



| 2