INF322

profileshaka
customer_service_first_last.accdb
Home>Information Systems homework help>INF322
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
4 United Health Services Smith John [email protected] Director 12344 45667 879786767 67676778 123 main str Mockville CA 75889 USA
5 DOX Smell Jon [email protected] Developer 1244 456687 8879786767 678676778 173 main way Summerville CA 7889 USA
6 AET Smell Jonson [email protected] Analyst 13244 4356687 3879786767 675676778 1763 main way Summerville CA 79889 USA
7 CTRX Mell Jontson [email protected] Analyst Programmer 132444 43565687 3869786767 675676778 18763 main way Summerhill CA 79879 USA
8 YTRXY Merril Rontson [email protected] Analyst Programmer 532464 543565687 569786767 575676778 58763 Little way MArrickvilole CA 79879 USA
9 TRX Mell Susan [email protected] Manager 632444 46565687 43869786767 6756436778 8763 main street Summerhill CA 79879 USA
10 WILC Merry John [email protected] Programmer 32444 3565687 69786767 5676778 763 WAter way Summerhill CA 79879 USA
11 TTRX Mel Gibson [email protected] Analyst Programmer 132444 43565687 3869786767 675676778 18763 main way Lilse CA 79879 USA
12 ROX Roxyan Bobby [email protected] Analyst 2444 43687 3866767 675778 163 Sky way Oalbrook CA 79879 USA
13 BP Melssing Keith [email protected] Manager 444 65687 38697 778 18755 NAper way Lisle CA 79879 USA
14 BPCL Cee Mike [email protected] Team Lead 4789 44465687 4438697 444778 4418755 NAper way Lisle CA 79879 USA
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 Sort String Default Description
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 Customers.[ID], Customers.[Company], Customers.[Last Name], Customers.[First Name], Customers.[E-mail Address], Customers.[Job Title], Customers.[Business Phone], Customers.[Home Phone], Customers.[Mobile Phone], Customers.[Fax Number], Customers.[Address], Customers.[City], Customers.[State/Province], Customers.[ZIP/Postal Code], Customers.[Country/Region], Customers.[Web Page], Customers.[Notes], Customers.[Attachments], Customers.[Attachments].[FileData], [Attachments].[FileFlags] AS Expr1, Customers.[Attachments].[FileName], [Attachments].[FileTimeStamp] AS Expr2, Customers.[Attachments].[FileType], [Attachments].[FileURL] AS Expr3 FROM Customers;
SELECT DISTINCTROW [Customers].[ID], [Customers].[Company], [Customers].[Last Name], [Customers].[First Name], [Customers].[E-mail Address], [Customers].[Job Title], [Customers].[Business Phone], [Customers].[Home Phone], [Customers].[Mobile Phone], [Customers].[Fax Number], [Customers].[Address], [Customers].[City], [Customers].[State/Province], [Customers].[ZIP/Postal Code], [Customers].[Country/Region], [Customers].[Web Page], [Customers].[Notes], [Customers].[Attachments], [Attachments_560376B1F48545B4A3B57A946F117B94].[FileData], [Attachments_560376B1F48545B4A3B57A946F117B94].[FileFlags] AS Expr1, [Attachments_560376B1F48545B4A3B57A946F117B94].[FileName], [Attachments_560376B1F48545B4A3B57A946F117B94].[FileTimeStamp] AS Expr2, [Attachments_560376B1F48545B4A3B57A946F117B94].[FileType], [Attachments_560376B1F48545B4A3B57A946F117B94].[FileURL] AS Expr3, [Attachments_560376B1F48545B4A3B57A946F117B94].[_Attachments] FROM Customers LEFT JOIN f_66C84F321A684DF089D827ABB834852D_Attachments AS Attachments_560376B1F48545B4A3B57A946F117B94 ON [Customers].[Attachments]=[Attachments_560376B1F48545B4A3B57A946F117B94].[_Attachments];
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"));
SELECT Customers.[ID], Customers.[Company], Customers.[Last Name], Customers.[First Name], Customers.[E-mail Address], Customers.[Job Title], Customers.[Business Phone], Customers.[Home Phone], Customers.[Mobile Phone], Customers.[Fax Number], Customers.[Address], Customers.[City], Customers.[State/Province], Customers.[ZIP/Postal Code], Customers.[Country/Region], Customers.[Web Page], Customers.[Notes], Customers.[Attachments], Customers.[Attachments].[FileData], [Attachments].[FileFlags] AS Expr1, Customers.[Attachments].[FileName], [Attachments].[FileTimeStamp] AS Expr2, Customers.[Attachments].[FileType], [Attachments].[FileURL] AS Expr3 FROM Customers;
SELECT DISTINCTROW [Attachments_B0E7D4D052BC4745B4A4092C2B06A255].[FileURL] AS Expr3, [Attachments_B0E7D4D052BC4745B4A4092C2B06A255].[_Attachments], [Customers].[ID], [Customers].[Company], [Customers].[Last Name], [Customers].[First Name], [Customers].[E-mail Address], [Customers].[Job Title], [Customers].[Business Phone], [Customers].[Home Phone], [Customers].[Mobile Phone], [Customers].[Fax Number], [Customers].[Address], [Customers].[City], [Customers].[State/Province], [Customers].[ZIP/Postal Code], [Customers].[Country/Region], [Customers].[Web Page], [Customers].[Notes], [Customers].[Attachments], [Attachments_B0E7D4D052BC4745B4A4092C2B06A255].[FileData], [Attachments_B0E7D4D052BC4745B4A4092C2B06A255].[FileFlags] AS Expr1, [Attachments_B0E7D4D052BC4745B4A4092C2B06A255].[FileName], [Attachments_B0E7D4D052BC4745B4A4092C2B06A255].[FileTimeStamp] AS Expr2, [Attachments_B0E7D4D052BC4745B4A4092C2B06A255].[FileType] FROM Customers LEFT JOIN f_66C84F321A684DF089D827ABB834852D_Attachments AS Attachments_B0E7D4D052BC4745B4A4092C2B06A255 ON [Customers].[Attachments]=[Attachments_B0E7D4D052BC4745B4A4092C2B06A255].[_Attachments];