Recent content by tabos23

I can't atm cause I am at work but I ll have a look on it for sure. Since I have to do the analysis asap I ll just create a table for each Software Status and I will connect it with the Device table. So I will not have Software Table but I will have InstalledSoftwares, ToBeInstalledSoftwares...

jdraw I really appreciate your help! It s not as complex as you think! I already have the data in an Excel spreadsheet and I just want to transfer it to Access in order to do analysis easier. A device can be a laptop or a desktop. The data I have is much bigger than the one I presented before...

What do you mean by bits? I am trying to be as more detailed as I can. As I mentioned before consider category as Status...It makes more sense. Status could be: Already installed To be installed Uninstalled So...Device 1 can have as installed(category1) softwares: Skype and Office but...

Thanks for your help jdraw! Well I will explain you all the business rules. There are many devices There are many Softwares There are many Software Categories. A device can have many softwares, A software can be in many devices A software can be in many Software categories(status) A device...

That's how I think of it...But I do not understand how the Software category will be connected to the Devices... :rolleyes::rolleyes::rolleyes::confused::confused::confused:

Yes I know that I have to create a junction table in many-to-many relationships. My question has to do with the Software category mostly. So there will be tDevice, tDeviceSoftware(junction table), tSoftware and tSoftCategory and probably tSoftwareSoftwareCat (junction table) because this is...

One table will be the Device table for sure. There must be another one for the software but there are also 3 types of softwares. The softwares that has alreeady been installed, these one that have to be installed and finally the ones that have been removed. So I agree for the first table...

Hello to everyone, I have to design a database with the following data (You can see attached also the data): DevID DevModel SoftwareInstalled SoftTobeInstalled SoftRemoved 1 Lenovo x62 Microsoft Office Antivirus Skype 2 HP D46 Winamp Skype Win Media 3 Toshiba BT45 Win Media Outlook...

Yes of course there is a third table that connects these two...You can see attached the photo that shows their connection.

Hello to everyone, I would like to create a full outer join in Access2010 between two tables with many to many relationship. So I have tblServer and tblApplication and there is also the ServerID-ApplicationID table that connects these tables. I found online many examples but all of them...

Still it is not clear?

I want to assign the AppSizePerUD from the AppSizePerUD query to the corresponding UserDriveID in the UserDriveUsage query. Sorry for my english. Is it clear now what I would like to do? Thank you in advance.

Hi there! I need your help. I am new with Access and I have a problem. I have created a query that counts the AppSizerPerUD for every User Drive (UserDriveID). Now I want to assign these values to the other query (UserDriveUsage) for every UserDriveID. So I want to create a new column in the...

Hi there! I am Vangelis! I am Greek but at the moment I am working in the UK. I have just started my new job a few weeks ago as a Business Analyst and I have already faced a few problems with Access. Sooo here I am! Thanks!