Jas
Member
Registered: 13th Oct 04
Location: Mid Wales
User status: Offline
|
Basically I work for a company who fit telematic units into vehicles
Im on the support side of things,
I've been given task of making an easy to access and search database
We needs to have each company on there, each vehicle with the following
IMEI, SIM NUMBER, REGISTRATION, GREEN BAND
and I want to be able to make notes..
whats the best way of doing this, what program?
|
ed
Member
Registered: 10th Sep 03
User status: Offline
|
Make it a web service so that you can access it from a web browser, either just on your companies local network or online.
Though to do this yourself might be a bit tricky if you're not up to a bit of programming...
|
Jas
Member
Registered: 13th Oct 04
Location: Mid Wales
User status: Offline
|
I dont want nothing to crazy complicated, we have a large online tracking database.
We have it all on excel at the minute..
just want to be able to have it neat and tidy for mine or the managers use
access etc?
|
VrsTurbo
Premium Member
Registered: 8th Jun 10
User status: Offline
|
do you have infopath?
|
Jas
Member
Registered: 13th Oct 04
Location: Mid Wales
User status: Offline
|
no is it any good, I just want to have say
40 customer
each customer has x ammount of vehicles I find which vehicle and find the vehicle details
s
|
Jas
Member
Registered: 13th Oct 04
Location: Mid Wales
User status: Offline
|
Or search a vehicle reg and it all comes up
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
Personally i would look into an off the shelf database system (in which case search google) as doing something yourself (either web based as ed said - would require PHP/ASP+SQL+HTML/CSS+WAMP/Hosting, or software based - .NET+Access/SQL) would require knowledge of programming if it's to support multiple users accessing it at any one time.
If you're wanting to get someone in to do it, say a web based system, then you're looking at £20-35p/h for an individual web developer (agencies will happily charge double/triple that) to do it and it's around 1-2hrs work to get a very basic view/search/add/delete/edit system going. Obviously the hours will start piling on if you want user accounts/logins, user tracking etc.
|
VrsTurbo
Premium Member
Registered: 8th Jun 10
User status: Offline
|
Infopath you can connect to an SQL database and make forms very easy.
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
If you have sharepoint, could always use access to create a web based database that runs from using sharepoint services. Essentially you just create you db in access 2010 and then publish to web. What your after would take half hour imo and allows multiple user access.
|
VrsTurbo
Premium Member
Registered: 8th Jun 10
User status: Offline
|
If your a techie wouldnt take too long to read about php and a simple mysql database.
|
Andrew
Member
Registered: 5th May 04
Location: Skoda Octavia Estate, Ford Puma
User status: Offline
|
MS Access should do the job for you
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
quote:
Originally posted by Andrew
MS Access should do the job for you
Would require you to use VB(A) to knock up the form (could be wrong, haven't used access since i was about 15 in IT at school) and then you'd have to try and keep it sync between multiple access databases or have a shared access db on a shared drive somewhere. I think Access would be the messiest option.
Infopath or Sharepoint would be good option, but if you haven't got it as part of your office collection/licensing then it's one of the most costly solutions. Inquire your IT department about it though as Infopath and Sharepoint are fairly straight forward to use.
|
Andrew
Member
Registered: 5th May 04
Location: Skoda Octavia Estate, Ford Puma
User status: Offline
|
Sharepoint is another option. Requires a little knowledge on SQL for installation and config.
|
Rob_Quads
Member
Registered: 29th Mar 01
Location: southampton
User status: Offline
|
Depends where your skills are.
With a mysql and a bit of php coding you could have it all sorted
Access is another route.
[Edited on 05-08-2010 by Rob_Quads]
|
Jas
Member
Registered: 13th Oct 04
Location: Mid Wales
User status: Offline
|
You're looking waaay to advanced guys..
Its for my personal use..
I mean I could easily use excel for each customer
Its just so that I can keep track of all the boring details that have to be kept
I dont need them online etc.. simple laptop..
access I haven't used since I was 18 ish but im sure from what I remember would do trick?
Id have to read tutorials etc lol
|
Dom
Member
Registered: 13th Sep 03
User status: Offline
|
If it's for personnel use then Excel spreadsheet, jobs a goodun'. If you need to search, Ctrl+F 
Edit - A database is pointless if it's for one person
[Edited on 05-08-2010 by Dom]
|
Rob_Quads
Member
Registered: 29th Mar 01
Location: southampton
User status: Offline
|
If its just you a spreadsheet with lots of tabs - job done - Depending on the confidentiality maybe even google docs and then you can access it from anywhere if you need.
[Edited on 05-08-2010 by Rob_Quads]
|
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
quote:
Originally posted by Neo
If you have sharepoint, could always use access to create a web based database that runs from using sharepoint services.
Why not just create it in Sharepoint from the begining?
That would be very easy imo!
Jas, if you have access to sharepoint, I could create something for you, export it and email you the template for your guys to import.
Less than 10 mins work 
[Edited on 05-08-2010 by Bart]
|
