Access Database - Document Control and Item Tracking

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.




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.




Door #

Door Hand




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)

Taidot: Microsoft Access, SQL, Visual Basic

Näytä lisää: drawing register access database, access drawing register, access database drawing register, document control access database, creating drawing register access, drawing register access, access database project tracking, drawing document control database, drawing transmittal register access database, database tracking drawings, access document control database, document tracking tables access, item tracking access, access database document control, access drawing control register, what is database entry, what is a data entry form in a database, new order history, drawings architectural, data entry work linked in

Tietoa työnantajasta:
( 0 arvostelua ) Algeria

Projektin tunnus: #1395892

21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

$2500 AUD 40 päivässä
(4 arvostelua)

I have 15 years experience in access design. I would like to bid on your project. Thanks Donna

$1700 AUD 30 päivässä
(36 arvostelua)

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 Lisää

$2000 AUD 30 päivässä
(5 arvostelua)

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

$1500 AUD 10 päivässä
(28 arvostelua)

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 Lisää

$1500 AUD 15 päivässä
(35 arvostelua)

plz check pmb.

$1500 AUD 15 päivässä
(9 arvostelua)

Dear Sir, Please read your PM. Thanks Meena Nader

$1500 AUD 10 päivässä
(16 arvostelua)

Please see detail on PMB. regards

$1800 AUD 20 päivässä
(5 arvostelua)

I have been developing systems in Access for around 20 years. I graduated as a civil engineer and worked both on site and in the design office, so am familiar with some of your requirements. I have made a few suggesti Lisää

$3000 AUD 30 päivässä
(1 arvostelu)

I have over 20 years experience programming in MS Access and VB, working for many UK based businesses as a contractor, so I am well equipped at developing software within structured parameters and timescales.

$1500 AUD 18 päivässä
(0 arvostelua)

Have done this type of projects in past.

$1600 AUD 12 päivässä
(0 arvostelua)

I am sure I can do this project fro you, because I have a good skills with job like that...check your PM, please...

$2000 AUD 15 päivässä
(0 arvostelua)

Hi, Please check your PM. Thanks.

$2500 AUD 45 päivässä
(0 arvostelua)

please see the pm

$2300 AUD 15 päivässä
(0 arvostelua)

I can do it sir. You can count on me to this project. My vast experience would give good quality and accuracy. Looking forward working with to this big project. You can contact me anytime.

$1500 AUD 7 päivässä
(0 arvostelua)

Hi, i'm pretty sure that i can do your project as you are asking. I have an huge experience in Access icluding database, forms, vba, sql. At the moment I'm not doing any job/project, so, I can reach your proposes and w Lisää

$1500 AUD 20 päivässä
(0 arvostelua)

Based in Melbourne and have over 15 years experience. Love to do this project.

$1600 AUD 20 päivässä
(0 arvostelua)

Please check PM

$2400 AUD 30 päivässä
(0 arvostelua)

Check PMB please.

$1500 AUD 1 päivässä
(0 arvostelua)

I can do the job for you. I have done similar job earlier.

$1500 AUD 4 päivässä
(0 arvostelua)