Closed

Access database to handle network documentation for several clients

I need an access database to help improve my documentation process for client networks. I have about 20 pages of documentation (please see the attached sample of the types of pages - not all pages are there, but it typifies the type of info / format I want - tables of data - the number of records can change, several of the same pages (machine details - I need to be able to make new pages for each PC on the network, etc), check boxes, etc.

I am looking for someone to rough out this database. - I know just enough about access to figure out how to add fields to tables, etc...

I initially thought I was going to get away with a single table - each record would be the data for a single client. I had someone make a database for that, and as I started filling in the extra fields needed, I found that there's hundreds of fields for each client's docs... but access only allows 255 fields / record! So I guess I have to do it right - each form is a table? I also thought being able to browse a single long form (like the attached PDF) would make it easy to jump from one part of a clients docs to another. is that possible? Or each table would have to be it's own form? (20 seperate forms just to deal with a single client's data) ! : (

I made these word docs nice looking (at least I think so), and wanted to be able to merge the data for a specific client into the word doc rather than use / remake the reports in the access report pages... and we did that on a small scale. But making this larger database, is it possible? I'd want to be able to print a single form that changes or all the forms for a single client easily.

thanks!

## Deliverables

1) Complete and fully-functional working access database with the ability for me to revise / update / edit the data and schema

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

the data mod field should have the date that any data on that page changed / was added. not for the entire document, just for that page (I was playing with the onchange property for each record related to that page - I wrote a tiny VB script that put todays date in that field when the specific field with the onchange was changed. seemed to work.

* * *This broadcast message was sent to all bidders on Tuesday Sep 5, 2006 9:04:13 AM:

I can't seem to add an attachment to this broadcast, so I posted the sample database I wanted to show you that I played with last night at the URL at the end of this It has just a few fields for a couple pages... certainly not all that I want, but what I think is the concept for entering data.

some things I'd like to have added (since I don't know how : )

a combo box? (pulldown) of all clients and the ability to add more clients.

the router info is a subform like users & shares. Not sure if that's OK (there's only 1 router per client, but I guess that a subform leaves it open to a 2nd router? so maybe that is OK?

there's a table with just client / that's the primary key to other tables. so you can't change / revise the client name - it's on all the other forms also? Should have an autonumber as the client number / primary key? I was trying to keep it simple and saw that doesn't work.

It still needs to be exported to word? I say word because I envision dropping mailmerge fields into the large word doc / word is easier to customize? but as I type this, I realize, that exporting the users - you can't export the table of data? and same for router - if there were 2 routers, my word doc only has 1 copy of the router page? Maybe I am moving away from word? Screw the nice appearance of word and make it a functional document? But all this data - will that max out some 255 limit somewhere - in the report or something?

[url removed, login to view]

Please let me know how this affects your quotes. Thanks!

## Platform

Windows xp / access 2003

Skills: Database Administration, Engineering, Microsoft Access, MySQL, Oracle, PHP, Software Architecture, Software Testing, SQL, Visual Foxpro

See more: what do u need to know about engineering, see my clients, schema update, new hire quotes, max network, i want to edit word document, i need to hire an engineering, i need an access database, how to type a legal document, how to format quotes, how to do reports, how do you make changes to a pdf document, how do i make changes in a pdf document, hire moving help, hire-me network, ability network, pdf to docs, how to type in a pdf document, how to copy from pdf to word, change pdf to word document, access subform, i want to know about engineering, engineering report format, small network, one night show

About the Employer:
( 1 review ) United States

Project ID: #3770595

12 freelancers are bidding on average $232 for this job

brsofts

See private message.

$84.15 USD in 15 days
(274 Reviews)
6.6
3mindssolutions

See private message.

$85 USD in 15 days
(15 Reviews)
4.5
shraddhamit

See private message.

$85 USD in 15 days
(8 Reviews)
4.2
MalachiConstant

See private message.

$68 USD in 15 days
(6 Reviews)
3.1
dsort

See private message.

$119 USD in 15 days
(2 Reviews)
2.8
NEXTSolutions

See private message.

$76.5 USD in 15 days
(4 Reviews)
1.7
sitcvw

See private message.

$38.25 USD in 15 days
(4 Reviews)
1.7
marekle

See private message.

$21.25 USD in 15 days
(5 Reviews)
1.3
samfeagle

See private message.

$42.5 USD in 15 days
(0 Reviews)
0.0
MindScapeInfTech

See private message.

$382.5 USD in 15 days
(0 Reviews)
0.0
lowfreq

See private message.

$425 USD in 15 days
(0 Reviews)
0.0
amconsulting

See private message.

$1360 USD in 15 days
(0 Reviews)
0.0