|
Long Island New York's
most experienced programming firm
Store
information of any kind, and get the reports you need. Access is the
ideal tool, combining a rich
graphical front end with a powerful programming language.
We are experts in Microsoft Access and MS SQL Server
development projects. From the smallest table and report designs to the most
complex front end Access / backend SQL Server application, we can
solve your problems.
We have written hundreds of
programs, from bar coding systems for FDA drug trials to recipe systems for
plastic manufacturing. We can probably do yours. Some of our Access work:
Cablevision Corporation
needed to allow it’s business units to modify employee data prior to
uploading all staff into an EIPP (electronic invoice processing) system. We
took data stored in Oracle, brought it into Access, and designed a front end
for easy changes to four associated tables. Our system allowed the creation
and tracking of chains of responsibility and invoice routing through the
company. Some units preferred modifying data in Excel, and we downloaded
data into sheets and wrote code to validate data as it was brought back into
Access. A screen shot of the main
form doesn’t do justice to the complexity of the project. and back end code.
ADM (Archer Daniels
Midland Company) buys and sells commodities and has a subsidiary dedicated
to such trading on Wall Street. Billing was still being done in Excel
spreadsheets, involving much manual formatting of the invoices. We designed
and wrote an invoicing program. Using business rules (proprietary; but we
can show you a screen shot with our test
data) embedded in the software much higher efficiencies were reached.
Long Island
Builders Institute needed a database
system to track 600 members; not a great matter, you say ? But these
builders had scores of meetings, (and members who wished to be informed when and where they were,
and the main office wanted records )
and contributed to various funds, and printed various books of members and
their services , and wished to share some of this data on the web ... All of
this was done by us in Access.
What started out as a simple table grew over 4 years
into scores of tables and perhaps 100 reports and queries. Here's a
screen shot of a typical Access report from
this project, along with a list box giving a choice for the town to draw the
data from.
Debticated Consumer Services
has thousands of clients, all making payments to get out of debt ... we
designed and wrote a system for tracking these clients, their payments, and
the support staff servicing them. We then wrote a system for calculating
payments. This system drew from a table of thousands of creditors , each
with it's own payment rates and discounts. Done in Access, this calculator
is used by 5 to 10 staff on a network simultaneously,
demonstrating the power of MS Access . The system saved tens of thousands of
dollars in clerical error, and has greatly enhanced staff productivity
.
Here's a
screen shot of the payment calculation
page. Note that we have here a mixture of data and behind the scenes math.
The user chooses a creditor, and then enters the amount; the program (driven
by our coded instructions) then makes calculations and summations. Nothing
very complex here ( though very effective for the client); we could have
just as easily done far more complex calculations of a financial,
statistical or scientific nature.
Splash Designs of Manhattan
represents designers and sends out
artist's prints to clothing manufactures, and needs to track which artist produced them, where they were
shipped and when they should be returned. This subsystem integrates with
a 6000 record database of clients and contacts, along with a proprietary
calendar/appointment system. Running on an 11 station LAN, Splash now runs
it's business on our software. Here's a screen
shot of the main data management page.
We are experts in data
integration; a recent example involved Quickbooks accounting software, UPS
shipping software and MS Access as an intermediary. Out client was producing
invoices with a web based system and then doing lots of hand data entry
work. We automated the system; wrote code and created a program for him; it brought data and invoices down from
the web into Access, allowed him to mark each as shipped via UPS (and we
then uploaded it into the UPS application) or the US Mail ( we then printed
labels) and then sent the invoices automatically into Quickbooks. "This
saved me 5 hours a day in manual data entry" said the client.
These are 4 out of the
hundreds of applications we have written, many not in Access but in one of
the many other database environments out there.
We are experts in all aspects
of Access; database repair, user training, data conversion, moving a system
from one machine or network to another, scaling up to MySQL or SQL Server,
and moving your data onto the web. We have supported and enhanced
applications written by others, and are pleased to step in to advance older
or troubled projects.
When to go
beyond Access ?
While based in Suffolk County on Long Island, New
York, we have made and supported software and networks for firms in New York
City , Connecticut, New Jersey, and Florida - and would be happy doing the
work anywhere we travel - from Europe to Asia to South America.
Call or email for a free
quote. How can we help organize your
business better ?
|
