IT Audit (1 Viewer)

I have developed with some assistance a small DB that allows users to record IT information:

Users
Hardware
Software
License Agreements etc........

DB opens at login form (bypass by hitting the shift key if you wish).

User Name: Administrator
Password: 123

Some work might be required with the form navigation buttons as I copied and pasted so even code may not be associated.

The main form of interest is frmDeskSetup. Select search criteria and relevant information is displayed.
Hope others can make use of this.

Please feel free to report any design floors.
Phil.

Update

I am in the process of improving the sample DB. I will post the much improved version when complete.
Phil.

scouser said:

I have developed with some assistance a small DB that allows users to record IT information:

Users
Hardware
Software
License Agreements etc........

DB opens at login form (bypass by hitting the shift key if you wish).

User Name: Administrator
Password: 123

Some work might be required with the form navigation buttons as I copied and pasted so even code may not be associated.

The main form of interest is frmDeskSetup. Select search criteria and relevant information is displayed.
Hope others can make use of this.

Please feel free to report any design floors.
Phil.

Click to expand...

Hello Phil,

Thanks for posting your DB, it's a realy nice tool to use...
Can you tell me more about the security level...

Greetz KeLsO

Update

The updated version is near completion (sorry for the delay).
I will expalin the new functionality when I post the DB.
Regards,
Phil.

Audit Database

Please find attached the updated version of the Audit database. I have attached a word document to explain the purpose of the database. I have tried to implement best practice regards normalisation, however it is not perfect!

Improvements:

1) New Switchboard

2) AssetID Tracking:
I have added 3 new forms that allow users to add AssetID's for:
Computers
Hardware (printers etc...)
Software

I have done it this way as not all equipment requires an assetID. Normalisation is a little flawed here!! Repeated data for Description / Make / Model / Serial#

3) Software Allocation
When allocating software (frmComputerSoftwareAllocation) only the related software license is displayed for the SotwareID selected.

Issue: The license key combo displays the license key, the number of licences purchased and the number of licences that are available but only for software that has an allocation. cboLicenseNum recieves values from qrycboLicenseLookup This query comprises tblLicenseDetails & qryAllocatedSoftwareLicenseAvailability

qryAllocatedSoftwareLicenseAvailability was intended for a report to display software license allocation details. However I was unable to develop a query that showed all software / license details + allocation & availability. The query only displays data for software / licenses that have an allocation.

Therefore if the software table has 1000 entries qryAllocatedSoftwareLicenseAvailability will only display data for the software that has an allocation. I would like a query that lists ALL software irrespective of its status. If it has no allocation then availability should equal the number of license purchased. (hope thyat makes sense).

Any questions feel free to post.

If any of you gurus have time to look at the Software / License allocation issue and provide a solution it would be very much appreciated.

I hope this of use to somebody
Regards,
Phil.

Note: The database(s) were created using access 2000 file format.

Menu Update

I have modified the main menu slightly. I have included revised instructions.
Regards,
Phil.