In the report builder you have a column "alias"
Select Top 100 Percent tblComputersystem.Manufacturer, tblComputersystem.Model,
tblComputerSystemProduct.IdentifyingNumber, tblDiskPartition.DeviceID,
tblDiskPartition.Size, tblCDROMDrive.Caption As caption1,
tblDisplayControllerConfiguration.Caption As caption2,
tblPhysicalMemoryArray.MemoryDevices, tblPhysicalMemory.Capacity,
tblPROCESSOR.Name, tblOperatingsystem.Caption As caption3,
tblOperatingsystem.ServicePackMajorVersion
From tblComputersystem Inner Join
tblComputerSystemProduct On tblComputersystem.Computername =
tblComputerSystemProduct.Computername Inner Join
tblDiskPartition On tblComputersystem.Computername =
tblDiskPartition.Computername Inner Join
tblCDROMDrive On tblComputersystem.Computername = tblCDROMDrive.Computername
Inner Join
tblDisplayControllerConfiguration On tblComputersystem.Computername =
tblDisplayControllerConfiguration.Computername Inner Join
tblPhysicalMemoryArray On tblComputersystem.Computername =
tblPhysicalMemoryArray.Computername Inner Join
tblPhysicalMemory On tblComputersystem.Computername =
tblPhysicalMemory.Computername Inner Join
tblPROCESSOR On tblComputersystem.Computername = tblPROCESSOR.Computername
Inner Join
tblOperatingsystem On tblComputersystem.Computername =
tblOperatingsystem.Computername