|
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:
new york
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 ?
Call or email for a free
quote. How can we help organize your
business better ?
|
