Closed

Google Maps Add-In for Existing Access 2007 Database

Create a module for an existing ACCESS 2007 database. System is Windows-based (MAC compatibility is not required).

STEP 1:

a. The user inputs the data relative to the individual property record

b. When the command labeled DONE is selected coding determines if property was previously mapped. If it has not, a form (MAP PANE) opens.

Database fields (i.e., Street No., Street, City, Parish / County, State, Zip Code) are used to create the google map via the map search engine.

c. Once property is accurately located the geo-coordinates are obtained and recorded in the database for future use in mapping. (Table and field names are already present in Dbase and can be supplied later). NOTE: Map function will allow user to edit or change mapping results pulled from the database before saving; i.e., user will be able to manipulate push-pin to accurately locate property (reverse geocode). User should be allowed to verify final ‘marking’ of the location before the geo-coordinates are recorded in the database.

STEP 2: USER SEARCHES DATABASE FOR VARIOUS PROPERTIES TO BE GROUP-MAPPED

a. MAP IT! Command: MAP PANE form opens and selected records are group-mapped based on previously recorded geo-coordinates (if property was not previously mapped, have message box: Example: Record No 1365 was not mapped. Do you want to proceed with group mapping or end and map the individual record?” or something to this effect.)

b. Push-pins are labeled (Ex. 1, 2, 3, 4 or A, B, C, etc.)

c. MAP PANE form now shows a legend down its right side reflecting the referenced data points

(Example: Push-Pin 1 Label: 4520 Sharptop Avenue, $[url removed, login to view]; Push-Pin 2 Label: 4523 Sharptop Avenue, $[url removed, login to view], etc. (Push-pin labels are based on data in database relative to the selected record.)

d. Command buttons on MAP PANE form allow the user to do the following:

• View Map as Street View

• View Map as Photos View (replicate or use current Google capability)

• View Map as Aerial View (replicate or use current Google capability)

• Zoom In / Out

• Print final map to PDF (Adobe)

• Close Map Pane

See the attachment for more information and some screenshots.

Skills: Microsoft Access

See more: google maps access 2007, access 2007 google maps, access 2007 map add, access 2007 google map, access 2007 maps, maps access 2007, google map access 2007, access google maps example, add google map access database, access google map, add google maps access database, add google map access form, add map access 2007, add google maps access form, google maps access database, add google maps access 2007, add map access, google maps add access, access map add, google map access 2007 form, access 2007 google map example, map access 2007, access 2007 database mapping, map add access, access google maps add

About the Employer:
( 1 review ) Baton Rouge, United States

Project ID: #1089288

3 freelancers are bidding on average $383 for this job

AFRNGROUP

Please see PM.

$350 USD in 14 days
(0 Reviews)
0.0
ZhiZhang

hi I did simlar project before. I have ten years experience on MS Access. I have done ten Access DB for client in 2010 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. More

$500 USD in 5 days
(0 Reviews)
0.0
SalmanSabir

Hi I did simlar project before.I have experience on working with Google Map with Access..

$300 USD in 15 days
(0 Reviews)
0.0