Simple Database front-end app for Android.

General information for the business: We collect and distribute monetary data
Kind of development: New program from scratch
Description of requirements/functionality: The app will be in essence a way of drawing out data from a database. The database is very simple, currently it contains only 3 columns although it does contain a large amount of data; around 300k lines and growing.

I want the front end of the app to look professional, and work very simply.

Once an end user opens the app they will identify a company or person to look up (mainly through the search bar but there are some other ideas we would like to discuss) and I want the app to return a correlating value from the database.

All of the search values will be strings or text and all of the values that the database could return will be integers.

On top of this databasing function I want the app to do some very basic equations i.e. is the returned value higher or lower than X (X being a value set by me). And then change colour scheme depending on if the value is true or false.

The back end of the app is open to ideas, functionally I need the app to access a database and do some simple indexing. Where the database is stored is up for discussion, as is how the data is drawn from the database. I would approach the app by storing the database as an SQL database and then using some simple PHP scripts to access the data, if you would do it differently please elaborate on submission of your proposal.

As an added extra, it would be a bonus if you could work with a bar code scanner and/or GPS locater. Any experience working with either of these features of android would be a big boost, we may be looking to work these into the app.


Extra notes:
The App is required to run on android.
I will be making a final decision on this on the 11th, so excuse me if I do not get back to you before then.