Käynnissä

Build Access 2007 customer service issue tracking system

Need simple MS access 2007 system with admin functions and application to enter and report on customer service issues:

0. Dashboard - data in separate file from front end - so that several instances of front end can be used with different data/backends.

1. Admin Login -

A1. Add /edit/delete users (name , password, 4 hierarchical levels of authority - Read, Add, Edit, Delete

A2. Edit Lookup Tables

A.2.1 LU_Category1 - text field length 30

2.2.1.2 LU_Subcat1 - text field grouped under Category1

A.2.2 LU_Category2 - same as Category2 but different values

A.3 LU_Province -text length 30

A.4 LU_Status table - text 20 - Will be things like: Open, Closed, In Research etc.

A.5 LU_Priority - text 50

A.5 LU_Wherefrom - text 40

[url removed, login to view] Login

U.1. Add/Edit View/Delete an "CASE" (based on user authority)

Case_ID

Case_Desc - long text

Case_Date_Reported

Case_Date_Responded

Case_Date_Closed

Case_Status (from lookup table)

Case_Province (from lookup table)

Case_Priority (from lookup table)

Case_Category1 (from lookup table)

Case_Subcat1 (from lookup table)

Case_Category2 (from lookup table)

Case_Wherefrom (from lookup table)

Case_Who_Responsible

Case_Actions (very long text)

Case_Address (long text)

Attachments

Reporting

Need to be able to list and do counts by date range and by

- Category1

- Category1/Subcat1

- Category2

- Status

- Date_Reported / Date_Closed

Revised numbering in Admin section:

1. Admin Login -

A1. Add /edit/delete users (name , password, 4 hierarchical levels of authority: Read, Add, Edit, Delete)

A2. Edit Lookup Tables
A.2.1 LU_Category1 - text field length 30
2.2.1.2 LU_Subcat1 - text field grouped under Category1
A.2.2 LU_Category2 - same as Category2 but different values
A.2.3 LU_Province -text length 30
A.2.4 LU_Status table - text 20 - Will be things like: Open, Closed, In Research etc.
A.2.5 LU_Priority - text 50
A.2.6 LU_Wherefrom - text 40

I cannot get the tags to work - This is MSACCESS 207 - no PHP!

Taidot: Microsoft Access

Näytä lisää: access customer system, build issue tracking dashboard, access 2007 tracking system, table customer, ms lookup, front end reporting, file service architecture, edit service, dashboard architecture, customer table, customer service tables, build things, service architecture, research service, ms access reporting, ms access 2013, customer service, customer research, customer login, issue tracking 2013, access delete, build php simple application, dashboard reporting system, add edit view, dashboard report

About the Employer:
( 152 reviews ) Toronto, Canada

Projektin tunnus: #4260293

Myönnetty käyttäjälle:

Prashantskin

[url removed, login to view] Thanks for invitation for this project. I have gone through all the details and the additions and will develop this application in access 2007 within 3 days only Thanks for your time Regards Prashant

200 $ USD 3 päivässä
(453 arvostelua)
6.9

4 freelanceria on tarjonnut keskimäärin 258 $ tähän työhön

winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

230 $ USD 15 päivässä
(10 arvostelua)
4.7
wsfreelanzer

Hi, i reviewed your requirement. I can do this project. Please check more details on private message. Thanks, Raj

250 $ USD 3 päivässä
(1 arvostelu)
3.2
ielkfarna

Please, See my private Message.

350 $ USD 6 päivässä
(1 arvostelu)
2.0