ITFN 3314 TQA

1
ITFN 3314 - TQA
GA DOR Project
Kevin Kohler Henry Rutherford Nadira
Tolbert Miriam Witherspoon-Wheeler
2
Functions of Georgia Department of
Revenue Receive IRS taxpayer audits Decide if
amended GA return is warranted Notify taxpayer
3
Beginning January 2004, these audits, called
revenue agent reports, or RARs, are now being
sent to the GA DOR electronically, specifically
as an Access database.
4
Specifications A web-enabled database such that
a GA DOR employee can log in to the system, type
in a social security number and view the
associated RAR on the screen.
5
This application will be implemented using ASP.
The GA DOR will not support ASP.net.
6
Learning Point -
Microsoft Active Server Pages (ASP) is
Microsoft's support framework for server-side
scripting. It lets you mix HTML with in-line
scripting using JScript or VBScript and is fully
compatible with Microsoft's ActiveX controls and
components. Although you can use ASP to produce
simple HTML pages, it is designed to tie your web
pages into the data stored in databases on your
own and other systems. ASP itself is not a
scripting language -- it only provides the
environment that processes your script.
7
Learning Point -
Because ASP is frequently used to create business
applications on the Web, it is regularly used
with databases such as Microsoft Access,
Microsoft SQL Server, or databases from other
vendors. When used in conjunction with a
database, ASP pages can even run transactional
applications, such as those used by banks, by
using the features of COM or Microsoft
Transaction Server (MTS). A number of tools can
be used to create ASP pages, ranging from simple
text editors such as Notepad, popular Web site
creation tools by Microsoft and other vendors,
or a full-featured programming tool such as
Microsoft Visual InterDev.
8
Learning Point -
ASP is a set of software components that run on a
Web server and allow Web developers to build
dynamic Web pages. The advantage of ASP over
static HTML Web pages is that an ASP page is like
a computer program that runs on a Web server and
can calculate results, process user input, read
from or write to databases and files, and insert
"live" updated content every time a user browses
the page.
9
Learning Point -
ASP runs with a Web server on the Microsoft
Windows platform. The Web server that is used is
Internet Information Server (IIS). It is also
possible to run ASP with a limited feature set
on Microsoft Personal Web Server (PWS), which
runs on Microsoft Windows 95, Microsoft Windows
98, and Microsoft Windows NT Workstation. ASP can
also run on Unix operating systems by using
special extensions that are created by software
vendors.
10
Detailed Objectives

• Provide the ability to view RAR.
• Provide the ability to search data by the social
  security number.
• Provide the administrator with the ability to
  maintain user accounts,
• more specifically to create, update, retire.
• Capture who has looked at any given record so
  that the department
• remains in compliance with the IRS regulations.
• Provide the administrator with the ability to
  extract the entire and/or
• segments of the log created.

11
Flow Logic
Yes
Yes
Multiple Entries
Select Which RAR
Login Process
Enter SSN
SSN found
No
No
Not Found Message
Display RAR
12
Initial Login Screen
13
RAR Selection Screen
14
(No Transcript)
15
Summary of Progress

• Chose ASP for need and hardware ability of
  department
• Created form 4549 in HTML
• Connected the form to the database using ASP
• Populated form