Microsoft Office Forums Creating a useful database for the storing and distribution of job instructions.

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-07-2016, 02:27 AM
adamsimpson adamsimpson is offline Creating a useful database for the storing and distribution of job instructions. Windows 7 64bit Creating a useful database for the storing and distribution of job instructions. Office 2010 64bit
Novice
Creating a useful database for the storing and distribution of job instructions.
 
Join Date: Oct 2016
Posts: 1
adamsimpson is on a distinguished road
Default Creating a useful database for the storing and distribution of job instructions.

Hello



I am trying to create a data base of instruction sets. Where I work when a job comes in it comes in on a "traveller". This is basically a set of instructions on how to carry out the job.

Ie

Clean glass.
Put down plastic layer.
Put down metal layer.


Cleaning the glass has several steps involved, as will putting down the other layers. There are also different ways to put down plastic layers and to put down the metal layers. There are also set ways for setting up the same layers each time.

Ie:

Standard Process 1

Clean Glass
Put down plastic A
Put down Gold layer

Standard process 2

Clean Glass
Put down plastic B
Put down Gold layer

Standard process 3

Clean Glass
Put down plastic layer B
Put down titanium layer

I would like to build a database so that I can output and excel spread sheet with a front sheet, a set of instructions and a back page for adding notes through the manufacturing process.

I would like it so that I only need to have the cleaning layer stored once and then added into any traveller

I want to be able to:

Create separate instruction set for each individual layer.
(Something like a spread sheet with a sheet for each thing so "put down plastic layer A" would exist once and if one of its sub instructions changes it changes here and then that's it done.)

By able to put them together into travellers.
(a set of macros so one for clean glass I could press this and it would add clean glass to a new traveller, press a different one and it would add "put down plastic b" after clean glass. I could then save this so that I could do the below)


Create a standard traveller.
(So this could be an access report or an excel macro that copies and pastes into a new excel worksheet that it creates. So press "standard process one" macro and it would create a new excel work sheet with a front page, a page of all the instructions in it needs and then a back page ready to be sent out and printed. Any new macros created would then be made up to pull the instructions from the lists created from above)

Is this possible and which office package would this be best completed in?

Thanks

Adam
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a useful database for the storing and distribution of job instructions. Creating the disappearing instructions in text fields cebubum Word 3 09-19-2016 04:54 AM
Creating global contact lists (distribution lists) Outlook 2011 Mac pengyou Outlook 0 09-10-2016 02:18 PM
Creating a useful database for the storing and distribution of job instructions. Code for storing new word fahmiakbar Word VBA 2 02-13-2015 11:26 AM
Creating a useful database for the storing and distribution of job instructions. disable formatting instructions ccc Word 4 09-28-2013 10:41 AM
Creating a useful database for the storing and distribution of job instructions. Creating distribution list from contacts in TO field johnstonia Outlook 3 08-12-2010 12:58 PM


All times are GMT -7. The time now is 09:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft