|Some examples of Office-Automation systems developed
in Access, Excel, Word, Outlook
and VBA Applications:
- Production Control: Machine part
and material assemblies, optimised ordering (across multiple jobs), ACAD
integration, complex quoting of assemblies. sub-assemblies and
miscellaneous components. Machine and resource scheduling and workflow
- Project and task
management: due dates, reminders and responsibilities
- Inventory control: including
material-offcut tracking, supplier material and production details.
Tracking of material manufacturers certificates and mapping to
- Asset-register: including
location, movement and depreciation-reports
- Quoting and ordering: including
very complex Excel forms linked to databases and generating formatted
quotes and input streams to production and inventory-control systems.
- Electronic Document
Filing: storage, multi-context indexing and sharing – instant
access to hundreds of thousands of documents, spreadsheets, PDFs, tiffs
- Membership databases: including
all forms of data and communication
- Contact management: including
process-tracking & reminders of pending/overdue stages.
- Automated mailing
including personalized content, automatic cycling, tracking and
grouping. Automatically store e-mail into a database for archival or
- Automated Word Document Generation and
Merging Word, Excel and
- Job and worker Scheduling:
multi-stage processes, machine and resource availability
- Dynamic price lists:
mobile Excel price lists synchronized with databases and
generating orders and quotes in the field.
- Remote Time-entry and activity-logging
reports for all types of users and formatted documents for invoicing.
- Document & form dispensing:
Web-based, authentication-controlled access.
- Automated price-lists
(spreadsheets), updated electronically, that print invoices and reports
on demand, and upload sales-data directly into order-fulfillment systems
via the internet, or emailed from customer sites. Imbed pricing-rules,
bundling arrangements and custom ordering formulae into a simple Excel
- A workbook as a front-end
to a multi-user order-entry, quoting
and production-scheduling system. Link to databases to leverage
bulk-storage and query capabilities.
- Use Excel, connected
to web services and databases, as an online analytical tool. Download data,
track workflow and production statistics as they happen; know all the
ACCESS DATABASE DEVELOPERS, EXCEL APPLICATIONS, OFFICE AUTOMATION, INTEGRATION,
CONSULTING SERVICES, BC