Search this site
Embedded Files
Skip to main content
Skip to navigation
virtualmv/database management systems
Home
Personnel Database
MS-A1: Personnel Database
Entities [Attributes and Candidate Keys)
Personnel: Entities & Attributes
Attribute Properties
Employee Entity, Conceptual Design
Employee Entity & Data Types
MS-A2a: Create Employee Entity
MS-A2b: Employee Form
MS-A2c: Employee Form (Combo box)
MSA3a. Client Entity
MSA3b. Client Form - Controls
MSA3c. Client adding a list box
Foreign Keys
Relationships and Integrity
Employee -< Asset (1-m relationship)
MSA4a: Emp-<Asset (Establish Relationship)
MSA4b: Emp-<Asset: 1-many form
MSA5a.Client -< Project (1-m relationship)
MSA5b: Client-<Project: 1-many form
Timesheet: many-many relationship
MSA6a Timesheet: m-m relationship
MSA6b Timesheet: m-m Form
Carpark: 1-1 relationship
MSA7a Carpark: 1-1 relationship
Personnel: Complete ERD
Personnel: Adding a Code Table
Queries overview
Client Query
Reports - Overview
Client Report
Visual Basic Programming
A System Menu
Code Table
Scenarios
Flower Shop
Library
Library- Fines (1-many)
Library - Book Borrowing (many-many)
eBike sales
MS-Access
MS-Access naming conventions
Splitting a field
Adding a transparent image
Window view (Tabbed or overlapping)
Maintenance
Trouble shooting
Examples
Ticketing System
virtualmv/database management systems
Home
Personnel Database
MS-A1: Personnel Database
Entities [Attributes and Candidate Keys)
Personnel: Entities & Attributes
Attribute Properties
Employee Entity, Conceptual Design
Employee Entity & Data Types
MS-A2a: Create Employee Entity
MS-A2b: Employee Form
MS-A2c: Employee Form (Combo box)
MSA3a. Client Entity
MSA3b. Client Form - Controls
MSA3c. Client adding a list box
Foreign Keys
Relationships and Integrity
Employee -< Asset (1-m relationship)
MSA4a: Emp-<Asset (Establish Relationship)
MSA4b: Emp-<Asset: 1-many form
MSA5a.Client -< Project (1-m relationship)
MSA5b: Client-<Project: 1-many form
Timesheet: many-many relationship
MSA6a Timesheet: m-m relationship
MSA6b Timesheet: m-m Form
Carpark: 1-1 relationship
MSA7a Carpark: 1-1 relationship
Personnel: Complete ERD
Personnel: Adding a Code Table
Queries overview
Client Query
Reports - Overview
Client Report
Visual Basic Programming
A System Menu
Code Table
Scenarios
Flower Shop
Library
Library- Fines (1-many)
Library - Book Borrowing (many-many)
eBike sales
MS-Access
MS-Access naming conventions
Splitting a field
Adding a transparent image
Window view (Tabbed or overlapping)
Maintenance
Trouble shooting
Examples
Ticketing System
More
Home
Personnel Database
MS-A1: Personnel Database
Entities [Attributes and Candidate Keys)
Personnel: Entities & Attributes
Attribute Properties
Employee Entity, Conceptual Design
Employee Entity & Data Types
MS-A2a: Create Employee Entity
MS-A2b: Employee Form
MS-A2c: Employee Form (Combo box)
MSA3a. Client Entity
MSA3b. Client Form - Controls
MSA3c. Client adding a list box
Foreign Keys
Relationships and Integrity
Employee -< Asset (1-m relationship)
MSA4a: Emp-<Asset (Establish Relationship)
MSA4b: Emp-<Asset: 1-many form
MSA5a.Client -< Project (1-m relationship)
MSA5b: Client-<Project: 1-many form
Timesheet: many-many relationship
MSA6a Timesheet: m-m relationship
MSA6b Timesheet: m-m Form
Carpark: 1-1 relationship
MSA7a Carpark: 1-1 relationship
Personnel: Complete ERD
Personnel: Adding a Code Table
Queries overview
Client Query
Reports - Overview
Client Report
Visual Basic Programming
A System Menu
Code Table
Scenarios
Flower Shop
Library
Library- Fines (1-many)
Library - Book Borrowing (many-many)
eBike sales
MS-Access
MS-Access naming conventions
Splitting a field
Adding a transparent image
Window view (Tabbed or overlapping)
Maintenance
Trouble shooting
Examples
Ticketing System
Examples
Google Sites
Report abuse
Google Sites
Report abuse