Sage Integration
Microsoft Access integrating with other software
We can give you easy access to information
you already have in your database, presenting it in a format that is meaningful for you to use. If you need to update the information, or enter new data, we can build forms that are intuitive to use, and reflect the way you work. We can even train you or your staff, so you will be able to create your own reports quickly and easily.
Accountancy packages such as Sage or Intuit Quickbooks,
or Contact Management products such as Act!, will link seamlessly with
Microsoft Access. Software for other purposes including
CRM (Client Relationship Management), CAD (Computer Aided Design), CAM (Computer Aided Manufacturing) or Project Management can also be integrated. Microsoft Access can even be used with in-house software systems developed using Oracle, DB2, SQL Server or other databases.
Microsoft Access Integration with Sage
GEM UK is an electronic manufacturing company that
specialises in the building and assembly of printed circuit boards (PCBs).
PC Access developed a bespoke Microsoft Access database
that allows the editing of bill of materials for the manufacture of
printed circuit boards. The application integrates with the
Sage accountancy system to extract product and price information
The Problem
Our client has a high level of technical expertise,
but had been unable to produce bill of materials containing information,
in sufficient detail for each of the components, as required by his manufacturers. He had an existing stock control database using Sage Accounts, and was
using Crystal reports to produce his own order documentation.
Although he was happy with the way Sage handled the financial
side of the business, the Bill of Materials (BoM) module would have been expensive to buy, and was too general for his specific requirement. It could not store the range of information he needed, in a format that he could easily use.
Nor was he able to produce the specialist reports necessary for his business.
With good computer skills, our client is competent in producing
his own forms and reports. However he lacked the specific skills required
to design and build a solid foundation for the project.
The Solution
We designed and built a Microsoft Access database that enables
the client to produce a Bill of Materials easily. He can now supply the
information needed by his manufacturers in sufficient detail for each component. We also provided a customised form for easy editing of the BoM information.
Microsoft Access can link directly into live product data within Sage, so
product and pricing information only has to be updated in one place. Our client has extended the database we developed to create his own custom forms and reports.
PC Access continue to provide ongoing support for
Microsoft Access and other technical issues.
Gary Middleton says:
"Tony and Anna have been a pleasure to work with.
I am very much hands-on person, and like to manage as much
as I can myself. My requirements are constantly changing too, so I need to be able to adapt the software I use as I go along
They have been a tremendous help. My initial problem was solved in a way that allows me add my own forms and reports in Access. It's now so handy being able to phone to sort out any minor niggles, or for technical advice."