Affordable Database Development with our Modular database system for Microsoft AccessMore functionality and even better value for moneyAs professional software developers with over twenty years experience, we know that not all businesses can afford to commission their own bespoke software. That’s why we have created our range of modular database templates for Microsoft Access. By selecting from our stock of tried and tested modules, we bring you individually tailored software packages at affordable prices. The modules have been carefully designed around an integrated framework with all the tables, fields and input forms needed to build complex custom applications. You can start with a single module to manage say customer contacts or price lists, confident that it can be expanded as your needs grow. Contact PBMS Consultants now...Phone 01494 815306 for a no commitment discussion or E-mail your contact details and we will get back to you. See our range ready-made templates based on the modular database system
Contact Database TemplatesContacts are at the heart of most applications; correspondence, buying, selling, HR. Our four core contact templates, either singly or in multiple cover just about every possible permutation of personal and business contact. They are Microsoft Outlook compatible which means you can import or select contacts from your address book. Unlike Outlook, our contact templates are hierarchal. Each contact, corporate organisation or individual, has a Parent identifier so you can have multiple individual contacts per department or organisation, subsidiary companies as part of a group and so on. Product Database TemplatesOur basic Products template includes part numbers and product groups with buy/sell list prices, discount structures by product or customer/supplier, in stock, on order, committed, max/min stock levels. If you are engaged in manufacturing, we have a Bill of Material processing template with nested assembly levels and full BOM explosion. Together with our Contact templates, the Product templates form the basis of many custom systems like Sales Invoicing, Purchase Ordering, Goods Received and Stock Control. How the modular template system works in practiceLet's use the Order Entry & Invoicing template for our example. The template already has all the fields, features and functionality you are likely to need. You can use it straight out of the box but you will probably want us to customise at least the sales invoice so that it looks just like your existing invoice document. You may also want it to generate purchase orders. The basic template already has max and min stock levels and a suppliers table, so all we need do is add your purchase order document and a selection form. By adding a goods received input form, we can then turn it into a full stock control system. The template lets you dump selected information into an Excel spreadsheet so you can create your own sales analysis and Word mail-merges. Or, you may prefer us to create custom sales reports for you. Just send a copy or even a sketch of the reports you want and we will add them; either when you order the template or later when your needs have grown. What software do you need to use our modular database templates?Microsoft Office Professional (which includes Microsoft Access). Some templates need Office 2000 or later - tell us which version you use when you contact us. If you don't have Access, we can package the template in a special run-time version. If you are not familiar with Access, don't worry - you don't need to be.
|
|
![]() |
|
|
| +44 (0) 1494 815306 | ||