Tracked incoming silicon materials shipments through the incoming quality control labs.
Lab Metrology Tracker
MetrologyDB.mdb
Metrology database application which tracked preventive maintenance and calibration of all lab metrology in multiple quality control labs.
Statitical Process Control Application
SPCTrack.mdb
Implemented advanced SPC Chart functionality for quality control silicon wafer metrology.
HTML Exporter
HTMLSpew.mdb
Exports a query with multiple one to many layers into a HTML hiearchy with linked drill down into each layers.
Database Upgrade Application
MeasureDBUpgrade.mdb
A database upgrade utility for MS Access based embedded data layer for a product line of thin film metrology tools. Leveraged ADOX database replication functions to do an automated bulk migration all customer meaurements from downlevel database revisions or from one metrology tool to another.
Microsoft Premier Services Contract Administrator
NA
Corporate representative for our Microsoft Premier Services Contract. This gave me direct access to Microsoft's Access Database developers to harden our implementation of Access as an embedded database in a product line of $500K Thin Film metrology tools. The focus was best practrices to eliminate database corruptions.
Manufacturing Execution System for PCBAs
BoardTrack.mdb
Manufacturing Excecution System for circuit board assembly. Generated circuit board serial numbers and the flow of circuitf boards through the assembly process. Also managed the various test results and generated a Certificate of Conformance. for each assembly.
Certificate of Conformance Applicaiont
CofCTrack.mdb
Tracked incoming silicon materials shipments through the incoming quality control labs.
Manufacturing Quality Management Application
QualityDB.accdb
Yield, Defect and RMA tracking for circuit board manufacturing assembly process.
Fault Tree Debug Application
FaultTree.accdb
Tracked the test debug process on manufactured electronic boards by assembly id, failure mode, failure symptom and root cause. Used to reduce future debug time on assemblies.
Quoting and Project Life Cycle Management
TestDev.accdb
Application to track the quoting process and all project milesones for complex test developments integrating both software and hardware designs. TestDev tracked the project against quoted cost and schedule. The database was also used to inform and dial in the accuracy of subsequent project quotes.
General Data Engineering
Misc
My use of Microsoft Access goes way beyond application development. I have used it extensively over 25 years for general data slinging (data discover, data manipulation, data transformation, data conversion). Many times just a component layer in a software stack.
Misc Application Development
Misc
To be honest, I do not remember all the applications and uses I’ve done with MS Access. I was an early adopter of Microsoft Access before it was released to the public in 1992 and have used it ever since (all versions). The above list represents some of the more substantial developments I have done with MS Access.
General Notes on MS Access Architectures.
Misc
Most MS Access architectures I implemented were client-server approaches with the client Access DB (user interface, queries and VBA) running on the users computer talking to a centralized backend Access DB running on a shared server or workstation. This is critcal for performance over a network and especially for mult-user implementations. This also helps reduce database corruptions on multi-user applicaitons.
Many times the backend database was not Access, but SQL Server, MS Excel or MySQL with data access configured through an OLEDB or native database driver (preferred) or ODBC. I also made extensive use of VBA. All VBA modules contain error trapping and write to system and transaction logs based on a Verbosity flag which defines the level of log detail.
