Access Database - Document Control and Item Tracking

Zamknięty Opublikowano Jan 18, 2012 Płatność przy odbiorze
Zamknięty Płatność przy odbiorze

The project involves creating an access database including tables, forms and queries.

The scope of the database consists of the following Major area's:

1. Drawing Register

* The drawing register lists all current Drawings for the project. The drawings are entered by a user which are entered into a temporary table, before being confirmed by the user and subsequently added to the Drawing table.

Fields:

ID

DWG No

DWG Title

DWG Type

DWG Revision

DWG Comment

Fabrication Status

Approval Status

Work Order

2. Architectural Reference Numbers (ARNS)

* This is a table containing a list of architectural door numbers for a given building. It contains metadata which is entered manually and always updated manually. The ARNs are "assigned" or "Unassigned" to a drawing so we know which drawing we have to make to fit the ARN.

Fields:

ID

ARN

Door #

Door Hand

Location

QTY

Type

Drawing# ( Linked to Drawing Register)

3. Transmittals

* Once drawings are created and assigend to ARN's they need to be issued internally via email. We need to keep track of which drawings are sent, for particular ARN's so they dont get re-manufactured.

A transmittal consists of the drawing numbers being issued, and the allocated ARN's to that drawing. A table should be created to keep a history of all transmittals. A drawing may be issued multiple times, for whatever reason so for this reason we need to keep a complete history.

When a drawing is issued for construction, the Fabrication Status is updated for that drawing.

4. Work Orders / QA

* When a drawing is issued for construction, we need to create a Work Order. The work order simply lists the drawing number, and associated RefNo's, and displays some QA fields indicating the stage that the drawing is up to in fabrication. Eg. "Cut", "Welded", "Galvanised", "Crated", "Sent","Complete".

Work orders need to relate to drawings an ARN's so it is easy to know what status a drawing is at.

A more detailed WBS is below:

1. - Drawing Register * List of all drawings on the project.

1.1 - Drawing Entry * Allows users to enter new drawings into the database

1.2 - Drawing Details * A form showing details of a single drawing.

1.2.1 - Allocate ARN's to/from Drawing.

1.2.2 - View History of Revisions

1.2.3 - View transmittal history of drawing.

1.2.4 - View Work Order/QA history for a drawing.

2. - Architectrual Reference Numbres (hereby referred to as ARN's).

2.1 - View All ARN's

2.2 - Enter ARN's/Modify ARN's

2.3 - Add new meta data fields to ARN table

2.4 - Reporting/Filtering

2.5 - ARN details * Displays details of an ARN

2.5.1 - ARN History * Displays changes to that ARN's metadata over time

3. Transmittals.

3.1 - View All Transmittals

3.2 - Create/modify Transmittal - Select Drawings/by ARNS/other filters

3.3 - View transmittal Details

3.4 - Transmittal history for a particular drawing etc

4. Work Orders/QA

4.1 - View all work orders

4.2 - Create/modify work order

4.3 - View QA for a particular Work order (showing status of each stage)

4.4 - View Work order details

4.5 - Work order history for a particular work order (any modifications etc)

Microsoft Access SQL Visual Basic

Numer ID Projektu: #1396099

O projekcie

35 ofert Zdalny projekt Aktywny Feb 22, 2012

35 freelancerów złożyło ofertę za $1994 w tym projekcie

sikandermandal

Please see PMB.

$2500 USD w ciągu 30 dni
(16 Oceny)
6.0
Frankhardy

Hi, Looking ahead to start development asap. Can you please send in more details of the platform you would be using to know if we can switch over to C# or php rather than stick on to VB. You can also expect long ter Więcej

$2450 USD w ciągu 30 dni
(3 Oceny)
5.4
WhizPool

Please see PMB

$2800 USD w ciągu 30 dni
(4 Oceny)
5.4
Krusche

Hello. We are an IT Company with team of 2 dedicated professionals in developing MS Excel\Access applications based on the VBA programming. German speaking. Have a glance at PMB

$1500 USD w ciągu 21 dni
(27 Oceny)
5.5
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Więcej

$3000 USD w ciągu 50 dni
(5 Oceny)
5.3
KellogITSolution

Hello Me an Ms-Access Expert working on MS-Access & VBA for the past 10 years. I am ready to do your work and could start right now. I have already done a no. of successful Access Projects and can provide u sample c Więcej

$1500 USD w ciągu 15 dni
(37 Oceny)
5.0
jacobdd1

Hi. Please check your PMB. Best Regards. Jacob.

$1500 USD w ciągu 10 dni
(23 Oceny)
4.9
jeanek

Good Day. I would like to express my interest in designing your MS Access Database. I have over eight years of professional (IT) work experience, where I have worked with various versions of Microsoft Access. Please re Więcej

$2000 USD w ciągu 30 dni
(5 Oceny)
4.9
rbenfield

Hi there, I'm a professional Access Developer. I have over 15 years experience in commerical Access Database applications and VBA coding. I can build this database application for you no problem. I will send you Więcej

$1800 USD w ciągu 21 dni
(10 Oceny)
4.6
rajelensoft

Ready to start.

$1600 USD w ciągu 21 dni
(2 Oceny)
4.0
MANOVIND

Dear Sir, we have developed many projects with vb.net with mysql, MS Access db. Definitely we can deliver with high quality. Regards Sathya

$3000 USD w ciągu 50 dni
(3 Oceny)
4.4
Jacob2i

Hello, I have over 17 years of experience coding in Microsoft Access. I also have extensive experience with SQL Server, ORACLE, and MySQL databases. I have many years of programming in Visual Basic, VBA, C#, VB.Net, AS Więcej

$1500 USD w ciągu 21 dni
(1 Ocena)
3.2
waleedobeidat

i have 21+ years experience in programming data bases. and developed many huge applications using ms access.

$2700 USD w ciągu 23 dni
(1 Ocena)
3.0
PerfectInfo

We are commited organized professional and having experience of more than ten years. We are known to be best solution provider in this area within given time frame and best availble deal. Apart from developing your sol Więcej

$2100 USD w ciągu 21 dni
(1 Ocena)
2.4
gerrymwalsh

Hi jimenapamela, I have over 20 years developing various systems in Access. I am well capable of providing you with the document control system you require. Regards, Gerry

$1750 USD w ciągu 30 dni
(1 Ocena)
2.4
exoticsolutions

Hello Sir. Please see PMB. Thanks

$2500 USD w ciągu 25 dni
(3 Oceny)
4.8
stalker2011

I am 4+ experiences software developer and can do it for you

$1500 USD w ciągu 10 dni
(1 Ocena)
1.0
iosifrn

Hello, I have over 15 years of programming experience in MS Access, SQL Server, ORACLE, C#, Visual Basic, VBA, ASP.NET, Web Development and others. I can help you with this project and any other projects you may have. Więcej

$2000 USD w ciągu 18 dni
(1 Ocena)
1.0
rasheshraval79

hello we have the capacity and talent to acomplish and start at a scratch.

$1750 USD w ciągu 15 dni
(0 Oceny)
0.0
muhammadibaad

Sir, I have expertise to fulfill all your requirement,plz check pmb for more detail. Regards,

$1500 USD w ciągu 25 dni
(0 Oceny)
0.0