Microsoft Access

We use Microsoft Access as an inventory database for large-purchase orders of materials that we in turn convert (custom, based on customer needs/designs). Once a shipping container has been received and the material(s) tagged, they are entered into Microsoft Access with dimensions, lot/batch numbers and quantity. At this point, the primary users are our Sales team, Order Costing & Material handlers.

• Improved functionality for Material Purchasing
• Ease of data entry/cataloging raw material shipments for Receiving
• Improved inventory search/location-specific tracking for Material Handling
• At-a-glance inventory & cost visibility for Sales team

Microsoft Office 2016 (discontinued)

Microsoft Office 2016 (discontinued), Epicor CMS, HubSpot CRM

We use Microsoft Access to track employee information, organize employee data, and prepare employee communications. It provides a central system for tracking certain data when other tools are not as appropriate. It is a helpful tool for archiving and storing information and providing a reference point when employee questions arise.

• Better organization of employee data
• Clearer communication to employees
• Facilitates compliance with federal and state requirements

Microsoft 365, Microsoft Publisher, Adobe Acrobat

Microsoft Access is a great tool to help our company organize data in a way that functions for us. It is a flexible program that allows us to create a database that is tailored to our specific needs.

• Allows us to track data quicker and easier, saving time and money.
• Allows us to analyze date quickly saving time.
• Allows us to customize the data saved and how it is used.

Microsoft Excel

I use Microsoft Access for database management, templates, printing name badges and recording tallies.

• Can't copy from Excel directly into Microsoft Access across multiple columns, each entry goes into each cell, which is tedious
• Can't import Excel file reliably into Microsoft Access database, it requires too many reformats
• Google docs is more reliable for me, but not suitable for printing name tags

Google Sheets

Google Sheets

Our organization uses Microsoft Access to create and manage databases based on our unique data sets. Access gives us the flexibility for different staff members to generate reports for their programming needs. We also have the option to view the database in different views. This is important since the level of technological competence differs for staff, so having the option to view data in different ways is more meaningful and helpful to staff.

• We have only been able to train about 20% of employees to the point of competency with Access.
• The younger workforce doesn't appear tolerant of individual level of data entry

Microsoft 365, Microsoft Excel, Cloud Signage for Google Drive