Thu., September 28th, 2023

My Life is a Laptop

Project: Database Application

amazing grace cherokee indian mike and tom eat snacks prada l'homme perfume prada fashion show prada europe website compra followers instagram valentino woodbury commons pleasant hawaiian holidays aaa carlucci menu my instagram followers mosaic tampa fl leopard prada bag fendi prada prada chunky heels cardinal home prada bags 2020 yacht club uniforms instagram 3000 followers tshirt prada usa outlet online bedding outlet near me vinyl siding sales luxe store small fruit with spikes instagram followers audit prada slip ons pantone extended gamut prada frame prada sungless instagram followers legit williams chicken prada gold sunglasses prada arca alfonso prada gucci bags official website chatgpt questions followers pro instagram prada sport glasses mike prada chatgpt copyright prada sports bra genevive jewelry long chin beard chatgpt vpn women's prada eyewear prada nylon bags used prada sunglasses large bulletin board app chatgpt prada mens briefcase tamagotchi new designer glasses prada prada tessuto nylon native american amazing grace prada 90s chatgpt 打不开 zhou feng chen south colby post office delta 12 10 kayak boat captain shirts prada sunglasse prada leather purse light up light up as if you have a choice lyrics sheet cork board leona lewisrun lyrics prada portland chatgpt search engine prada infusion captain epaulettes rosemont restaurants and bars prada baguette bags chatgpt license instagram 5k followers instagram live followers prada mini saffiano followers gratis instagram captains hat near me instagram followers 5000 prada background cinnabon slogan grey prada ranbutan lentes prada precio

Annotated Artifact
Target Audience

Company employees

Project Scope

The first snapshot (far left below) illustrates the initial data model I created, using MS Visio, prior to revamping the database for a non-profit organization. A data model was created as part of the initial phase to upgrading the database tables and queries. The data model sets the framework of the database and ensures the data is normalized for maximum efficiency. Proper normalization ensures functional dependency and allows one to anticipate potential issues when designing a relational database.

The main function of this database is to track artist information and assign them a booth (snapshot in the middle below) for the organization's biannual art festivals. At the client's request, I redesigned and implemented the necessary changes to ensure its full functionality. While some of the forms and initial interface design remained intact, new tables, queries, reports and forms were created implementing basic VBA code. The most challenging part of this project was updating the SQL code for the maps resembling the streets and booth locations assigned to each artist.

After completely revamping the tables, queries and reports, a user manual (snapshot on far right below) was designed and developed to aid training future employees. This manual serves both as a training manual and reference guide. It contains step-by-step instructions and frequently asked questions on the main forms of the application. It enables anyone with little or no Access database experience to navigate the database and create basic queries and reports with relative ease.

  • Revamped the database application with over 5000 records.
  • Updated and/or create new tables, and redesign all forms and reports.
  • Created new simple to complex queries and reports.
  • Archived old records and migrate data to new tables.
  • Tested the database and install at the client site.
  • Trained employees onsite.
  • Designed a User Manual for future employees.
  • Provided ongoing technical support onsite and via phone.

This project took several months to complete. Initially, it was fairly large in scope for a single person to tackle. However, my assiduous efforts enabled me to meet and exceed the client's needs.

As of 2015, the database application is still running and used to manage all of the organization's events, contacts, and mailings. Currently, maintaining the database on an on call basis.

Role Database Designer and Developer
Sample Screenshot(s) Data Model in MS Visio Screenshot of Maps SAH User Guide