Microsoft SQL Server and Microsoft Access Database Development New Jersey New York Pennsylvania NJ NY PA

SERVICES PRODUCTS CLIENTS WINS PARTNERS SUPPORT COMPANY SITE MAP

Database Development

Database development and database design is central to our custom software development projects. After all, regardless of the whether you are planning desktop or web deployment, your application will rely on information that must be effectively and efficiently stored.

When we start a development project you can expect numerous discussions about your data. Although we will likely start by discussing the business need and the processes required to meet the need, when we get down to details we will be talking about the data. Program specifications will ultimately be required at the data level. Because of our 30 years of database design for business organizations you can expect that we will already have a grasp of the tables, fields and relationships that will be required, but each project will have differences at the detail level. The data discussions may necessarily be lengthy and possibly even redundant because of the importance in getting it right.

For a more in depth view of the database design issues read SQL Server and MS Access Database Design.

Expect that we will want to review your actual data as early as possible. We will want to insure that the real‑world details match the conceptual framework that was described.

If you have not decided on the database required we can explain the options. MS Access may be sufficient and will likely have the lowest cost. SQL Server will be required for larger transaction volumes and for more granular security.

We have a more complete discussion of MS Access vs SQL Server if you are undecided.

At the same time as we are deciding on a database we will be discussing the options for front end development. If you have decided on MS Access you will probably want your entire application in Access but you also have the choice of using a .NET desktop or web application.

If we will be using SQL Server, web or desktop deployment is available and the deployment can even be mixed. When using SQL Server as the database we always recommend that SQL Server is accessed using stored procedure calls rather than in-line SQL.

If this is a first database for you and you want additional practical information about MS Access please also visit our web site devoted to Microsoft Access development.