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 Provides the interface
user-friendly between the user’s
application to allow application and
the user to manage database.
the entire system.
Component Diagram
Search for a Project Store a Project Print report of projects
to be discharge
Yes Yes Entering file
File ? Search for a file File ? Search for Documents
description
No No
Search for plan
Database
Entering plan Database
description Store data
Database
Display
File Info Store data Print label Print report
Identifier for box
Display
Plan info
If file retrieved
from storage Yes
update database ?
Print label End
Identifier for plan End
No
If plan retrieved
from storage Yes End
update database ?
No
Title of Proposal Pages
Cover Sheet ( New Page)
Abstract (1 Page)
Introduction ( Cont. Page)
Project Description (2-3 Cont. Page)
Resources
Difficulties
Sponsor
Project Description
Anticipated Outcomes
Evaluation of Results
Plan of Demonstration
Schedule ( Cont. Page)
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. Data-Entry Page / Print Labels
2. Searching Page / View Results
3. Report of Retrieved Documents
4. Update Document Manipulation DB
5. Report of Documents Ready to Discard
6. Exit Application
Database
BOX NUMBER PROJECT NUMBER PROJECT NAME LOCATION DATE DISCIPLINE CONTENT
A501 06-101-301 Southern Connecticut State University New Haven 10/20/2006 Civil Drawings, Correspondence
A501 06-230-302 Diversified Technology Consultants North Haven 3/23/2002 Structural Correspondence
A502 06-101-301 Southern Connecticut State University New Haven 4/12/2000 Civil Correspondence
A503 00-235-124 Boilers replacement 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.