"your personal computer specialists"
Home  Search  Links  Contact Us
 

Database Design

Our Services

Database Design
Database Repair
Web Pages
Internet
Training
Hardware Guide

 

Overview...

If you are looking for a customized database built to your specifications, then please read on.

We make Microsoft Access look easy!

Samples
Click here to see sample screen shots

Computer Resolutions, Inc. designs databases using Microsoft Access. We have over 12 years of experience using Microsoft Access to develop database applications. We have programmed databases for a number of clients in many different types of industries and applications.

We will work closely with you on your project to give you exactly what you want.  Our goal is a completely user friendly, fail safe, zero-error finished product.   We strive to make software that is not only easy to implement and use, but becomes a useful tool in helping you simplify and grow your business.

The overall database design, starts with a solid table structure which will determine the foundation of the information that is being tracked. All queries, forms, reports, macros and modules will either be developed for your project, or adapted from Computer Resolutions Inc.’s extensive library of pre-developed modules and objects. This offers you the maximum benefit of a user interface based on solid programming techniques.

 

We can integrate Access with many other programs...

  • Word

  • Excel

  • Outlook

  • MapPoint

  • Goldmine

  • Act

  • Quickbooks

  • etc.

 

A list of a few of our previous database programs...

  • Jewelry Store Manager (manage customers, sales, repairs, and appraisals for jewelry stores)

  • Contact Managers (manage your contacts for business or personal)

  • Client Managers (manage business clients, track billable services)

  • Real Estate Expenses (track expenses regarding property and project management)

  • Check-In Check-Out Program (library, stock room, returnable items)

  • Product & Sales Program (track stock #'s with user definable specs.)

  • Insurance Agency Manager (manage agents, clients, policies, commissions etc.)

  • Seminar Business Manager (track attendees, payments, mailing lists etc.)

  • Product Ordering Program (manage stock ordering, receivables, totals etc.)

  • Graphics Shop Tracker (track work orders/quotes/orders and shipments etc.)

  • Clothing Business Manager (customizable to track any conceivable data type)

  • Safety Strategies (help to implement a safety strategy for a major corporation)

  • Drug Testing Module (track drug tests and provide random drug screen selection)

  • Report Writing (analyze data from existing sources and create custom reports)

  • Networking Module (share data across a network effortlessly)

  • Online Shoe Store Database (track multi-tier inventory with thousands of options)

Click here to see sample screen shots.

 

Standard Database Features...

 

User Friendly Screens

User Friendly It is imperative that your program is easy to use. We develop all of our database applications so that a relatively inexperienced computer user can sit down and understand how to use the program without extensive training.  This saves you countless hours of training.
Click here to see a sample.

 
 

Graphic Design

Graphic Design Good graphic design makes a program aesthetically pleasing to the eye. A program that is nice to look at, can be fun to use. Programs with good graphics keep the user awake, alert, and productive.  Color coding, graphic images, neat and clean layouts are all standard features on all of our databases.  We can even incorporate your company logo on all screens and reports!
Click here to see a sample

 
 

Networking

Networking Computer Resolutions has developed a Visual Basic™ networking module that allows the user to browse the network for the back-end (where the data tables reside) database and automatically re-attach all tables to the front-end program (where the user program resides).  A system administrator/user will be able to add as many computers to the network as needed based on this networking module.

This feature has been perfected through years of development.  The networking module also allows program updates to work smoothly as the data tables are re-attached as the user starts the program update for the first time - automatically!
Click here to see a sample

 
 

Reports

Reports The report module is an intricate part of the system that allows for the easy addition of future reports that include simple and complex criteria. Each report will be able to be output in either Print Preview, Print, Excel or Word formats. This allows the user to achieve the highest degree of flexibility when trying to get output from the system.

Once a report has been added to the report module, a single standard report may now be several reports, all combined into one, based on the specified criteria.  For example, a standard "Sales Report" can become "Sales by Region Report" by specifying which regions are "included" in the report.  Other types of criteria may include date ranges, customers, employees, or anything that becomes necessary to properly extract the information from the database.
Click here to see a sample

 
 

Updates

Updates Updates and future modifications to the program are usually sent via e-mail and will be easy for the user to implement. A single self-executable file will be sent and will take less than 5 minutes to update. Also, updates are independent of data, therefore, any updates do not affect the existing data, they simply add new requested features.

Each update is tracked through a version number.  The version numbers are then listed within the database and detailed information is written about the new features that were implemented with each version.

Also available is an "easy update feature" that is very handy for larger networks.  One these larger networks, the update file is installed on the server and whenever a user starts the program, it checks the server for an update, based on the version number, and offers them the option of upgrading their program to the newest version.  This saves the system administrator the time required to go around to each computer to update them individually.

 
 

 

Optional Database Features...

 

Distribution Disks

Distribution DisksIMAGINE A COMPUTER PROGRAM that was originally designed for your company that is sold across the country at major software stores. It is possible! If you have a good idea for a program, call us and we can discuss the options of programming your application.  

Also for company wide distribution, distribution disks (available on CD-ROM or floppy) alleviates the need for multiple software licenses.  Once the distribution diskettes are made, a corporate-wide rollout program can be implemented effectively and inexpensively.

 
 

Help Screens

Help Screens Help screens are a necessary part of all applications. We can develop a help system for your application that is context sensitive. This means that you can access the needed help topics, where and when you need them, without having to search.  All help screens are easy to read and are worded in a consistent, non-technical manner that is easily understood.

 
 

Security

SecurityMicrosoft Access security allows for users and groups to be assigned certain privileges within a database program.  Computer Resolutions, Inc. has developed a security module that allows end users to manage their own users and groups.  Typically this feature is only available to users with the "Full" Access program installed, however with the security module, these features are available with "Runtime" distribution diskettes.
Click here to see a sample

 
 

Bar Coding

Bar Coding Bar Coding has become an industry standard and is necessary to virtually eliminate human error.  Using bar codes to track items, jobs, etc. not only tremendously increases productivity by expediting processes, but it also guarantees that data is correctly entered and tracked.  Consider the benefits of Bar Coding your application when contacting us about your project.

 
 

 

How To Get Started...

It is as easy as 1-2-3!

If you are looking for a customized database solution built to your specifications, look no further.  You have found us!  We specialize in working closely with you to give you exactly what you want!

Here is what you will need to do.

1 Put some thought into the program.  Don't worry about all of the details, just think in general what you want your program to do.
"I want to track my customers, and their invoices.  I would like to track my inventory and my specialized products with bar codes and..."
   
2 Write down the specifications. Write down what data you want to track, how you would like it to track it, and what features you would like to have within the program itself. 
"Since most of our customers have repeat identical orders, it would be nice to have duplicate order button that would automatically ..."
   
3 Contact us by phone 804.740.5102 or e-mail.   We will take a look at your specifications and give you a rough estimate for your project.   If you would like, we can offer the service of creating the specifications for you.   Sometimes it is easier to get a database person in on the front end to help you with the foundational ideas.
"Click on the button below to contact us or just give us a call."

Once we begin your project, we will give you a delivery date for the initial program.  From then on, updates will come by e-mail as the enhancements and fine tune adjustments are made.  You will start getting excited about checking your e-mail again!

We look forward to hearing from you!

 

© Copyright 1994-2008 Computer Resolutions, Inc. All Rights Reserved