Please help me with my dissertation!
Discussion
Hi Guys,
Need some advice if you don't mind.
I have created a database in Access (As per my 'Clients' requirements) as part of my dissertation. I now need to create an interface to this so that it can be used over the intranet/internet.
I need to create a login screen, a couple of input screens, and a variety of reports that need to be run.
The system tracks Assets (in this case Computer equipment). I need to be able to query the database in a variety of ways (either by machine, user or department).
In my "Machine" table I have the following entities:
Machine_Id (Primary Key)
Type_Id -> Links to Type Table
User_Id -> Links to User Table (Which also stores the Dept/Site_Id of the user.
Dept/Site_Id -> Links to Dept/Site Table
Serial Number
etc
I'd like to set it up so that if I enter in a user_Id it populates the Dept/Site_Id with whatever has been stored in the User_Id table.
Does this make sense???
Whats the best way to go about this?? I'm not really a programmer!
To make it even more complicated the login / search / update screens need to be accessed via both a pda interface and a normal desktop/laptop. There is no requirement for reports to be run on the pda though. (Could mean 2 different interfaces?)
Thank You all SO much!
Phill
Need some advice if you don't mind.
I have created a database in Access (As per my 'Clients' requirements) as part of my dissertation. I now need to create an interface to this so that it can be used over the intranet/internet.
I need to create a login screen, a couple of input screens, and a variety of reports that need to be run.
The system tracks Assets (in this case Computer equipment). I need to be able to query the database in a variety of ways (either by machine, user or department).
In my "Machine" table I have the following entities:
Machine_Id (Primary Key)
Type_Id -> Links to Type Table
User_Id -> Links to User Table (Which also stores the Dept/Site_Id of the user.
Dept/Site_Id -> Links to Dept/Site Table
Serial Number
etc
I'd like to set it up so that if I enter in a user_Id it populates the Dept/Site_Id with whatever has been stored in the User_Id table.
Does this make sense???
Whats the best way to go about this?? I'm not really a programmer!
To make it even more complicated the login / search / update screens need to be accessed via both a pda interface and a normal desktop/laptop. There is no requirement for reports to be run on the pda though. (Could mean 2 different interfaces?)
Thank You all SO much!
Phill
Try here,
www.vbaexpress.com, some very good VBA programmers on there, its easy to learn.
But as has been said, why do a programming project if you're not a programmer???
www.vbaexpress.com, some very good VBA programmers on there, its easy to learn.
But as has been said, why do a programming project if you're not a programmer???
greenv8s said:
I'm not really a programmer!
In that case you shouldn't have picked a programming job for your dissertation!
Had to! I'm studying BSc (Hons) Business Information Technology. Had to run a project from the initiation through to the development to a product. My skills lay in Project management not development so hopefully I should pick up more marks with the documentatin then the programming!
It's a while since I used access but i think you can use php to interface with it, try here PHP Builder it helped me loads with my dissertation
Surely the best way to do this would be through web access? Only need to write one interface (web pages) and can choose a lang that suits you - from ASP (VB) to JSP (Java) to PHP. All can access Access. I'd put the database functionality into stored procedures too rather than wireing them into the web pages (good for maintenance, reusability and security).
If you need to graph reports then there are PHP modules that will do that or you can 'buy' some commercial software.
From experience I'd have avoided using Access and used something proper e.g. MySQL or Postgres (unless you have access to Oracle or MSSQL. Access is very limited.
Sounds like a day's worth of codeing for a competent/experienced bod or a month of pain for a non-coder
If you need to graph reports then there are PHP modules that will do that or you can 'buy' some commercial software.
From experience I'd have avoided using Access and used something proper e.g. MySQL or Postgres (unless you have access to Oracle or MSSQL. Access is very limited.
Sounds like a day's worth of codeing for a competent/experienced bod or a month of pain for a non-coder
Plus I think you can download it for free here http://msdn.microsoft.com/vstudio/express/
I have started mocking up the database in access for you so email me if you want it.
>> Edited by maddog-uk on Thursday 9th February 16:54
I have started mocking up the database in access for you so email me if you want it.
>> Edited by maddog-uk on Thursday 9th February 16:54
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff