Access Database Cleanup

• Status: Closed
• Prize: $30
• Entries Received: 5
• Winner: MuradMurad

Winner

Contest Brief

We have an access database that needs some cleanup.

Change structure from this:
Bob Smith | Name
Pacific Inc | Company
123 Main Street | Address
San Diego, CA | City/State
90001 | Zip
bob@pacific.com | Email

To this:
FirstName | LastName | Company | Address | City | State | Zip | Email
Bob | Smith | Pacific Inc | 123 Main Street | San Diego | CA | 90001 | bob@pacific.com

See this video for more information: http://screencast.com/t/HJPERntf2l
As mentioned in the video, remove html code and separate first/last names.
Attached is the database.

Deadline is 2/19/2014 at 1pm PST. The first person to cleanup the data, and prove to us it is complete, will be awarded.

Recommended Skills

• Microsoft Access
• MySQL
• SQL