Xojo database tutorial manual#

used many times a day), it could potentially save a struggling business.Īs a counterexample it's easy to get this wrong as well. Being able to fully-automate manufacturing of silicon chips is an incredibly opulent affair, but if you can simply automate a paper-bound business process that is on a hot-path (I.e. I feel a lot of businesses can strive towards similar goals. Experiencing a massive factory that can literally run for hours-to-days without a single human inside is something else. I have some background in semiconductor manufacturing, and the degree of automation I witnessed there got to me in a really deep way. I think it is a fun and compelling challenge to see just how much of the business you can put 'on rails' with computers and various integrations. Then someone figured out you could start plugging in other business systems to your rules engine and tracking state. I.e., prevent generation of forms you would have to otherwise manually revise and resubmit after the fact. The most interesting factor was the fact that now that the inputs are captured in a computer, we can run business rules against those inputs computationally. It really is incredible the difference it makes.

Xojo database tutorial manual#

I have seen fully manual paper process (printers/scanners/pen & ink/shredders/etc.) go into 100% digital realm and the impact it had on the business. Many business owners have no idea the extent to which automation is feasible here. Creating the shipping documents went from 30-45 mins to essentially the click of a single button.īeing able to automate forms can absolutely revolutionize some businesses. I just recreated the document as an Access form, with fields that would populate from a query. Creating these documents was a tedious process of looking up the data manually and then typing it into a Word file. Just for one example, we often had to send equipment out to different labs since we didn’t have the capability to test them, and shipping stuff required a standard military shipping document with various mundane pieces of information about the stuff being sent.

I had no choice but to build my own solution, and the only real option was MS Access given the barren IT resources available on a deployed aircraft carrier.īut man, was it a fucking lifesaver. However, just managing our workload and operations efficiently required other data which was not part of this database.

Most of this data was managed centrally, and we sent/received DB updates a couple times a week. Easily over 10k individual pieces of equipment, each of which had to be calibrated on a specific schedule. We were responsible for calibrating and repairing all the test and measurement equipment for the entire ship as well as the squadrons that we carried with us. A number of years ago I was in the Navy and worked in an electronics shop on an aircraft carrier.