LONG ISLAND DATABASE DEVELOPMENT
Microsoft Access Programming & SQL Server — Long Island, NY
Custom Microsoft Access databases, forms, reports and business applications—built around the way your company actually works. We develop new systems, repair existing ones, and connect Access to SQL Server and other data sources.
Microsoft Access development, repair and modernization
Custom applications
Purpose-built inventory, scheduling, contact management, invoicing, barcode and reporting systems.
Forms and reports
Practical data-entry screens, business rules, calculations, queries and useful reports for your staff.
Repair and enhancement
Fix troubled databases, take over programs written by others, convert data and move applications to new computers or networks.
SQL Server integration
Use Access as a familiar front end with SQL Server behind it, or plan a larger migration when appropriate.
Spreadsheets are useful, but they are not always the right way to run a business. With Access, staff can enter information through forms designed for their jobs, search and analyze records, and produce consistent reports. The system can also enforce your business rules and perform calculations.
We work with Access tables, queries, VBA, forms and reports; data conversion; multiuser environments; and integration with SQL Server, MySQL and web systems. Learn more about the advantages of Microsoft Access.
Examples from our client projects
Over the years, Net/Works has built applications ranging from barcode tracking for pharmaceutical trials and manufacturing recipe systems to inventory, invoicing, membership and contact management. Here are examples from our project history.
Hammel New York — inventory and web reporting
We developed a fast custom warehouse inventory system with barcode support, order entry and reports. Data was published to a password-protected website so salespeople and office staff could see available stock. The original system generated HTML from Access data and scheduled secure uploads.
Long Island Builders Institute — membership management
A database initially tracking about 600 members grew into a broader system for meetings, member communications, contributions, directories and web data. Over four years, the application expanded to many tables, queries and reports.
Splash Designs — a business-wide system
For this Manhattan design representative, we developed software to track artists' prints, shipments and returns, alongside approximately 6,000 client and contact records and a custom calendar. The application supported an 11-workstation network.
Debticated Consumer Services — payment calculations
We built a system to track clients, payments and support staff, plus a calculator using creditor-specific rates and discounts. Several employees could use the application concurrently on a network.
Cablevision — Oracle data and invoice routing
We created an Access front end for editing related employee and organizational tables before import into an electronic invoice processing system. The workflow included Oracle data, Excel import/export validation and responsibility-chain tracking.
ADM — custom invoicing
For a commodities trading operation, we replaced manual spreadsheet invoice formatting with an application that incorporated proprietary billing rules.
ULC Robotics — remote database access
As this firm's needs grew, we helped make an existing Access database available to field staff through remote-access technologies. See our background pages on VPNs and Terminal Server.
Data integration can save hours of work
In another project, we connected a web-based invoice system, Microsoft Access, UPS shipping software and QuickBooks. Orders were brought into Access, shipping information was prepared for UPS or postal labels, and invoices were passed into QuickBooks automatically.
When should you move beyond Access?
Access can be a very effective front end, including with a SQL Server back end. But growing data volumes, simultaneous users, remote access and integration needs may justify a different architecture. We can help evaluate the options without automatically discarding software that already works.
Read When have you outgrown Microsoft Access? or explore other database technologies.
Let's discuss your database
Based in Suffolk County on Long Island, we have developed and supported systems for clients across New York City, Connecticut, New Jersey, Florida and beyond. Whether you need a small repair or an entire application, tell us what you want the software to accomplish.