MS Access Databases

The Service

MS Access databases are used mainly in small to medium sized businesses to control data and decrease the time wasted on repetitive tasks. The power of MS Access is within its range of functionality and its compatibility with other software products. MS Access can :

§ Migrate/Link/Communicate with Excel, Outlook, Word, SQL Server, Oracle or any other software package that has ODBC driver functionality.
§ Produce Custom made reports to your specifications.
§ Produce Custom made VBA code to manipulate data or control processes.
§ Easily be upgraded to SQL Server when the data becomes too large.
§ Have 15 users simultaneous accessing the same database.

How do you get a quote?

1. By sending me an e-mail on the contacts page I can see you are interested.
2. From there I will either e-mail you back or call you on the phone to further investigate in more depth your requirements.
3. If a meeting is required a FREE 2 hour consultation can be arranged to further clarify the specifications for this project.
4. After I have come to an understanding of your specifications, I can present you with a quote outling what needs to be done to achieve your requirements.

How do you get the project started?

If you accept the quote amount I will kindly ask you to read and sign :

1. STANDARD TERMS AND CONDITIONS OF TRADE AGREEMENT
2. PAYMENT SCHEDULE AGREEMENT

Once both of these forms are signed and delivered to me, a 25% deposit of the total quote amount will need to be paid. Once these fund are received I will proceed immediately to work on your project.

During the development of the project we will have regular communication via telephone,e-mail or face to face meetings. If during this time NEW requirements are added to the project, they will be charged out at the STANDARD RATE and added on to the final cost of the project.

All work performed is logged into a database, which in turn allows a minute by minute breakdown of the work done on your project. (PDF format only)

Feel free to view snapshots of various MS Access Databases I have developed below, or even download some of the free sample databases to test what a MS Access Databases looks and operates like.

Note : Free MS Access Database downloads require MS Access 2000 or above to operate.

MS Access Examples

Contacts Database

Stores information on contacts, projects and actions of media. The database is an integral part of this business and it makes monitoring data and producing reports for internal and external needs a very simple process.

BOS Database

Stores information on customers, suppliers, jobs, creditors, debitors etc. The database is an integral part of this business as it controls the progress of each job, integrates the use of Outlook and allows the user to e-mail information including quotes, price requests etc with one click. The 40+ reports are used for internal and external purposes.

Calibration Database

Stores information about clients, types of cables and monitors when the next calibration is due. Created to combine the data from 4 different sources into one single database, it can now easily notify customers that a re-calibration is needed on their cables.

Potato Database

Stores information on seeds and full bins that come in, empty bins and washed potatoes that go out. Used to consolidate existing data from 5 different sources. Also allows easy printing of relevant reports at the click of a button.

The Rap Cella Information Database

The core of THERAPCELLA.COM website is based on a database which stores information about rap music artists, groups, crews, labels, releases, songs, quiz winners, quiz questions etc. This database includes a complex HTML code generator which creates the website. The HTML code generator was developed to overcome the slowness of many complex queries used to present the data via an active server page.

Property Inspection Database

Used to keep track of all inspections details performed by Property Inspection Officers. It allows easy access to each CERCs Property and their past inspections. It is an essential tool for estimating future maintenance costs for properties.

Quote Management Database

Used to combine information stored in a Quickbooks database and excel spreadsheet into a seemless front end. Also allows many important reports to be generated from the 2 sources of information.

Work Log Database

Converted from a very large Excel file to a robust powerful Work Log Database. Keeps tracks of clients personal details , when they visited and what treatment they received. Reports are used to keep bringing back those clients by showing a knowledge of their history and personal details.

Free Downloads

Adobe Premiere PDL Generator

This unqiue product takes information recorded in the provided EXCEL template and creates a PDL File. A PDL file is a file used in Adobe Premiere to allow quick recording of footage from a connected video camera. This is great for clients who know what they want to record but don't want to pay for a professional to spend time with them recording all of the footage. The client simply fills in the excel spreadsheet with the start and end times. They present it to you, you convert it using this program and then open it in Adobe Premiere and before your know it all of the footage is recorded. A great time saver!

Golf Scores Database

For those keen Golf enthusiasts who like to keep track of their scores. This restricted version only allows 4 players and 4 different golf courses to be used. It allows infinite rounds of golf to be entered and provides an easy to update ladder. Each players profile includes the scores for the last 5 rounds, best 9/18 holes of golf, worst 9/18 holes of golf and your current putting average.

Asset Database

Stores information on all of your assets. Description, Date of Purchase, Asset Type, Purchase Location, Asset Location as well as enabling a tracking system to see when and where an item has been. Includes a report to print out for your house insurance company. A quick search engine allows you to find an asset or person very quickly. This and heaps more!

Password Database

Stores all of your passwords in one simple to use database. Application , Account Name, E-mail Address and Password. Can't remember (lost?) your passwords for websites, video stores, telephone banking etc. By default all passwords are hidden and can only be unlocked with the MASTER password (default=password).

© Jasmatuph Creations 2005-2007