Gemblu Technical Solutions
Microsoft Access, Excel, Word and Outlook
In today’s business venue, it is a safe assumption that your company already owns a Microsoft Office package. Using these products to their fullest potential is a tangible solution to organizational quandaries.
There is no reason to look outside your organization for ‘canned’ software that will resolve your office organization problems.
Gemblu Technical Solutions will show you how.
- Web Site Database
- FTP Access
- Outlook Integration
- Quickbook Integration
- Inventory Solution
- Training Solutions
Web Site Database
Need database integration for an existing web site? Or does your business need a new web site? Gemblu Technical Solutions created a database using MySQL and dynamic web pages using HTML and PHP for a local business that allows their members to register for an event with on line forms and no paperwork hassle. The information is stored in a database for them to use in mass emails, statistical reports, etc.
FTP Access
A company in Canonsburg needed to be able to exchange large CAD drawings back and forth with their clients. Gemblu Technical Solutions designed a web based application that allowed the company to assign user names and passwords to their clients. They could then email the user name and password to the client that allowed the client to log onto the site and retrieve only their designated files from the FTP site.
Outlook Integration
A business in Erie, PA had all their employees doing double entry to record their time. They all used Outlook consistently to schedule their time, and record their expenses, but then had to enter it again to get it into the payroll system. By using their Microsoft Access software, a database was designed that allowed each employee to import their Outlook calendars into the database with the click of a button. The end result was saved hours and accurate reports for payroll and expenses.
Quickbook Integration
Need the ability to do more with your QuickBooks data? Gemblu Technical Solutions works with the QuickBooks QODBC driver to allow integration with QuickBooks and other software packages. For example, one business wanted to get their QuickBooks invoice information into their database without entering it twice. Now they select a date range from within the database and click a button and the requested data fills in automatically from QuickBooks. They have faster methods of searching for data as well as better reporting as a result of the integration.
Inventory Solution
Inventory at a local window company was being handled through spreadsheets and manual counts, taking extra hours and not always achieving accurate results. With a fully designed database, using the company’s current Microsoft Access software, they now have an integrated inventory system. They get accurate cycle counts with the use of barcodes and inexpensive scanners, have set reorder points, and run reports by entering a date range and clicking a button.
Training Solutions
Gemblu Technical Solutions provides personalized training for your office staff. The training is designed by your needs, whether it be Outlook organization, Word mail merge classes, Excel charting, or Access database design. You outline the problem and Gemblu Technical Solutions will design the solution in a training class that allows the employee to take charge of the software.
