| Access |
+20 Years |
- Table creation, normalization, field validation
- Data import & export; flat files created internally & externally; to & from Excel, Word and Access
- Front-ends linked to Access, SQL Server & other ODBC compliant databases
- Queries used throughout, including compiled & within VBA code.
- Select, Update, Delete, Make-Table. Action queries in code written do not trigger warning messages
- Criteria (WHERE clause) generally supplied from a user-form (combo box) or via VBA code variable
- Results of queries used for decision-making, reports, alerts
- Inner-Joins, Left-Outer Joins. Single & Multi-table
- Forms for simple slice & dice reporting via one or more combo box selections
- Multiple combo boxes will update related combos upon changed selections
- Procedures launched for further processes based upon user selections or account status
- Auto run macro/vba code launched from an auto loading form for each database
- VBA – all routines controlled within standard modules
- Modules for error handling, file related checks, table and query updates, email processing, status updates, file import & exporting routines
- Modules for mainframe operations using Attachmate/BlueZone
- Modules for interacting with, and controlling, other databases
- Reports
- Output of reports would generally be an end-user option available via a command button on a form
- Created ‘form-letter’ reports that would print out each morning for end-users
- Automated form letters printed in Word
|
| Excel |
+20 Years |
- Import, convert, export data from flat files, ODBC databases
- Format reports based upon end-user requirements
- Pivot-Tables, Pivot-Chart creation based upon end-user requirements
- Linked to Word form letters
- Use of all functions within Excel
- Customized Paynter charts showing trend, pareto diagrams and top-level detail over time
- Automation of repetitive tasks through VBA
- Most VBA code used in Access (not Access specific) could be used in Excel
- Not from macro recorder, though macro recorder useful for discovery purposes
- Format worksheets, cells, charts
- Conditional formatting based upon cell contents
- Linking to Access, Excel and ODBC databases
|
| Word |
+15 Years |
- Automated Mail-Merge form letters using several data sources
- Template Creation
- Used as output report from Access
- Used Word specific VBA for data scrubbing of flat/text files
- Used for printing to pre-printed forms, including electronic
|
| Outlook |
+10 Years |
- Routines for end-users to download all email attachments for specific email messages into a unique message folder. Attachments were required backup documentation
- Routines to poll a group email inbox and display current status of unread emails by region, based upon a unique dealer/region table maintained by the end users
|
| PowerPoint |
+15 Years |
- Training
- Extensive use for producing training courses:
- Electronic component identification
- Safety training
- SPC (Statistical Process Control)
- New hire orientation
- Reports
- Used for Executive level presentations to Management Quality Council meeting.
- Included dozens of trend charts, statistical data analysis
- Linked to Excel workbooks, Access databases
- Included photos, links and videos
|
| Visio |
3 Years |
- Process mapping
- Manufacturing Process Steps
- Business Process Steps
- Quality Assurance Auditing
- ISO 9001 Audits
- Database Schema
- Job scheduling
- Have studied using for BI dashboards
|
| PowerShell |
+2 Years |
- Used to remote in to 9 desktop computers
- Used for video file conversion processing of 1200+ personal video file collection
- Used for various personal automated disk status reports
|
| VBA (Visual Basic for Applications) |
+20 Years |
- Standard modules for error handling, file I/O, email
- Workflows controlled through VBA using tables, queries and business rules
- Primary method of managing several hundred unique process running daily, weekly and monthly
|
| VB/CMD/Batch Scripting |
+20 Years |
- Primary use to launch applications via job scheduling software
- Used within VBA to launch non-Microsoft applications
- Launch scripts for file I/O
- Used for periodic job status updates and alerts
|
| SQL (Structured Query Language |
+20 Years |
- Used in Access. Saved (compiled) queries with a naming convention tied to tables and or particular function
- Built SQL statements through Access form events based upon user selections, including multi-select combo boxes. Typically 3 levels of drill-down granularity made available
|