tech_support.accdb
| DeptID | DeptName |
| 1 | Marketing |
| 2 | Accounting |
| 3 | Engineering |
| 4 | HR |
| 5 | Production |
| DeviceID | DevName | DevLocation | DevPurchDate | DevPurchPrice | DevPropTagNo |
| 1 | Router | Basement | 1/1/10 | ¤ 250.00 | 123456 |
| 2 | Router | 2nd floor, Rm 23 | 2/2/10 | ¤ 225.00 | 234567 |
| 3 | Bridge | 2nd floor, Rm 23 | 2/2/10 | ¤ 150.00 | 234568 |
| 4 | Switch | 2nd floor, Rm 23 | 2/2/10 | ¤ 150.00 | 234569 |
| 5 | Ethernet hub | 1st floor rear | 3/3/10 | ¤ 150.00 | 235790 |
| 6 | Server | 1st floor rear | 3/3/10 | ¤ 4,000.00 | 235791 |
| 7 | Wi-Fi router | Marketing | 4/4/10 | ¤ 50.00 | 245877 |
| 8 | Backup storage | Marketing | 4/4/10 | ¤ 558.00 | 245878 |
| TicketID | TicketUser | TicketDevice | TicketTech | TicketSubmitted | TicketResolved | TicketStatus |
| 1 | 1 | 1 | 1 | 1/1/11 | 1/5/10 | Closed |
| 2 | 2 | 2 | 2 | 2/2/11 | 2/6/10 | Closed |
| 3 | 3 | 3 | 3 | 3/3/11 | 3/7/10 | Closed |
| 4 | 4 | 4 | 4 | 4/4/11 | | Open |
| 5 | 1 | 3 | 3 | 5/5/11 | | Open |
| 6 | 3 | 2 | 2 | 5/5/11 | | Open |
| 7 | 2 | 1 | 1 | 10/10/10 | 10/11/10 | Closed |
| 8 | 4 | 2 | 2 | 3/14/11 | 3/24/11 | Closed |
| 9 | 5 | 3 | 3 | 3/29/11 | | On hold |
| 10 | 6 | 4 | 4 | 4/6/11 | 4/21/11 | Closed |
| 11 | 7 | 5 | 3 | 4/14/11 | | On hold |
| 12 | 8 | 6 | 4 | 3/17/11 | | Cancelled |
| 13 | 9 | 7 | 1 | 4/6/11 | | In process |
| 14 | 10 | 6 | 2 | 4/1/11 | 4/5/11 | Closed |
| 15 | 9 | 5 | 3 | 5/3/11 | | Cancelled |
| 16 | 8 | 6 | 4 | 3/15/11 | 3/31/11 | Closed |
| 17 | 7 | 7 | 3 | 4/26/11 | 4/28/11 | Closed |
| 18 | 6 | 4 | 2 | 4/29/11 | | In process |
| 19 | 5 | 3 | 1 | 2/19/11 | 2/25/11 | Closed |
SELECT TechTbl.TechID, TechTbl.TechName, TechTbl.TechTitle, TechTbl.TechEmail, TechTbl.TechPhoneExt, TechTbl.[Office Location]
FROM TechTbl
WHERE (((TechTbl.TechTitle) Like "*Tech I")) OR (((TechTbl.[Office Location]) Like "*1-3"));
SELECT UserTbl.UserName, DeptTbl.DeptName, DeptTbl.DeptID
FROM DeptTbl INNER JOIN UserTbl ON DeptTbl.DeptID = UserTbl.UserDept
WHERE (((DeptTbl.DeptID)=2 And (DeptTbl.DeptID)=3));
SELECT TicketTbl.TicketID, TicketTbl.TicketUser, TicketTbl.TicketSubmitted, TicketTbl.TicketResolved
FROM TicketTbl;
devilmycry1
