How to query for something like "last active" per column in Access
I would have....

| Hostname | Timestamp | Status |
|----------|-----------|--------|
| Host1    | 19.02.2017| up     |
| Host2    | 19.02.2017| down   |
| Host3    | 19.01.2017| down   |


Then you could have another table...

| ID | Hostname | Location       |
|----|----------|----------------|
| 1  | Host1    | Living Room    |
| 2  | Host2    | Bedroom        |


When you run queries, it's easy to find all of Host1's activities, or you could easily find all the activities for 19.02.2017. Yes you have a million rows, but that doesn't matter.