A Civil Registry application to be developed in 2 weeks time for beta testing. It would incorporate the Excel spreadsheets that the clients use. As with working with the clients data, I would definitely need to work on naming conventions to standardize the data on the spreadsheets that was given to me.
Working with a list of Voter’s Information on an Excel spreadsheet. First issue I encountered : Street names are not standardized, as the data was added by multiple persons and since the Excel spreadsheet would allow almost anyone to enter any data as he/she interprets it on looking on the form that was given to them to input on the system. The result is a large volume of data full of inconsistencies and headaches.
Make tables for contact details, voters info and other juicy information.
Contact Detail Form
ContactID – PK for other tables I will add sometime if I get super heroic.
> last name / first name / middle name **added three separate fields, from 1 field – name
> house number/street / barangay – **added three separate fields, from 1 field – address
> tenure – owned / rented / living free (dropdown) **added new field
> sex (dropdown) **renamed to Gender
> birthdate **renamed to Date Of Birth
> Place Of Birth **added new field
> age (calculated by DOB) **will add code
> marital status – single / married / with a live-in partner / separated / widowed / divorced **added new field (dropdown)
> Citizenship **added new field
- What is a Microsoft Access? (rizqabachuri.wordpress.com)
- Microsoft Access 2010 Step by Step By Joan Lambert, Joyce Cox (4moreskills.com)
- Excel: Quick Tools for Every User (nerdywoman.wordpress.com)
- Infinite Skills’ “Advanced Microsoft Access 2013 Training Tutorial” Teaches Advanced Concepts in Database Functionality (virtual-strategy.com)
- New platform transforms Excel spreadsheets into working web apps in minutes, automatically (venturebeat.com)