Why use Microsoft Access to create a business system?

• Access has been designed to communicate well with other products in the Microsoft Office suite. e.g. MS Word, Excel, Outlook, Powerpoint and more. It has been designed with integration in mind. Access systems can also be seamlessly integrated with other major database products such as Microsoft SQL Server and Oracle using ODBC (open database connectivity).
  
  
• Microsoft Access is one of the best-selling desktop databases of all time. Therefore worrying about future support is next to unnecessary and with Microsoft's backing it should be around for some time to come. Also, since Microsoft is constantly improving their database you can be sure that your investment is future-proof.
  
  
• MS Access is a Multi-User database in the sense that from the beginning Access was designed to operate on a network. Microsoft say that the latest version will support 255 concurrent users, however in practice experts recommend a more comfortable limit of 15 to 20 simultaneous users.
  
  
• By using Microsoft Access for Rapid Application Development you can keep your costs down. You can build attractive, functional and easy to use applications in double-quick time.
  
  
• Another plus point in Access' favour is that it can import many data formats so your existing data is not lost. This feature alone can save hundreds of data input hours.
  
  

With it's comprehensive tool set MS Access provides the perfect environment for Rapid Application Development. So I can create effective applications quickly thus reducing the cost to you the customer. With my expert systems development skills I can:

• Design, create and populate the MS Access database. Designed in accordance with Relational Database methodologies the Access database should be a solid foundation upon which the effectiveness and integrity of your business system depends.
  
  
• Design and create a user interface application consisting of user-friendly MS Access forms. These forms are where you can type in, view, search and process your business data. See screenshots of an application I created for a video shop using MS Access on the tightest of budgets.
  
  
• Design queries that can extract data from the Access database. E.g. find out which of your customers have not come back for say a year. Or which of your products or services are most profitable.
  
  
• Design and create reports displaying information pertaining to your business. Reports may also be used to feed data to other applications e.g. MS Word mail merges, email address lists.
  
  
• Provide design help, support, upgrades, performance tuning, health checks and troubleshooting for your existing Microsoft Access Database systems.

 See this example of a DVD / Video Hire System I created