Access Database - Document Control and Item Tracking
Required skills: Microsoft Access, SQL, Visual Basic
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)
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)
Posted In:SQLVisual Basic |
Related projects:
Access Database - Document Control and Item Tracking
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)
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 Database
to design and build an access database that will help me keep track of my employees, customers, batches scanned, boxes, and files. Employees will have to log in order to access the database and their login and log off hours will need to be logged. Batches, Boxes, and Files have to be unique to the customer but not to the database. I started designing the database but was unable to finish due to time. Attached is what I was able to come up with. I need something better and complete. Thank you
Access Database Modelling And Forms Building
This project consists in reviewing the database and the descriptive document atthaced and perform the following:
1)
Suggest changes / corrections and improvements in the database model if needed
2)
Create all the forms needed to easily add information to the database
1)
Suggest changes / corrections and improvements in the database model if needed
2)
Create all the forms needed to easily add information to the database
Access Database Debugging And
s made as follows:
1)add a section where I can make notes in point form
2)add a section where I can make a list of clients that I can print out
3)add a formula that will be able to calculate labor% I will be providing the formula
4) have the ability to print the entire database in a way the is economical in terms of the amount of paper
Please find the attached database. Also I am open to suggestions on how to get a more efficient database.
1)add a section where I can make notes in point form
2)add a section where I can make a list of clients that I can print out
3)add a formula that will be able to calculate labor% I will be providing the formula
4) have the ability to print the entire database in a way the is economical in terms of the amount of paper
Please find the attached database. Also I am open to suggestions on how to get a more efficient database.
Export Object Information From Access Database To Excel
follow">http://blogannath.blogspot.in/2010/03/microsoft-access-tips-tricks-working.html
http://www.edugeek.net/blogs/benrwb/661-getting-list-tables-access-database-c.html
The bidders with the low price bids would be interviewed first.
Feel free to ask for more information if you have any doubts about this project.
Thanks
http://www.edugeek.net/blogs/benrwb/661-getting-list-tables-access-database-c.html
The bidders with the low price bids would be interviewed first.
Feel free to ask for more information if you have any doubts about this project.
Thanks
C Program With Access Database
Hello,
I need a simple program with some text fields that will take a text as input and put it in a access database. Please let me know if you are interested then I will tell you more.
I need a simple program with some text fields that will take a text as input and put it in a access database. Please let me know if you are interested then I will tell you more.
Access Database Needs Populated
f them and start from scratch or leave them and enter new ones.
There is a lot of different trees, scrubs and plants. I need someone to enter all of them into the database along with all the information that the database uses along with pictures. Please take your time and look over the program and its database and also research all of the trees, scrubs and plants so you will know what all needs entered.
Thank you for taking the time to look into this project.
Happy Bidding!
There is a lot of different trees, scrubs and plants. I need someone to enter all of them into the database along with all the information that the database uses along with pictures. Please take your time and look over the program and its database and also research all of the trees, scrubs and plants so you will know what all needs entered.
Thank you for taking the time to look into this project.
Happy Bidding!
Access Database with forms and some reports
x; width: 320px">
Additional files submitted: (Files are only available for logged in users)
Business+Requirements+-+Access+Database+Reporting.doc
Additional files submitted: (Files are only available for logged in users)
Business+Requirements+-+Access+Database+Reporting.doc
Microsoft Access Database Setup
on at some point in php/mysql.
We need the same thing done for directory submissions, press release submissions, video submissions, forum profiles and comment, so from on the main project details screen it will have these as buttons which then links the info.
Basically this will aid our company so we know the exact submission stage for each site and so do our clients.
You need to have excellent skills with MS Access,
Thanks
John
We need the same thing done for directory submissions, press release submissions, video submissions, forum profiles and comment, so from on the main project details screen it will have these as buttons which then links the info.
Basically this will aid our company so we know the exact submission stage for each site and so do our clients.
You need to have excellent skills with MS Access,
Thanks
John
Access Database Queries
one time and now are out of stock. It needs to update so it takes off what I received back into stock. I need it to be printable and to show me title, full issue number, condition last know sale price, how many total I sold and then I need a column that shows me what 20% of that last know sale price would be(this is my buy price).
2. I need to know what I have in stock. I need it to be printable and to show me title, full issue number, condition and how many I have of each.
2. I need to know what I have in stock. I need it to be printable and to show me title, full issue number, condition and how many I have of each.
Ms Access Database
manager email address
developer name
developer email address
Manager name
Manager email address
once tables are created
We'll create (quesry)reports for distribution to the email address of the project manager, manager, customer or developer
Create and save a query that pulls all the company names from the project number and customer name and project manager fields
other reports or queires may be required in the future.
developer name
developer email address
Manager name
Manager email address
once tables are created
We'll create (quesry)reports for distribution to the email address of the project manager, manager, customer or developer
Create and save a query that pulls all the company names from the project number and customer name and project manager fields
other reports or queires may be required in the future.
Convert ACCESS DATABASE TO MYSQL AND BUILD BACKEND WEBSITE
LOOKING FOR SOME ONE TO CREATE A MYSQL DATABSE. CONVERT OLD ACCESS DATA TO THE MY SQL DATABASE. CREATE BACKEND AND FRONT IN SITE WITH DATA. ALSO CRATE FORMS AND LOGIN DATABASE. USER MUST BE ABLE TO HAVE THIS DONE WITHIN 10DAYS OF START TIME.
Ms Access Database 2
I want to create a new database for my personal use...
Additional Info (Added 3/21/2011 at 0:58 EST)...System Message: This is a reposting of project MS Access Database (1299369860).
Additional Info (Added 3/21/2011 at 0:58 EST)...System Message: This is a reposting of project MS Access Database (1299369860).
Access Database fix up (VB)
uired expertise.
The database is just a basic job log so we can keep track of inbound jobs (about 20-30 a day) with a few check boxes and drop downs. We can run queries that separate what kind of job it is, where things are in the production processes and for invoicing etc
This is a very small database with minimal information stored
Ongoing work for the winning bidder,
The database is just a basic job log so we can keep track of inbound jobs (about 20-30 a day) with a few check boxes and drop downs. We can run queries that separate what kind of job it is, where things are in the production processes and for invoicing etc
This is a very small database with minimal information stored
Ongoing work for the winning bidder,
Create XML and KML from access database
We are looking for code written in Visual Basic that will create both a XML file for RSS feed and a KML file which can be read from Google Earth and Google Maps from data stored in 3 tables in an access database.
Sample queries and a copy of the database can be provided, our programmers can do this task in php but do not have the expertise for .net
Sample queries and a copy of the database can be provided, our programmers can do this task in php but do not have the expertise for .net
ACCESS database generator – and a virtual assistant required !
Comand of C# set up, deploy and maintain SQL 2005 SQL Express 2005 dbs, writing SQL queries.
So the person chosen will require development skills as above and be looking for a long term working relationship. The work load will vary so the person need to be flexible and available - a method of working will be agreed. The language of undertaking business will be English.
If you are interested please respond with your references. Kind regards.
So the person chosen will require development skills as above and be looking for a long term working relationship. The work load will vary so the person need to be flexible and available - a method of working will be agreed. The language of undertaking business will be English.
If you are interested please respond with your references. Kind regards.
Need Access Database Online
Need the attached Access database put online and hosted. Main menu needs to be main page so all data can be entered and accessed through the internet. I do not have an MS server, so i need it hosted.
Needs to be done TODAY
Needs to be done TODAY
Improve and change MS Access Database to webbase by jjtango
he job.
6. Able to archive database and start a fresh one with a new csv file import users can upload themselves without any assistance.
7. Service provider winning the project will be provided with the Access database to improve and change to online database. Format of the csv files will also be provided. To provide documentation of the project as well.
8. Pls provide recommendations and portfolio for review.
Happy Bidding..
6. Able to archive database and start a fresh one with a new csv file import users can upload themselves without any assistance.
7. Service provider winning the project will be provided with the Access database to improve and change to online database. Format of the csv files will also be provided. To provide documentation of the project as well.
8. Pls provide recommendations and portfolio for review.
Happy Bidding..
MS Access database setup & classic ASP coding
ister, upload profile pic, post updates, replies, thumbs up etc) as well as the backend CMS.
Coding should be well commented.
HTML/Javascript may also be required to allow one click "Thumbs up" to 'like' status updates.
[Pages requires: Register pages, profile page, news page, edit account page, search function and Log out.]
Coding should be well commented.
HTML/Javascript may also be required to allow one click "Thumbs up" to 'like' status updates.
[Pages requires: Register pages, profile page, news page, edit account page, search function and Log out.]
Convert Access database to SQL server !!!
should work right away, but some of will have to be modified.
Some of the functions of the VBA application reside in a .dll file that was written in VB6. This file will need to be converted into VS2008 format.
I need a developer that is willing to dedicate full time to this from start to finish. If you can't do this full time, please do not bid. THis project must be done quickly. I estimate about 40 hours of work.
!!!!! DON'T BID OUTRAGEOUS !!!!!
Some of the functions of the VBA application reside in a .dll file that was written in VB6. This file will need to be converted into VS2008 format.
I need a developer that is willing to dedicate full time to this from start to finish. If you can't do this full time, please do not bid. THis project must be done quickly. I estimate about 40 hours of work.
!!!!! DON'T BID OUTRAGEOUS !!!!!
