Home  |  Contact Me  

Microsoft Office Applications  |  Macromedia Fireworks  |  Macomedia Dreamweaver  |  Adobe Illustrator   | VB.NET | Database Programming | Self-Study |

Skills Learned

Database concepts and utilization of database technology. Types of database storage, specifically flat-file, relational, hierarchical, and network. Design and manipulation of relational databases emphasized. Structured Query Language (SQL) and Microsoft Visual Basic for Applications. Hands-on  use of the database package Access 2003. Network, web development, and security issues addressed. Can use, design, create, customize, and administer database applications.

Basic Database Terminology

Designing and creating relational databases

Structured Query Language (SQL)

Multiple File retrievals

Update, Delete, and Insert operations

Normalization in database design

Writing event-driven code

Database-driven web pages

Shared data: security and integrity issues

Backup/recovery methods

Database administration


Project
PeopleTrak
This project is a human resources database. Complete with a main screen, forms, reports, queries and macros. The Employee allows editing of records, the other forms are read only with no editing.

The project consists of four tables
Relationships
Main Screen
Employee Database

This is the only form in the project that writes to record. It contains a calculated control to calculate total pay.
Employee Directory

This form is used for the lookup of employees. Personal information such as Salary, Social Security Number and pay information is not shown.
Staff Database

Form used by Managers Only. To view infomation pertaining to their staff.

Phone Number Lookup

This form is used to look up employee phone numbers. The user can type in one letter for the last name and get a retrieve of last names that start with that letter. In the code on the search button, an SQL statement is dimensioned as a string variable. The SQL statement pulls records for anything "LIKE" the letter entered in the text box.
Employee Directory Report

This report is a listing of the Employee directory, with the same information that can be found the Directory Form. It is grouped by office location (Location table), sorted by Last Name and has a total count of all employees.
Salary Report

The salary Report is broken out by Department. It has calculated fields for Salary + Bonus (Total Pay) for each employee. There are sums of the Salary, Bonus and total pay for each Department and a grand total for the entire company.

** Please note that this is not the completed version of the PeopleTrack database. It is a project in progress.**