Topics Search

Table Design For Software Asset Management

Table Design For Software Asset Management
Views: 3
I am trying to design a software Asset Management database to keep track of our company's software licenses. Does anyone know of any template or somewhere to give me an idea of how to approach this?

I would normally purchase an already made, but the cost is too expensive and the software comes with too many bells and whistles that we wont use.

Basically I just want a repository to hold:

1) Name of software
2) Type of Licenses
3) Number of Licenses Available and # Remaining
4) What Building the software is in ( I dont need to assign software keys to a speicific computer but a building is sufficent.

Anyone can point me anywhere? Im kind of at a loss.

its the checking in and checking out of licenses that are throwing me off
Sponsored Links:

More topics

 

Table Design

Preview
I am creating an assets database. Each asset has approx 100 fields, all 1:1. Should I make one table, or try to break it down into several tables linked by Asset ID? There are no 1:M relationships, so there is no real reason to make more than 1 table. Is the massive 100 field table poor design
 

Table Lookup or Query?

Preview
I have a main Asset Table recording IT Equipment. Two of the fields in the Asset Table are Equipment_Type and Equipment_Type_Specific I.e. PC > Desktop

There is an Equipment_Type table with a child table Equipment_Type_Specific .

The Asset Table needs to look up to these tables for the Equipment Type values. The Equipment_Type_Specific field will be a cascading combo so that the user can only select Laptop,Desktop,Tower etc. if it is a "PC".

Would it be best to have these two Fields in the Asset Table looking at a query so that the names are saved in the Asset table rather than the Key reference of the various Equipment Types?
 

Help asset tracking database

Preview
I'm developing a simple asset tracking database. The assets I want to include are Laptops, workstations, and printers. I want to be able to know the exact location of the asset, be able to change the status of an asset and any other important information. I think it's also important to keep track of the asset location changes.
It is also important to be able to make queries by department, by type of asset.

Here is a screenshot of the tables I tought I can create. I have knowledge in Database development but this is my first real project. I don't know what other table I should consider !
 

Delete query using criteria from another table

Preview
I have two tables (Master Asset List & Asset Versions Lists) with one common field (Asset_ID). I am trying to create a delete query that will delete a record in the Master Asset List of there is no corresponding record in the Asset Versions List.

I used the Query Wizard to create a 'Find Unmatched' query. This correctly returns the results I want to delete. I opened this query in design view, and changed it to a delete query by clicking Delete in Query Type on the Design Ribbon. I thened add the table I wanted to delete the record from (Master Asset List) with the field as "*" and changed the Delete setting to 'From' (see attached image).

When I run this query, I am warned that "You are about to run a delete query that will modify data in your table" and I am propted to confirm if I wish to continue (Yes/No/Help). When I confirm, I get the error message "Specify the table containing the records you want to delete".

Any suggestions on what I should do to fix this
 

Form Auto population

Preview
I guys,
Im completly new to Access and have been asked to build a database which includes, three main tables customers, buildings and asset register for each building. As you can see from Customer Form, I created a button called Asset Register, which brings up Asset Form based on Macro <OpenForm = Asset, Datasheet, , , , Normal; ApplyFilter = [Asset]![Building ID]=[Forms]![Customer]![Building].[Form]![txt_BuildingID].[Value], >. (Not too sure if its right way, but it works).
The problem is when I open up Asset Register Form - I can input all the information and it will be saved in Asset Register Table, but I have to input Building ID manuly for the same building, and I have about 300 items ;(. How do I automate this proccess, so building ID populates automaitcly for all items when I enter information (and saves it in Asset Register Table)?
Please inform me if I made very stupid mistakes in my database, any critisism will be appreciated, I am trying to learn Access
 

Form Auto population

Preview
I guys,
Im completly new to Access and have been asked to build a database which includes, three main tables customers, buildings and asset register for each building. As you can see from Customer Form, I created a button called Asset Register, which brings up Asset Form based on Macro <OpenForm = Asset, Datasheet, , , , Normal; ApplyFilter = [Asset]![Building ID]=[Forms]![Customer]![Building].[Form]![txt_BuildingID].[Value], >. (Not too sure if its right way, but it works).
The problem is when I open up Asset Register Form - I can input all the information and it will be saved in Asset Register Table, but I have to input Building ID manuly for the same building, and I have about 300 items ;(. How do I automate this proccess, so building ID populates automaitcly for all items when I enter information (and saves it in Asset Register Table)?
Please inform me if I made very stupid mistakes in my database, any critisism will be appreciated, I am trying to learn Access
 

Business-Based Functions

Preview
An asset is an object of value. It could be a person, a car, a piece of jewelry, a refrigerator. Anything that has a value is an asset. In the accounting world, an asset is a piece of/or property whose life span can be projected, estimated, or evaluated. As days, months or years go by, the value of such an asset degrade.
 

why isn't this insert into working?

Preview
trying to get matching data from my query to insert into an existing table, nothing happens it just sits there, any ideas?

INSERT INTO Transactions ( [Asset Number], [Location Name] )
SELECT Books.[Asset Number], Books.[Location Name]
FROM Books INNER JOIN Tabletest ON Books.[Asset Number] = Tabletest.[Asset Number]
WHERE (((Books.[Asset Number]) Is Not Null
 

Table Design for Assets Inventory with Multiple Asset Type/Asset Attribute Combos

Preview
I need to set up a database for tracking fishing supplies inventory. The problem is that for each type of asset (rods, reels, jigs, hooks, etc.) there are different combinations ofattributes that need to be entered.

Eventually I would like to be able to create a form for adding new assets to the database, but am having trouble structuring my tables in a way that allows me to create the form that I want.

The form that I envision would pop-up and give me the option to type the new assets name in a text box, and select the asset type from a combo box. After these are filled out, there will bea "next" button that moves me to a new pop-up form.

This new pop-up form will allow me to enter specific data about the asset I have just entered. The dilemma is that when I select "Rods" for asset type, I should be able to enter specificdata that would not apply to a selection for "Reels." I am having a lot of trouble designing my tables to give me this kind of freedom in my forms.
 

Opening a new blank form rather than first record in the table

Preview
I have created an asset database but have a problem with one of the forms.
I have a form with the button 'New Asset' and when I click it opens a New Asset form so I can enter new asset details. The problem is that it opens the first record in the table rather than a brand new (empty) record which I require. Can anyone help.

The code I have on the 'New Asset button' is below

Private Sub Openad_Click()
On Error GoTo Openad_Click_Err
DoCmd.OpenForm "Asset Details", acNormal, acFormAdd
On Error Resume Next
DoCmd.Requery ""
DoCmd.GoToRecord , , acNewRec
Openad_Click_Exit:
Exit Sub
Openad_Click_Err:
MsgBox Error$
Resume Openad_Click_Exit