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)

Habilidades: Microsoft Access, SQL, Visual Basic

Veja mais: access database tracking drawings, document control access, access database document control, document control access database, access drawing tracking database, drawing tracking register access, access document control database, access document tracking database, document tracking access database, create access document control database, access document tracking, access drawing control database, creating document control database access, access document control, document tracking access, tracking drawings access database, create document tracking forms access, access item order history, access database document, document tracking database

Acerca do Empregador:
( 4 comentários ) Carole Park, Australia

ID do Projeto: #1390043

Concedido a:


MS Access expert here. Please check my profile. Thanks!

$1500 AUD em 10 dias
(68 Comentários)

39 freelancers estão ofertando em média $1697 para esse trabalho


Hello, please see the PM for details.

$1500 AUD in 30 dias
(16 Comentários)

8 years of MS access development as well as SQL development.

$2000 AUD in 20 dias
(18 Comentários)

I have 15 years experience in access design. I have many samples to show you. Thanks Donna

$1500 AUD in 30 dias
(36 Comentários)

Hi, I have 20 years experience in Access database design - mainly in New Zealand and quite a bit for Australian companies too. Please see my PMB for further information. Thanks

$2000 AUD in 14 dias
(9 Comentários)

Hi, I am working as a database admin,designer and developer with 7+ years of experience in ms access, ms sql server,oracle. My area of expertise is to design database from business requirements and translate complex Mais

$1500 AUD in 20 dias
(9 Comentários)

Hi there, I'm a UK-based Professional Access Developer with over 15 years commercial experience creating bespoke database applications. I'll send you over a sample database, which although unrelated, has many sim Mais

$1500 AUD in 5 dias
(10 Comentários)

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 Mais

$1500 AUD in 10 dias
(35 Comentários)

Please see detail on PMB. regards

$2300 AUD in 20 dias
(5 Comentários)

Your requirement can be met with an application developed in MS Access. I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [login to view URL]

$1800 AUD in 30 dias
(3 Comentários)

Software developer with 10+ years of experience

$1500 AUD in 30 dias
(3 Comentários)

Dear Sir, Please kindly refer to my PM for further detail Thank you Primasoft

$1500 AUD in 15 dias
(3 Comentários)

Hi, kindly check PM for details. Thanks

$1500 AUD in 35 dias
(4 Comentários)

we have done similar project, Pls Check PM

$1500 AUD in 5 dias
(2 Comentários)

I am a new freelancer but i have worked on Access & SQL before and will do this work on a priority basis. Please try my work.

$1500 AUD in 5 dias
(0 Comentários)

Hi, Greetings, I am interested in your project work. Ready to start work now. please provide me your project I can complete your project within the time line period with 100% accuracy, thank you. regards,

$2200 AUD in 8 dias
(0 Comentários)

Please see PMB.

$1500 AUD in 30 dias
(0 Comentários)

I am based in Melbourne. Have over 15 years experience in Access databases. Please see PMB for details.

$2400 AUD in 20 dias
(0 Comentários)

Hello Please refer an PMB

$1500 AUD in 3 dias
(0 Comentários)

Hello. My name is Vsevolod. I'm team leader in Russian software develpment company. We are ready to accomplish your project as soon as possible. Also we offer a free technical support for 3 month and discounts ob f Mais

$1500 AUD in 10 dias
(0 Comentários)

Sydney Based 13 year Pro access developer with many happy local clients/references. Please read PM

$2000 AUD in 21 dias
(0 Comentários)