Keep updated on tips, tricks and features of design and hosting - enter your email above. We never share your address, opt out here.

We use a variety of technologies to fit any need. If these terms seem like Greek, don't worry, we're happy to guide you through the process, working with your staff, webmasters, or tech personnel.

  • PHP
  • Perl
  • .Net (VB, C# & ASP.NET)
  • MySQL, MS SQL & MS Access
  • Frontpage Extensions
  • UNIX/Linux, Windows Servers
Sponsored Links

Nonprofit Media and Marketing
Media Guide for Nonprofit Agencies Complete how-to guide only $39.95
robert-anthony.com

Home / Database Design
Office Database Design With MS Access
Databases are designed to offer an organized method for storing, managing and retrieving information. To do this they make the use of tables. If your familiar with the tabular organization of spreadsheets, you're probably already accustomed to storing data in a column and row format. It's not much of a stretch from spreadsheets to databases. However, databases are much more powerful to access and manage large amounts of information.
A properly designed database provides your organization with up-to-date, accurate information. It's essential to achieving your goals, improving office work flow and ensuring data integrity.

We use MS Access to design databases for use with 1 to 25 concurrent users. All users can access the same information at the same time without worrying about corrupting, or duplicating data. A variety of security levels can be implemented to ensure everyone has access to the proper information.

The example screen pictured is the main screen of a database that provides all the necessary functions to manage a business.

The database can process orders, handle order fulfillment, email one or more customers, perform broadcast emails, print labels, manage customers, produce sales reports and much more.

Virtual Web Software can design, deploy, update and manage a database for your organization that will make complex tasks easy and efficient. We can deploy updates to your database remotely and provide service and support to ensure smooth operation of your organization. Contact us for details and to discuss your needs.

Although MS Access has a decent ability using its integrated Visual Basic for Applications (VBA) feature, sometimes a more powerful interface is needed. We can use VB and .Net to produce a true software application that has far more power when accessing databases or performing other tasks, please see our custom software section for more details.


All content copyright © 2010 VirtualWebSoftware, Inc.