INF322 WK3 Assignment & WK5 Assignment

customer_service.accdb

Home >Computer Science homework help >INF322 WK3 Assignment & WK5 Assignment

ID	Caller	Call Time	Notes	Case

ID	VersionHistory_F5F8918F-0A3F-4DA9-AE71-184EE5012880	Title	Assigned To	Caller	Opened By	Opened Date	Customer	Status	Category	Priority	Description	Due Date	Comments	Resolved Date	Related Cases	KB	Attachments

ID	Company	Last Name	First Name	E-mail Address	Job Title	Business Phone	Home Phone	Mobile Phone	Fax Number	Address	City	State/Province	ZIP/Postal Code	Country/Region	Web Page	Notes	Attachments

ID	Company	Last Name	First Name	E-mail Address	Job Title	Business Phone	Home Phone	Mobile Phone	Fax Number	Address	City	State/Province	ZIP/Postal Code	Country/Region	Web Page	Notes	Attachments

ID	Object Type	Object Name	Filter Name	Filter String	Default
1	2	Case List	Priority = High	([Open Cases].[Priority]="(1) High")	false
2	2	Case List	Opened Date = Today	(Year([Open Cases].[Opened Date])=Year(Date()) AND Month([Open Cases].[Opened Date])=Month(Date()) AND Day([Open Cases].[Opened Date])=Day(Date()))	false
3	2	Case List	Due Date = This Week	(Year([Open Cases].[Due Date])=Year(Date()) AND DatePart("ww",[Open Cases].[Due Date],0)=DatePart("ww",Date(),0))	false

ID	Title	URL	Notes	Tags

SELECT [ID], [Employee Name] FROM [Employees Extended] ORDER BY [Employee Name];

SELECT "-1" as [ID], "(Manage Filters)" as [Filter Name] FROM Filters UNION SELECT "0" as [ID], "(Clear Filter)" as [Filter Name] FROM Filters UNION SELECT ID, [Filter Name] FROM Filters WHERE ((([Object Name])=[Application].[CurrentObjectName])) ORDER BY [Filter Name];

SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Not Like "*Subreport*") AND ((MSysObjects.Type)=-32764)) ORDER BY MSysObjects.Name;

SELECT [Customers Extended].ID, [Customers Extended].[Customer Name] FROM [Customers Extended] ORDER BY [Customers Extended].[Customer Name];

SELECT [ID], [Employee Name] FROM [Employees Extended] ORDER BY [Employee Name];

SELECT Filters.ID, Filters.[Object Name], Filters.[Filter Name] FROM Filters WHERE (((Filters.ID)<>Nz([Form]![ID],0))) ORDER BY Filters.[Object Name], Filters.[Filter Name];

SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=-32768)) ORDER BY MSysObjects.Name;

SELECT DISTINCTROW * FROM Filters;

SELECT ([Days Active]>=0 And [Days Active]<7)*(-1) AS [1-7 days], ([Days Active]>=7 And [Days Active]<30)*(-1) AS [7-30 days], ([Days Active]>=30)*(-1) AS [Month+], [Days Overdue].* FROM [Days Overdue];

SELECT ([OverDue]<=0)*(-1) AS [On Schedule], ([OverDue]>0 And [OverDue]<7)*(-1) AS [Last Week], ([OverDue]>=7 And [OverDue]<30)*(-1) AS [Last Month], ([OverDue]>=30)*(-1) AS [Very Old], [Days Overdue].* FROM [Days Overdue];

SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])) AS [Customer Name], Customers.* FROM Customers ORDER BY IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])), IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]));

SELECT DateDiff('d',[Due Date],Nz([Resolved Date],Date())) AS OverDue, DateDiff('d',[Opened Date],Nz([Resolved Date],Date())) AS [Days Active], Cases.* FROM Cases WHERE (((Cases.Status)="active"));

SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])) AS [Employee Name], Employees.* FROM Employees ORDER BY IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])), IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]));

SELECT Cases.* FROM Cases WHERE (((Cases.Status)<>"Closed" Or (Cases.Status) Is Null)) ORDER BY Cases.Status, Cases.Priority, Cases.[Due Date];

SELECT Cases.* FROM Cases WHERE (((Cases.[Due Date])<Date()) AND ((Cases.Status)="Active"));