Anyone got an access DB to keep track...

[Herriot]

...of software. I am responsible for keeping a track of software we have installed. At present this is on a spreadsheet. While it works and provides the information I need it is cumbersome and takes a bit of time. I cannot really spend any money on buying an expensive program that searches the network for example. All I really need is a DB that enables me to enter relevent data (name/licence number/qty allowed to install etc). Any help would be gratefully received.

Regards.

Herriot

 

[Guest_imported]

Hi,

The hard part of sending out databases is in the creating and implementing of them.

Being a database designer for 10 years, the creation, modifications, testing and finally implementing of a database is the DBA's initial nightmare. Why? In most cases, the common end-user has no idea what he or she really wants. Once they do decide, they hand us a list of what the DB should contain, its functions and capabilities.

Providing the DBA has a good working relationship with the customer, the DBA should have an idea of what a database should do for the customer and design it to make it as friendly user as possible.

The best reasons in creating and implementing a database are if: The data is reocurring (input/output)for business reporting, the information contained influences the operational activities of said business, and that the data support the business financial gains/losses.

If so, you might want to familiarize yourself with Access (any version 97 or higher),SQL, FoxPro etc., that makes easy importing of the Excel data. Within Access, this can be done, by first creating tables to import the data to, create forms allowing for data entry, queries to produce specific reports and allow selected reports to be sent to appropriate parties that you do business with as an attachment in WORD, EXCEL or another attached format.

HTH