CY Databases has a proven record. We strive to provide technically superior, user friendly database products and take pride in delivering them in a timely manner. Our reputation is rooted in an ethical, honest and sensitive customer service. We are equally at ease working with the shop worker or the corporate CIO. We listen and produce the application desired to turn data into dollars. HERE'S WHAT WE DO!! We can help. Contact us. At CY Databases:- We use every legitimate method to reduce the time required to design and build applications but we take the time needed to design and test them properly.
- We will never be the fastest but we are and will continue to be the best.
Our Guarantee - We guarantee our work to be bug free.
- We guarantee that the application will perform all of the functions listed in the database plan.
- We guarantee that the data in the database will not be corrupted by the database itself
- when the database is used properly.
- We guarantee that all of the calculations in the database are accurate within the limits defined in the database plan.
- This does not guarantee the data in the database.
- The "Garbage in = Garbage out" principle still applies
- We will correct any of the above problems free of charge for one year after delivery of the product.
Not Covered by Our Guarantee- Unfortunately we cannot guarantee the accuracy of your data.
- We cannot guarantee your data against unintended use of the database.
- We cannot guarantee against damage to the structure due to changes or additions to the structure by anyone but the staff here at CY Databases.
We can help. Contact us.
Office Automation - Shifting from Manual to Automatic We commonly integrate automation into our databases to increase their functionality. Automation can be used in your business to reduce the mundane but required tasks and free your time and that of your employees for more productive work. The development cost is quickly realized through the increase in production. Microsoft™ states that Access™ is the preferred platform for automating Office™. Many manual processes can be automated partially or completely, saving time or allowing more production. Automation allows for you to leverage the work that you have already done. The power of Access™ automation can best be expressed by example. - An IT leasing company sent monthly emails to its customers. These emails listed the leased items and a message that varied from a thank you for payment received to a demand for payment or the return of equipment. Two employees worked for 3 days to generate the emails each month.
Automation was introduced that read the data, determined the email to send to a customer, composed it, personalized it and send it. Automation reduced a task of 6 man days to 10 minutes.
- An accountant sent a monthly activity report of 150 cost centers to 50 managers in the company. The manual process required 8 hours of the accountant's time each month.
- Once a month, the IT department of a international heavy equipment manufacturer generated a set of critical data tables that were used by all of the departments through out the company. The process took 8 hours.
- Automation was introduced, the time was reduced to 1.5 hours, and it was run nightly and unattended.
In the latter two examples, a complete process had already been developed by the customer. With the power of automation that same process could be run automatically, eliminating the need to develop and test a new one. Such changes to automation can result in a considerable savings. We can help. Contact us.
Database Customization - Taking your database to the next level If you have an MS Access™ application that you need to take to the next level, we can help. - Do you have the knowledge but not the time?
- Do you have the time but not the knowledge?
- Whatever your needs.
Let us work with you to analyze your present database and determine the best course to follow. We can help. Contact us.
Data Conversion - Bringing it all together Every time that data must be copied from one application into another, the data flow is interrupted and the company loses money. We can help. - For legacy data that is in a format that is no longer used, a one time conversion will be needed..
- For data that is received in one format but is used in another, an on going process is needed.
- For large one-time projects and for on-going processes, a data conversion application can be a cost saving measure. An application can convert data and be operated by a user. A developer is not needed. You pay a one-time fee and the cost of data conversion is reduced each time the data conversion application is used.
We can help. Contact us.
Barcode databases, computers, and even barcode server networks are available. Here at CY Databases we know that a barcode is nothing more than a printer font. It requires a special reader to read the barcode. Any field in any database that will accept input from a keyboard will accept the input from a barcode reader. Licensed third party software is required to print barcodes and most good quality printers can be used. Barcodes in conjunction with a database can greatly simplify inventory control. CY Databases has experience in designing barcode codes and integrating them into a database system. We will be happy to work with you to integrate barcode functionality into your project. We can help. Contact us.
The login functions described below control user access but they do not provide true security. Only MS Access™ User and Group security can provide true security for an Access database. Most of our customer find login functions sufficient but if your data requires the most secure environment possible we can help. MS Access™ User and Group security requires - A developer to design and create a system
- Special installation, security files, and custom shortcuts.
- An onsite security administrator.
CY Databases has applications that simplify setting up and maintaining true security. CY Databases can provide the training for your onsite administrator. We can help. Contact us.
Emergency Service - Help when you need it the mostHere at CY Databases we understand that when a database in use goes down, a company is in trouble. We give data emergencies our top priority. - A single corrupted data item in a database can partially or completely disable a database
- We have many techniques to quickly find and remove bad data.
- Recurrent errors are can be caused by a variety of reasons
- We can help you analyze your database structure and use to identify sources of recurrent errors.
- Together we can develop and implement a plan to eliminate them.
We can help. Contact us.
Database Design and Development - Design Philosophy and EssentialsPlanningOur databases begins with a plan - a plain English document that simply, yet completely, describes the project. It’s content is agreed upon by all parties before development begins. A database plan helps to eliminate false expectations, and helps to insure that the end product addresses the need that it was created for. The more complex the project the more important a comprehensive plan becomes. A comprehensive database plan will allow us to create a reasonable project plan and to establish development goals or plateaus. With these development plateaus we can measure our progress. We can divide the project into logical sections or modules. With a modular design, changing or adding to the structure will be greatly simplified. Development Every effort is made in the design of the database for efficiency, ease of use, and data accuracy. The three elements compliment one another. An efficient table design reduces the number of forms and other structures needed. The easier it is for the user to enter or retrieve data, the less chance for error. Our approach is to use Access defaults and Wizards when possible and code from our extensive library. New code will be written only when needed. Basic elements of our databases: - Tables
- A simple normalized table structure to house your data efficiently and provide for minimal retrieval times.
- The table structure of the database will prevent duplicate data.
- All tables will time stamp new records and record the last modified date for each record.
- Forms
- Extensive error checking, data validation, auto completion, and look up lists.
- OK, Close, and Cancel buttons
- A color scheme differentiating each from.
- Standardized set of controls and functions.
- Designed for the user to perform their task with a minimum of keystrokes.
- Report generator forms
- A few dynamic reports can be used instead of many static reports
- The users can define extensive criteria for reports.
- The definitions are saved for later use..
- The reports can be recreated or modified on demand.
- User access control
- Custom menus are used
- The database window and default menus are hidden
- The startup bypass function is disabled.
- Separate administrator access to the structure of the database.
- Documentation
- An error log automatically records any errors generated during use.
- A data dictionary will be provided with every database that contains a description of every table, field, form, query, and module in the database.
- Every section of code is documented with remark lines in the code itself.
- An external help document describing all functions of the database is provided.
- When necessary addition training documents and/or Power Point™ presentations will be provided.
- The complete fully documented source code is available for any project for an additional fee.
Other functions that are often requested - Log in functions
- A simple login and password screen.
- “Transparent Security” for our customers on a network can be used to record user information without a user login.
- The user is compared to a security table to control what they can see and do.
- An administrator login to manage security.
- Custom import and export functions
- When the default import and export functions simply will not do the job
- Custom structures to import and export data from other databases, spreadsheets, and text documents.
- Automation
- Generate custom documents and spreadsheets.
- To run existing process with reduced user intervention.
- Email functionality, either automated or on-demand.
- Security
- The login functions described above are not secure.
- Only MS Access™ User and Group security can provide true security for an Access database.
- Requires a developer to design and create a system
- Requires special installation and custom shortcuts.
- Requires an onsite security administrator.
- CY Databases has applications that simplify setting up and maintaining true security.
- CY Databases can provide the training for your onsite administrator.
We can help. Contact us.
| ![[Company Logo Image]](images/logo.gif){kind=logo}
