Transcript Documents and Plans Archiving Database System

Documents Archiving
Database System
Jesus Pernia
Sponsor: Diversified Technology
Consultants (DTC)
Objectives





Create a user-friendly application that allows
searching and storing documents in archives.
Provide a mechanism that updates the database
when a document is retrieved or returned to
storage.
Create a tool that allows the user to print labels
for documents to be flagged for storage
purposes.
Create a function that allows the user to print a
report of projects to be discharged.
Provide a mechanism to restrict users’ access.
Software Components

Visual Basic

Microsoft Access

Useful to create a
user-friendly
application to allow
the user to manage
the entire system.

Provides the interface
between the user’s
application and
database.
Component Diagram
Search for a Project
Store a Project
Print report of projects
to be discharge
Yes
Yes
File ?
File ?
Search for a file
Entering file
description
Search for Documents
No
No
Search for plan
Database
Entering plan
description
Database
Store data
Database
Display
File Info
Store data
Print label
Identifier for box
Print report
Display
Plan info
If file retrieved
from storage
update database ?
No
If plan retrieved
from storage
update database ?
No
Yes
End
Yes
Print label
Identifier for plan
End
End
Title of Proposal Pages

Cover Sheet ( New Page)
 Abstract (1 Page)
 Introduction ( Cont. Page)
 Project Description (2-3 Cont. Page)








Schedule ( Cont. Page)



Resources
Difficulties
Sponsor
Project Description
Anticipated Outcomes
Evaluation of Results
Plan of Demonstration
Flow Diagram of Component Dependencies
Scheduling of Component Execution and Resources
Conclusion (1 Cont. Page)
Progress-to-Date
 Database
tables.
 Customized Forms / Views.
 Adding Functionalities.
 Simple / Efficient.
Main Page
1.
2.
3.
4.
5.
6.
Data-Entry Page / Print Labels
Searching Page / View Results
Report of Retrieved Documents
Update Document Manipulation DB
Report of Documents Ready to Discard
Exit Application
Database
BOX NUMBER
PROJECT NUMBER
PROJECT NAME
LOCATION
DATE
A501
06-101-301
Southern Connecticut State University
New Haven
10/20/2006
A501
06-230-302
Diversified Technology Consultants
North Haven
A502
06-101-301
Southern Connecticut State University
A503
00-235-124
Boilers replacement
DISCIPLINE
CONTENT
Civil
Drawings, Correspondence
3/23/2002
Structural
Correspondence
New Haven
4/12/2000
Civil
Correspondence
Hamden
9/27/2003
MEP
Reports
Document Data-Entry Page
Document Searching Page
Searching Result Page
Difficulties
 New
Field of Studies
 Time
Anticipations
 Achieve
Goal
Work Remaining
 Macros
Encoding
 Proper Functionality
 Switchboard Linking
 System Testing / Debug / Performance
Comments
 No
Comments…
 Suggestions
if any ?
Documents Archiving
Database System
Jesus Pernia
Sponsor: Diversified Technology
Consultants (DTC)
Objectives
 User-friendly
application
• Effective and efficient.
• Archive
• Search
• Track documents manipulation
 Adding
functionalities:
• Print tag / labels.
• Report of document out of archives.
• Report of projects to be discarded.
 Security
Restriction.
Main Page
Databases
Plan Data-Entry Form
Project Information Form
Document Update Form
Time Table
Difficulties

Filtering Queries
Work Remaining
 Screen,
tools and functionalities
 Switchboard linking
 Test application
Comments

Equipment Database.